Unable to Connect to Google Sheets Spreadsheet on a Team Drive

Published: 15 Dec 2017
Last Modified Date: 17 Nov 2019


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


  • Tableau Desktop
  • Google Sheets
  • Google Team Drive


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.


Tableau's Google Sheets connector can currently only connect to spreadsheets stored in a personal drive. 
Did this article resolve the issue?