Are you still experiencing this error? I quite frequently connect Tableau Desktop to Google Sheets and have not seen this error before. I would try to re-establish the connection to Google Sheets and attempt to connect to the Google Sheet.
Another troubleshooting step would be to recreate the Google Sheet and connect to the newly created sheet.
Hope this helps!
This is the error I get when trying to connect to Google Sheets. It was originally working fine, then I updated some of the data (removed a few rows) and refreshed. After refreshing, this is what keeps happening even if I close the work book or restart the computer. I've even tried adding a new data source with the sheet and I'm still getting the same problem.