The Google Sheets add-on uses oAuth to connect to Google and will automatically keep the connection alive. oAuth provides an efficient way of establishing and maintaining a secure connection to Google.
Although unusual, the Google Sheets add-on may present an error because the oAuth connection to Google has dropped.
You may see this error: json key is missing the client_id field
Potential Reasons for Google Sheets Disconnecting
Your connection to Google Sheets might be dropping due to one of the following reasons:
- Same credentials used on multiple sites (e.g. Staging / Development sites)
OAuth only allows one site to be connected with a specific set of credentials. If more than one site uses the same credentials, they will interfere with each other and cause a disconnect. Only connect one site per credential set. Check that you don’t have a staging / development site that is causing this. - Network issues
A persistent network error between your website and Google’s servers can break the connection. - Password changes
If the Google account password was changed, the connection may be lost and will need to be reauthorized.
How to Reconnect Google Sheets
To reconnect Google Sheets, please follow these steps:
- In WordPress, click on Settings from the WS Form admin menu.
- Click the Google Sheets tab.
- Click on the Disconnect button (if visible).
- Click the Sign in with Google button to reconnect to Google Sheets.
- Follow the online prompts to re-connect WS Form to Google Sheets ensuring you allow the required permissions.
If problems persist, try the above reconnection steps again ensuring that Google prompts for permissions.
Also ensure that you are running the latest version of the WS Form Google Sheets add-on.
Reset App Permissions (Optional)
If the above steps don’t resolve the issue, you may need to remove the WS Form app from your Google account:
- Go to: https://myaccount.google.com/permissions
- In the Third-party apps with account access section, click on WS Form (If it is not present, skip to the next set of instructions).
- Click Remove Access.
- Reconnect WS Form to your Google account using the steps above.
Enable Email Error Notifications
It is possible to receive email notifications if the connection fails in future. To do this please follow these instructions: