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

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.
 

Cause

The .gsheet file exceeds the file size limit for the Google Drive API (10 MB).