Error "connectionSettings is undefined" Connecting to a .gsheet File

Published: 20 Mar 2023
Last Modified Date: 28 Mar 2023


When connecting to a Google Sheet file (.gsheet) using Prep web authoring, the following error may occur:

Something went wrong and the page needs to reload.
Your last changes may be lost when the page reloads.
Error: connectionSettings is undefined

Additionally, the following error messages occur when connecting to the same file:

In Tableau Prep Builder:
Error: Unsupported connection class cloudfile:googledrive-excel-direct

In Tableau Desktop:
An error occurred while communicating with the Microsoft Excel (Google Drive) data source 'Untitled Data Source'
Bad Request: The data source does not contain the expected data.
Error Code: A7AE75CC
Google Drive has rejected this request because of insufficient permissions.


  • Tableau Cloud
  • Tableau Desktop
  • Tableau Prep Builder
  • Google Drive


Try the following workarounds:

Option 1

  1. In a web browser, open the Google Sheet file (.gsheet) and download the .gsheet file as an Excel file.
  2. Upload the Excel file in Google Drive.
  3. Connect Tableau to the Excel file in Google Drive.

Option 2

Split the data among smaller .gsheet files, and then combine them using a Union step.


The .gsheet file exceeds the file size limit for the Google Drive API (5 MB).
Did this article resolve the issue?