I have trying to figure out the same.
Hey Matthew (and everyone else who will read this post),
I talked to Google and Tableau, unfortunately it is an issue with Tableau and not with Google. In theory Tableau has to do some changes in their connector for Google Spreadsheets to ensure a permanent OAuth-Authentification. It should be lot easier in Tableau Server, where it is possible to store the OAuth-information.