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!