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

Issue

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.
Details:
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.

Environment

Tableau Cloud
Tableau Desktop
Tableau Prep Builder
Google Drive

Resolution

Try the following workarounds:

Option 1

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