Anyone facing Google access blocked error?

Questions
1

I have created a project in google console. But when I try to sign in in n8n it says access blocked. ( Google sheets )

I tried it a week ago and it was fine but now i am getting error.

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

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

Welcome @liruanI

this usually happens because your google cloud project is still in testing mode. google expires oauth tokens for apps in testing every 7 days. go to the oauth consent screen in your google cloud console and switch the status to production. once you do that just refresh your credentials in n8n and it should stay connected permanently, also consider updating your n8n to the latest version.

3

Welcome to the n8n community @Liruan

Can you share the complete error from Google, because access blocked is generic.
It’s also worth testing to recreate the OAuth credential in n8n with the redirect URI copied again from the credentials screen, because any small difference in the domain/callback can cause Google to block the login.

4

What is likely going on here is you were working in Google’s OAuth test mode and the token expired. I say this because you mentioned how the timing of this was that it was working a week ago and now it isn’t.

When your OAuth consent screen is set to “Testing” in Google Console, the tokens expire after 7 days which means Google blocks re-authentication until you re-add the user or publish the app.

What you need to do is go to your Google Console’s OAuth consent screen and switch the publishing status from “Testing” into “Production”. No need for formal verification for personal or internal use as publishing removes the 7-day limit.
If you are still blocked after that you can double-check the Google account you are signing in with is listed under “Test users”.

5

Thanks everyone I solved it by upgrading my n8n version.

6

@Liruan we kindly ask that you finalize the post by marking the best answer as a solution to help other community members find assistance.