Google is shutting down its Sheets v3 API, which is the one our platform was using. We have made the necessary changes to work with v4, but this may also require some configuration on your end in your Google account, otherwise, Google Sheet connectors may stop working. These are the same configuration changes that were originally required for v3, but Google did not enforce them all, and so connectors may have still worked even though they were not entirely configured correctly in your Google account.


We, unfortunately, cannot do this for you as it requires accessing your Google account with full administrative privileges. As such, we have made this guide to make the process as easy as possible for you.


The first step is to navigate to your Google connection setup page on our platform. This can be found by using the side menu and navigating to Platform & Billing -> Branding Center.

Once the page loads, look at the top, and select Site Integrations from the top menu.

Note: You may not have all the options listed in the image below if you do not have App as a Service.


On the Site Integrations page, you will see your Google API Access Details. You may need to scroll down if you have many connections set up.


Note: Your Google Client ID, Google Client Secret and Google Redirect URL will be different from what is shown in the image.

Keep this page open, you will need these details soon. Open up a new web browser tab, or window and go to https://console.cloud.google.com. You will need to sign in with the same Google account as the one that was used to set up the connection shown on the Site Integrations page. You can confirm this is the same account, by, after signing in, using the side menu to go to APIs & Services -> Credentials


Under OAuth 2.0 Client IDs, you will see any IDs configured. One of them should have the same Client ID as what is configured in our platform.


Notice the Client ID above is the same as the one in our platform. To view the full Client ID, click on the icon.You will see it on the top-right of the page together with the secret.


If you do not see an OAuth 2.0 Client ID with the same details, you may be using the wrong Google account, or have multiple projects configured for the Google account, and need to switch to the correct project.
You can change projects by selecting your project name at the top of the page. 


You will then a dialog to select a project to use. What you see in this dialog will depend on what projects you have set up in your Google account.


Once you’ve confirmed that you are signed into the correct Google account, and have the correct project set where you can see the correct OAuth 2.0 Client ID, you are ready to begin enabling the Google Sheets API. If you have followed the previous steps, you can just select Library from the side navigation menu as the APIs & Services submenu will already be set there. 


Otherwise, hover your mouse of APIs & Services and then select Library from the popup menu.


On the page that loads, type sheets into the search box.


The page will then show the Google Sheets API. Click on it.


Click on the Enable button.


Wait a while. Once the API is enabled the page will be refreshed and you will be taken to the overview page. Make sure it says DISABLE API at the top of the page.


As a final check, click on Credentials on the side menu.


Make sure this is still the account with the same OAuth 2.0 Client ID as what is configured on our platform. If this is not the case, your Google connectors will not work.