Hi, I got this error when Workflows running. Usually I never seen this error and I see OAuth is working fine. What is happening?
Error evaluating DiffSheets: Access forbidden. Resources with user authentication cannot be called in workflows invoked outside of Agents, Apps, and direct workflow runs.
Hi @yeftanma, how are you triggering this workflow? If it's running on a schedule, through a public API, or some other webhook that doesn't have your user credentials, then it won't have access to your user's OAuth credentials.
You can check "Share credentials between users" in your Google Sheets resource config and reauthenticate, and that should get around this issue. This is good for a personal or small team project.
Alternatively, you might want to set up a google service account as the authentication option, especially if this is for production or long term automation that you don't want to rely on your specific google account.
Hi @Mike_M! yes, I am triggering this workflow via Webhook. Usually in the past couple of days this workflow run smoothly without any error but recently I noticed this issue. Does Retool just recently add this limitation?
Gotcha, yeah no this is not a new limitation so that's interesting that it just started happening.
One possible explanation is something about your google account access has changed, for example if your organization's workspace admin enforces token expiration, then you'd have to reauthenticate periodically.
Or maybe if this workflow is triggered by a Retool App, then when you run it it uses your credentials, but if someone else uses your app then it tries to use their credentials.