Google Sheet credential

[Jannik]

When creating Google Sheet Credentials, the fields to enter the Client ID and Key do not appear in the OAuth2 credentials and the login fails.

The login for Drive and Docs just works, since I have the option to enter Client ID and Key there.

I double and tripple checked, if the sheets API is enabled for the Project in the Google Cloud Console and it is.

I have already read similar forum posts, but I still don’t understand why the access is blocked:

Google Sheet OAuth2 credential

“When creating a Google Sheet, the fields to enter the Client ID and Key do not appear in the OAuth2 credentials. How can I fix this?” [image]

Google Sheets node with Google OAuth2 API credential

HI, I am wanting to use my Google OAuth 2 credential with the Google Sheets nodes so I can use my own API limits as my flow keeps erroring due to too many requests even when I am only sending around 5 per minute, if that. When I try and add the details on the node it only asks me to sign in with Google? I have added my credentials separately as well but it doesn’t give me an option to select them? Google Docs and Google Sides has the option to enter credentials so I do not understand why I can…

[Epicop]

Hey! Google Sheets node in N8n often defaults to using N8n-provided OAuth credentials instead of letting you enter your own Client ID and Secret. This is intentional but frustrating when you hit rate limits. Try creating a new credential and look for “OAuth2 API” or “Service Account” options instead of the standard Google Sheets OAuth. Alternatively, use the HTTP Request node with Google Sheets API directly—that way you have full control over authentication. Worth checking if your N8n version supports custom OAuth for Sheets too.

[enzpic]

Hello,

I am not sure why client ID ans secret doesn’t show there. Can it be store somewhere else ?

for the “access blocked”, i ran into the same issue.
I solved it by enabling a test user in my google cloud authorization, on this particular app that n8n is using.

Google Cloud Platform

Let me know if this already help,

food luck

[Jannik]

@enzpic @Epicop Thank you both for your quick reply.

@Epicop when using the “Google OAuth2 API” I get an Error 400: invalid_request

Request details: flowName=GeneralOAuthFlow

and I am getting the same error, when using the HTTP Request node with a general OAuth2 API authentication.

@enzpic also adding my user as a test user in the google app didn’t solve the problem unfortunately.

[enzpic]

Interesting :

do you have a pop up blocker ?

I see that @skb had similar issue some times ago.

https://community.n8n.io/t/issue-configuring-oauth2-with-gmail-on-n8n-cloud/71068/7

maybe this ?

[Jannik]

No, the Google pop up isn’t blocked.
I now managed to use the “Google OAuth2 API” in combination with the http Request. It is essential to add https://www.googleapis.com/auth/spreadsheets as a resource to the Scope of the Google OAuth2 API Credentials in n8n.

Still no idea why the Google Sheets node Credentials aren’t working, even if I click ‘Request Access’ when I am prompted withe message ‘Access blocked’ our administrator of the organisation is not getting a request.

Anyhow, I am using the Google OAuth2 API in combination with direct http requests to the google sheets API now.