whollacsek Posts - Windmill

whollacsek

•Created by whollacsek on 1/11/2024 in #help

Gsheets token not refreshed when used by other users

I've created a flow that uses gsheets integration, however when the flow is run by another user this error is thrown:

AxiosError: Google API error - [401] Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.
Error: 
    at new AxiosError (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/AxiosError.js:21:4)
    at settle (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/settle.js:2:0)
    at handleStreamEnd (/tmp/windmill/cache/bun/axios@1.6.5/lib/adapters/http.js:589:9)
    at endReadableNT (native)
    at processTicksAndRejections (native)

AxiosError: Google API error - [401] Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.
Error: 
    at new AxiosError (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/AxiosError.js:21:4)
    at settle (/tmp/windmill/cache/bun/axios@1.6.5/lib/core/settle.js:2:0)
    at handleStreamEnd (/tmp/windmill/cache/bun/axios@1.6.5/lib/adapters/http.js:589:9)
    at endReadableNT (native)
    at processTicksAndRejections (native)

When this happens I need to manually run the flow myself for it to work, afterwards for a period of time the other users can run the flow as well until the error appear again. The flow and all resources are in a folder that has the group 'all' assigned. I can't find anything in the documentation or online talking about managing token refresh. Can anyone help me with this?

14 replies