Problem establishing Google Spreadsheet Oath account

Questions
,
1

Describe the problem/error/question

Can’t connect to oath 2 Google Spreadsheets account. Getting error all the time. Worked fine week ago, now receiving each time error mentioned below. Have rechecked the redirect url several times, it is correct. Replacing localhost and port given in the node with my domain and receiving error all the time

What is the error message (if any)?

redirect_uri_mismatch

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: self hosted
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu
2

Hey @myshyak hope all is well.

redirect_uri_mismatch is indicative of two urls not being the same - the one in your credentials node and the one you have provided to GCP.

3

The only difference on them is replacement of localhost with my domain. Everything else is the same, checked twice.

4

Don’t replace the values, if the URLs do not match the magic won’t happen.
What you need to do is set the WEBHOOK_URL env variable and restart your instance.

5

Thanks, world reckeck it tomorrow. The webhook URL shows now http://localhost:5678/rest/oauth2-credential/callback despite WEBHOOK_URL is given in the docker compose environment parameters

6

See if also setting either or one of the following helps.

  • N8N_HOST
  • N8N_EDITOR_BASE_URL

and make sure to reload the instance after changing those.