The community member was using a bot to check addresses connected to 10 spreadsheets, but the bot stopped functioning as the sheets had become deselected. The community member had to reissue permission for the sheets to have access, and is unsure if this issue will reoccur.
In the comments, another community member asked if the original poster was self-hosting or using typebot.io. The original poster confirmed they were self-hosting. Another community member had a similar issue and resolved it by validating the whole integration again. A third community member provided a potential solution, stating that the issue mainly happens if the client ID is not approved, and provided a link to Google's documentation on the issue.
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
