Google sheets credencials

I ’ m creating google sheets credentials to create a google sheet
where can I get Authorization URL and Access Token URL

(i’m using self-hosted n8n)


Hello, @sfortus Welcome to the community :tada:

I recommend watching this video and following the steps:

Feel free to ask any questions if you run into any issues!

thks for the video sbut this video like all the other ones , only theach to get Client ID and Client Key , I don’t know why my credentials ask for them but ask for this 2 more fields that I don’t see anywhre documentations about it

as you can see here there are 4 fields and not 2

1 Like

I see,
are you on the community version? and what’s the n8n instance version number?

About n8n

n8n Version

1.84.1

Source Code

License

Sustainable Use License + n8n Enterprise License

1 Like

I’m not exactly sure, but try these:
Authorization URL: https://accounts.google.com/o/oauth2/v2/auth
Access Token URL: https://oauth2.googleapis.com/token

2 Likes

@sfortus, to obtain your Google OAuth 2.0 client ID and client secret for accessing Google APIs like Google Docs, follow these steps:

  1. Visit the Google API Console: Navigate to the Google API Console.

  2. Create a New Project:

    • Click on the project dropdown at the top of the page and select “New Project.”
    • Enter a project name and click “Create.”
  3. Enable the Google Docs API:

    • In the left sidebar, click on “APIs & Services” > “Library.”
    • Search for “Google Docs API” and click on it.
    • Click “Enable” to activate the API for your project.
  4. Configure the OAuth Consent Screen:

    • In the left sidebar, click on “APIs & Services” > “OAuth consent screen.”
    • Select the “External” user type and click “Create.”
    • Fill in the required fields, such as “App name,” “User support email,” and “Developer contact information.”
    • Click “Save and Continue.”
  5. Create OAuth 2.0 Credentials:

    • In the left sidebar, click on “APIs & Services” > “Credentials.”
    • Click “Create Credentials” and select “OAuth 2.0 Client IDs.”
    • For “Application type,” choose “Web application.”
    • Under “Authorized redirect URIs,” add the URI where your application will handle responses from Google’s OAuth 2.0 server (e.g., https://yourdomain.com/oauth2callback).
    • Click “Create.”
  6. Obtain Client ID and Client Secret:

    • After creation, a dialog will display your new client ID and client secret.
    • Click “OK” to close the dialog.
    • On the “Credentials” page, you can view and manage your credentials.

Let me know if it helped :smiley:

1 Like

i found the problem, with new versions of n8n google sheet credentials now ask for this 2 addicional fields , what we need to put in there is :slight_smile:
Recent updates to n8n’s Google Sheets integration now require users to input additional OAuth2 configuration details, including Authorization URL and Access Token URL, alongside the traditional client ID and client secret for setting up Google credentials.

OAuth2 Configuration Overview

OAuth2 configuration for Google Sheets in n8n now requires additional fields beyond the traditional client ID and secret. This expanded setup includes:

  • Authorization URL: https://accounts.google.com/o/oauth2/auth
  • Access Token URL: https://oauth2.googleapis.com/token
  • Grant Type: Authorization Code
  • OAuth Redirect URL: Provided by n8n (e.g., https://YOURDOMAIN.COM/rest/oauth2-credential/callback)

These changes align with updated requirements in newer versions of n8n, ensuring a more comprehensive and secure integration with Google services12.

Users must carefully configure these settings in both n8n and the Google Cloud Console to establish a successful connection.

15 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.