Last Modified Date: 05 Oct 2017
- Tableau Desktop
- Tableau Server
Google SheetsTo connect to Google Sheets data sources, use the native connector in Tableau Desktop. For more information, see Tableau Desktop Product Help: Google Sheets.
Google DriveTo connect to other Google Drive files, use the Web Data Connector to create a custom connection. For more information, see Web Data Connector.
CauseThe ability to connect directly to Google Drive data sources is not functionality currently built into Tableau Desktop.
Additional InformationFor more information about Web Data Connector, see Tableau Community: Web Data Connector in the Community.
A live connection to the Google Sheets will result in a prompt for the Google Sheets username and password when opening the workbook even when the workbook is shared with a recipient to view with Tableau Reader - with the exception of when the user already is signed into the same Google account on the same computer being used to view the workbook.
When a Tableau Desktop workbook is connected to a data extract of the Google Sheets data source, opening the workbook does not require a Google log-in - unless the data extract is refreshed.
To share a workbook with an extract from a Google Sheets data source for the data to be refreshed, publishing the extract to Tableau Server and sharing with Tableau Server account users is an option for Tableau Server users.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials