Google Sheets Disconnected
I was using my bot to check addresses, this is connected to about 10 spreadsheets, then randomly it stopped functioning as all my sheets had become deselected, had to reissue permission for sheets to have access. Not sure if this will reoccur
4 Replies
Are you self hosting or using typebot.io?
I had the same issue and was solved when I validated the whole integration again
@William Lewis Self hosting
it mainly happens if the client id is not approved - link is provided in the docs - https://developers.google.com/nest/device-access/reference/errors/authorization#refresh_token_keeps_expiring
you'll need to get you app to published and provide google with all that they need before they approve
Google for Developers
Authorization Errors | Device Access | Google for Developers