After mapping a Google Drive to a local folder, it is unable to use the Google Sheets (.gsheet) file in Tableau Desktop / Tableau Prep. If the file is in Excel format, it can be specified, but if it is in spreadsheet format, it will not appear in the Connections window.
If you drag and drop the .gsheet file into Tableau Desktop / Tableau Prep, the below error will occur:
This file is not in a recognizable format. See the Help documentation for a list of the supported file types.