Skip to main content
harishbabub6381
harishbabub6381
June 19, 2025
Question

Google Sheets Connected System Requires Frequent Reauthorization (OAuth 2.0)

  • June 19, 2025
  • 8 replies
  • 0 views

I'm using a Google Sheets connected system in Appian with OAuth 2.0 authentication. The integration works initially, but I'm encountering an issue where the connection requires reauthorization almost every hour.

Has anyone faced a similar problem with token expiration or session persistence? Is there a recommended way to maintain or refresh the token without requiring manual reauthorization so frequently?

Appreciate any suggestions or best practices to resolve this.

    8 replies

    harishbabub6381
    harishbabub6381Author
    June 19, 2025

    [mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05] [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] [mention:65b14048184a4eb5aff3a76c87b97431:e9ed411860ed4f2ba0265705b8793d05] 

    Could you please assist me with this issue?

    stefanhelzle0001
    stefanhelzle0001
    June 19, 2025

    Do you use any user based authentication? Then I would expect the token to expire.

    harishbabub6381
    harishbabub6381Author
    June 19, 2025

    Yes, we are using user-based authentication via OAuth 2.0 in our Google Sheets connected system. how to over come these issue 

    stefanhelzle0001
    stefanhelzle0001
    June 19, 2025

    Isn't there any documentation for that plugin?

    harshas2775
    harshas2775
    June 19, 2025

    I have not worked with this connected system personally but these are my 2 cents -

    The lifetime of an authentication/authorization depends on the token type involved. As per Googles' Access Token Documentation by default, access tokens are good for 1 hour (3,600 seconds). Looks like in your case also, the token type involved is of same kind. The above documentation also mentioned a method to extend token lifetime up to 12 hours.

    Another way to extend the session is to work with both Access and Refresh tokens so that reauthorization happens in the backend using refresh tokens but personally, I feel there can be some overhead to maintain the access-refresh tokens for a user. So it needs careful consideration. 

    Hope this sends you in a direction to have a discussion with your API team to resolve this.

    harshas2775
    harshas2775
    June 19, 2025

     [mention:4e41e0cb07984d22b9e99dfeabe2f50b:f586769b0822468ab7f3a94d480ed9b0] 

    Please check this thread as well. 

    Terms & ConditionsAccessibility statement