Google Sheets - Need to re-auth?

Questions
1

Describe the problem/error/question

I setup a Google Sheets OAuth2 API cred, and it works for a couple of days - then it stops working and I need to re-auth. Is there some kind of expiration I need to adjust?

Share the output returned by the last node

Could not find any entity of type "CredentialsEntity" matching: { "id": "19", "type": "googleSheetsOAuth2Api" }

Information on your n8n setup

  • n8n version: 0.226.2
  • Database (default: SQLite): mariadb
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu Server
2

hi @Tzvi_S :wave:

Out of curiosity, is this happening about every seven days or so for you?

If so, you might need to publish the OAuth2 client you have registered with Google, as for test users the authentication will expire after seven days as per Google’s documentation :

Authorizations by a test user will expire seven days from the time of consent.

So to avoid running into this you would need to publish your application or consider using a Google Workspace account which would allow you to create an Internal OAuth client only accessible to users within your organisation.

Let me know if that might be the case!

2 Likes
3

Yeah that sounds about right. I’ll publishing it then. thanks!

2 Likes
4

Glad we could figure that one out quickly for you, @Tzvi_S :tada:

2 Likes
5

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