Need Help connecting google sheets

I’m having trouble connecting google sheets.

  1. Connected the credentials properly, review setup.

  2. after that it’s asking me for sign in but instead of the account I’ve put creds for it’s stuck to one of my account and only shows Access blocked, so can’t sign in.

I need help, I’m a beginner in n8n.

Version: 1.29.1
self hosted.

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:

hello @Jennifer_Madison

The error says that your redirect URL is not valid, that’s why you are receiving the Access Blocked page.

According to Google validation rules, you can’t use HTTP and private hosts in the URL.

So you have two options:

  1. use localhost instead of IP
  2. use Service Account instead of Oauth 2.0