Please make sure you have followed the steps in the following documentation for setting up OAuth for Google and Tableau.
I would double check the permissions on the account being used to access the data on Google Sheets as well. If the error is continuing, I would open a case with Technical Support, Support Case | Tableau Software.
Please share any resolution that might be found for other Community Forums members that might come across this post.
Hope this helps!