Upgraded from Tableau 2021 to 2023 and noticed google sheets connector is no longer available. Tried google drive connector and getting the below error.
@Wilson Tang
Hi, Tableau Server or Tableau Desktop?. Very probably, Tableau Server. In this case, you would need to create an Oauth app in Google Console, and register it in Tableau Server:
Starting Tableau 2022.3, in Tableau Server you must configure a Google Custom Oauth . You can take a look of:
https://console.cloud.google.com/apis/credentials
https://kb.tableau.com/articles/Issue/connecting-google-drive-datasource-in-tableau-server-2022-3
a. In Authorized Javascript Origins, insert the URL of your Tableau Server (https://www.yourserver.com)
b. In Authorized Redirect URLS, use your server URL plus /auth/add_oauth_token (e.g. https://www.yourserver.com/auth/add_oauth_token)
c. Take note of the client id and secret id
Also, make sure to enable Google Drive Api in google console to the project where you are configuring Google Auth. Enabled APIs & Services, Enable APIs and services button on the top, and search for Google Drive API, and enable it.
Finally, in Tableau Server, in your site, go the settings section of the site, then in general scroll down to:
Then, paste your Client ID, Secret ID and your redirect URL (e.g. https://www.yourserver.com/auth/add_oauth_token):
Then, clic on Add Oauth Client, and then clic on Save Changes Button in the upper section.
Finally, recreate your authentication tokens, in the settings page of the user.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
