Google Sheet Auth – Reconnecting weekly

Questions
1

I have to reconnect the Google Sheet Auth like once a week. Is there a way to make this stick? It breaks a lot of workflows for me.

Version 1.37.3, default database, hosted on digital ocean (docker).

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

hello @HolgerKurtz

How have you configured the Google sheet API? Via service account, OAuth 2.0 or API Key?

1 Like
4

Hi, thanks for your help. I’m using
Google Sheets OAuth2 API with OAuth Redirect URL, Client ID and Client Secret

My OAuth consent screen was set to “testing”. I changed it to production. Let’s see if that helps.

5

Yes, that should resolve the issue. Test mode have very limited token lifetime

6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.