Last Modified Date: 14 Aug 2019
- 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 DriveIn 2019.1 and newer versions, use the native Google Drive connector.
In older versions, use a 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 was added in Tableau Desktop 2019.1.
Additional InformationFor more information about Web Data Connector, see Tableau Community: Web Data Connector in the Community Forums.
A live connection to 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, unless the user already is signed into the same Google account on the computer being used to view the workbook.
When a Tableau Desktop workbook is connected to a data extract of a Google Sheets data source, opening the workbook does not require a Google log-in. Refreshing the extract does require a Google log in.
To share a workbook that uses a Google Sheets extract and keep the data fresh, publish the extract to Tableau Server or Tableau Online.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials