Credentials through Google Console - help

I am used to enter credential to a node to sign up through my Google account. But here, for this Google Sheet node, it seems I need to go through Google Console to create my OAuth authentication. Could you help me with the process ?

1 Like

Have you tried this video for help?

After googling the right thing, I found the Google Gemini api_key I had already created.

How do I close this post?

Hi, could anyone help me?

I have no technical background, and I am stuck. I follow a course and am working on my first project, which will be a booking chatbot. The info should be extracted in a Google Sheet doc; however, I registered to Google Console, and when I wanted to do the OAuth, I did not have any option in n8n to find any kind of client ID or URI link or whatsoever. I made a screenshot; please check that out. How should I connect them? The Google Sheets API is enabled in the console.

Hi,

I’m not sure if you already fixed this but all you need to do is sign in with google assuming that you configured the redirect URI on google console

have you solve the problem? i’m having the same issue

That’s expected — the Google Sheets node doesn’t offer the one-click Google sign-in (that’s only available for a few integrations). You need to create your own OAuth credentials in Google Cloud Console. Here’s the full process:

  1. Google Cloud Console → create a project (or use an existing one).
  2. APIs & Services → Library → enable the Google Sheets API (and Google Drive API too — it’s often required).
  3. OAuth consent screen → configure it (choose External, and add your own email as a test user).
  4. Credentials → Create Credentials → OAuth client ID → application type Web application.
  5. In n8n, open the Google Sheets credentials → copy the OAuth Redirect URL n8n shows you → paste it into Authorized redirect URIs on the Google side.
  6. Grab your Client ID and Client Secret → paste them into n8n → click Connect / Sign in.

The thing that trips up most people: the redirect URI has to match exactly what n8n displays — otherwise you’ll get a redirect_uri_mismatch error.

Hope that unblocks you! If you hit a redirect_uri_mismatch or run into something trickier down the line, I do flat-rate n8n fixes — happy to take a look: Fix My n8n Workflow — Expert n8n Debugging & Rescue | Interconnect Market

in this flow here: Fully Automate YouTube Thumbnail Uploads with n8n and n8n-nodes-thumbapi (Step by Step)

First part google auth i added full part for google Oauth2 connection.
I belive you also need to add youserlf your email as a tester to your project. In this example i provided its used for youtube scope, so when you are doing auth with google just change the scoe for example you will need google drive or something. In my case i used youtube for thumbnail uploads.
It is working 100%. If you run in any trouble contact me ill help no problem.