Google Sheets Extension - TokenResponseException

Localization
1

I tried to pull my changes to a google sheets doc that had been working fine for several weeks, but I got an exception when I hit the pull button-
TokenResponseException: Error:"invalid_grant", Description:"Token has been expired or revoked.", Uri:""

I looked in the library folder under Google where the token is supposed to be and there was nothing there, despite this having worked fine for two weeks. So, I tried to reauthorize in the Google Sheets Service asset, which did authorize successfully, but still no token and I still get the error.

So, I tried deleting the Google Sheets Service asset and making a new one with the same client id and credentials, and that worked and I have a token in the library folder-. but then I am left with a bunch of broken references because of the deleted asset. Not a big deal to clean up, but I wonder why this token file mysteriously disappeared and why reauthorizing doesn’t seem to work.

2

Hmm. I have not seen this before. Deleting the library cache should be all you need to do to reset it. A quick Google shows that this error may be something that fixed itself after a certain amount of time so maybe that was the issue. Google OAuth “invalid_grant” nightmare — and how to fix it | by Lasse B. Andersen | Inside Timekit