Connect Google Sheets with n8n

Before we jump into connecting Google Sheets with n8n, let’s make sure you have everything ready. A Google Cloud Project It’s where we’ll enable the Google Sheets API and an n8n Instance.

Create a New Project on Google Cloud Console

Head over to https://console.cloud.google.com make sure you're signed in with your Google account.

• Click the project dropdown at the top left (next to “Google Cloud” logo).

• Click "New Project"

• Give your project a name you’ll remember (like “my-n8n”) and click Create.

Enable the Google Sheets API

• In the search bar at the top, type:
  Google Sheets API

• Click on the result that says "Google Sheets API".

• Click the "Enable" button.

Enable the Google Drive API

• In the search bar at the top, type:
  Google Sheets API

• Click on the result that says "Google Sheets API".

• Click the "Enable" button.

Create Credentials

• Credential Type

  • Which API are you using? choose Google Sheets API

  • What data will you be accessing? choose User data

• OAuth Consent Screen

  • App name: my-n8n

  • User support email: (input your email)

  • Developer contact information : (input your email)

• Scopes (optional)

  • Add or remove scopes: enable all Google Sheets API=

• OAuth Client ID

  • Application Type: Web Application

  • Name: my-n8n

  • Authorized redirect URIs

    Copy the OAuth Redirect URL from n8n there and paste it here under Authorized redirect URIs

    • In the google sheets node, go to: Credential to connect with > Create New Credential

    • Select OAuth2 (recommended)

    • OAuth Redirect URL example: http://localhost:5678/rest/oauth2-credential/callback

  • Create

Set Up Google Sheets Credentials in n8n

After Creating OAuth Client in Google Cloud you will get a Client ID and Client Secret, next Copy both — you’ll need them to complete the setup in n8n

• In the google sheets node, go to: Credential to connect with > Choose your Credentials

• Client ID: (Paste from Google Cloud)

• Client Secret: (Paste from Google Cloud)

Scroll down and click “Connect” or “Sign in with Google” if pop up show as Access blocked, you need to complete google verification process.

• Back to Google Cloud Console

  • go to API & Services and then OAuth consent screen > Audience

  • Test users : Add user (Input your email)

Back to n8n and then click “Sign in with Google” again.

• A Google sign-in window will pop up:

  • Select your Google account

  • Grant the requested permissions (click Allow)

• Once authorized, click Save