Using n8n deployed with Docker and Ngrok, I get the following error when trying to log in to Google Sheets: Error 400: invalid_request. How can I resolve this? Thank you!

[Dily]

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):Docker
• Operating system:Windows

[fahmiiireza]

hi there @Dily , the problem i think is more on how you setup the google cloud console

here are the things that you need to verify and make sure that you already set it up correctly:

• setup oauth consent screen
• add your email as a test user
• add authorized redirect URI in the credential, Ensure the Redirect URI matches exactly with what n8n shows (including https, no trailing slash, etc.).
• If the Ngrok subdomain changes, you’ll need to update the redirect URI again.
• add your domain as the allowed/authorized domain from the google cloud console app

i hope this can guide and help you solve your problem!