How To Connect N8N with Google Sheet Node, AI Automation

Hey everyone! If you’re diving into the world of AI automation, you’ve probably heard about n8n. It’s this incredible open source platform that lets you automate pretty much anything. But here’s the thing. Most powerful automations start with data, and where does most of us keep our data? You guessed it. Google Sheets.

In this guide, I’m going to walk you through connecting n8n with Google Sheets in the simplest way possible. No fluff, no technical jargon overload. Just straight up steps that work.

Why Connect n8n to Google Sheets?

Before we jump in, let’s quickly talk about why you’d want to do this. Once connected, you can:

• Automatically append new data to your sheets
• Trigger workflows when someone adds a new row
• Update existing records based on AI actions
• Build powerful automations that feed data in and out of your spreadsheets

Pretty cool right? Let’s get started.

Step 1: Create Your n8n Workflow

First things first. Log into your n8n instance and create a new workflow. Once you’re in, you’ll want to add a Google Sheets node. Just click the plus icon and search for Google Sheets.

You’ll see a few options pop up:

• Triggers like On Row Added or On Row Updated. These start workflows automatically.
• Actions like Append or Update. These do stuff in your sheets.

For this tutorial, I’m going to show you how to set up the connection using an action node, but the credential setup is the same regardless of which one you pick.

Step 2: Start the Credential Setup in n8n

Click on your Google Sheets node, and you’ll see a field asking for credentials. Click Create New Credential. You’ll be prompted for a Client ID and Client Secret.

Now don’t close this window. You’re going to need something from it in a minute. See that OAuth Redirect URL? Copy it. You’ll need to paste this into Google Cloud Console.

Step 3: Set Up Google Cloud Console

Head over to console.cloud.google.com.

Quick heads up. You’ll need to enable billing for your project. Don’t worry. Google won’t charge you for using these APIs, but they require a billing account on file. Just add your payment method and you’re good to go.

Create a New Project

Click on the project dropdown at the top, then click New Project. Name it something you’ll recognize. I used Google Sheet n8n Tutorial, and click Create.

Once it’s created, make sure you select that project from the dropdown.

Enable the Google Sheets API

Click on the navigation menu, those three bars in the top left, go to APIs & Services, then click Enable APIs and Services. Search for Google Sheets API, click on it, and hit that Enable button.

Step 4: Configure the OAuth Consent Screen

This step trips a lot of people up, but it’s actually pretty straightforward. From the APIs & Services menu, click on Credentials, then click Create Credentials and select OAuth client ID.

Since this is your first time, it’ll ask you to configure the consent screen. Click Configure Consent Screen and then:

1. Choose External. This lets you add test users later.
2. Name your app. I used n8n Google Sheet.
3. Add your email address.
4. Click through the next screens, adding your email again when asked.
5. Agree to the terms and click Continue.

Once that’s done, you’ll be back at the Create OAuth client ID screen.

Step 5: Create Your Client ID and Secret

Back on the OAuth client ID creation page:

1. Set Application Type to Web Application.
2. Give it a name. I used n8n Sheet Tutorial.
3. Under Authorized redirect URIs, click Add URI and paste that redirect URL you copied from n8n earlier.
4. Click Create.

Boom! Google will now show you your Client ID and Client Secret. Copy these immediately and paste them somewhere safe. Google won’t show them to you again for security reasons.

Head back to n8n, paste in your Client ID and Client Secret, and click Save.

Step 6: Sign In and Fix the Access Denied Error

Now click Sign in with Google in n8n. Choose the Google account you want to connect.

If you get an Access Denied error, don’t panic. This is super common. It just means the email you’re trying to connect isn’t listed as a test user in your Google Cloud project.

Here’s how to fix it:

1. Go back to Google Cloud Console.
2. Navigate to APIs & Services then OAuth consent screen.
3. Scroll down to Test users.
4. Click Add Users and add the email address you’re trying to connect with.
5. Click Save.

Now go back to n8n and try signing in again. This time it should work. You’ll see a warning that Google hasn’t verified this app. That’s completely fine since you’re the one who created it. Click Continue and grant the permissions it asks for.

Step 7: The Step Everyone Forgets: Enable Google Drive API

This one got me the first time too. You’ve connected successfully, but when you try to select a spreadsheet in n8n, you might get an error or see nothing at all.

Why? Because Google Sheets live inside Google Drive. You need to enable the Google Drive API too.

Head back to APIs & Services, click Enable APIs and Services, search for Google Drive API, and enable it.

Now go back to n8n, refresh that dropdown, and all your sheets should magically appear!

You’re Connected! Now What?

Congratulations! You’ve successfully connected n8n with Google Sheets. Now the real fun begins. You can start building automations that read from your sheets, write to them, or trigger workflows when data changes.

I’ve created a whole playlist of n8n tutorials covering everything from beginner basics to advanced AI automations. I’ll link it below so you can keep learning.

Quick Recap

1. Create a new n8n workflow and add a Google Sheets node.
2. Copy the OAuth Redirect URL from n8n.
3. Set up a Google Cloud project and enable the Sheets API.
4. Configure the OAuth consent screen.
5. Create your Client ID and Secret with the correct redirect URI.
6. Add your email as a test user if you get access denied.
7. Enable the Google Drive API.
8. Connect and start automating!

Conclusion:

If this guide helped you, consider subscribing to WebSensePro. I’m constantly putting out content on AI automation, web design, and development. The tech world moves fast, and staying up to date with AI automation is one of the best ways to stay competitive in your field.

Got questions? Drop them in the comments below. I read every single one and try to help however I can.

Until next time, happy automating!