KNOWLEDGE BASE

Unable to Connect to Google Sheets Spreadsheet on a Team Drive


Published: 15 Dec 2017
Last Modified Date: 19 Mar 2018

Issue

When trying to connect to a Google Sheets spreadsheet saved to a Google Team Drive, the following error occurs:
The URL you entered is invalid or points to a Spreadsheet you don't have permission to view

Environment

  • Tableau Desktop
  • Google Sheets
  • Google Team Drive

Resolution

Use the following workaround:
  1. Create a new Google Sheets spreadsheet in My Drive in Google Drive. 
  2. Use the IMPORTRANGE function to reference the spreadsheet in Team Drive.
  3. Connect Tableau Desktop to the Google Sheets spreadsheet located in My Drive, which will reflect any changes made to the original Team Drive spreadsheet. For more information, see Google Sheets.

Cause

Tableau's Google Sheets connector can currently only connect to spreadsheets stored in a personal drive. 

Additional Information

To voice your support for the inclusion of this enhancement in a future product release, add your vote to this Community Idea.
Did this article resolve the issue?