Skip to main content
Question

Refresh Token for Google Sheets Connection

  • February 22, 2026
  • 2 replies
  • 19 views
G
Forum|alt.badge.img+1

I am using the community edition.  I want to use a Google Sheet in my application.  I have successfully created a Google project.  I have created the AppId and secret.  I have used the “Connect” activity for Google Sheets in code and entered my AppID, Secret and user email.  I have successfully connected and navigated Google Sheets (I have not used the Control Room connector - as I don’t think it is available to Community edition).  However, because I am in Test mode (I am doing this just for my own learning), apparently I have to refresh the token every 7 days.  How do I refresh this token??

I have not seen anywhere to store this refresh token in the Connector so I am thinking I have to do it directly in Google, but where?

Thanks for your time.

    2 replies

    dgabbad369
    Forum|alt.badge.img
    • dgabbad369
    • Cadet | Tier 2
    • February 23, 2026

    Hi ​@Gregg 3454 , You can try below solution.

    In Testing mode you cannot make the refresh token “permanent.” You must either periodically re-consent or switch to a setup that doesn’t have the 7‑day limit.

    So try to move the OAuth app to Production in Google Cloud

    This removes the 7‑day refresh token expiry (tokens can last indefinitely unless revoked). You might need verification depending on the scopes.

    Steps (high level):

    1. Go to Google Cloud Console → APIs & Services → OAuth consent screen.
    2. Change publishing status from Testing → In production..
    3. After publishing, perform a fresh consent once via your bot’s Connect flow so a new (non-7-day) refresh token is issued.

    Pros: No more weekly re-consent.

      G
      Forum|alt.badge.img+1
      • Gregg 3454
      • Author
      • Cadet | Tier 2
      • February 24, 2026

      Thank you for the information.  It is helpful.  I am not quite ready to request verification.  I think right now I am ok reauthorizing every 7 days until I have this figured out better.  BUT, my question is, how do I re-authorize the token.  It seems like I should be able to do this somehow, but I do not understand where to require the reauthorization in Google or how to accomplish it in AA?

      Terms & ConditionsCookie settingsAccessibility statement