How to Set Up n8n Google Sheets Integration

n8n is an open-source workflow automation tool that helps connect various services in a visual, no-code environment. This tutorial focuses on pairing n8n with Google Sheets to help us automate repetitive spreadsheet workflows.

How do you integrate n8n with Google Sheets?

Before automating, you need to connect Google Sheets to n8n. To connect n8n with Google Sheets, you’ll need to set up the Google Cloud Console and link it with n8n. To integrate n8n with Google Sheets, follow these six steps:

1. Build an n8n workflow
2. Create a Google Cloud project
3. Enable the Google Sheets API
4. Create OAuth credentials
5. Add Client ID and secret to n8n
6. Test your n8n workflow

Let’s explore each step in detail.

Step 1: Build the n8n workflow

Let’s start by setting up the workflow in n8n that will eventually connect to Google Sheets. Here are the steps to build an n8n workflow:

1. Visit the n8n website and log in with your credentials.

2. Select the “Create workflow” option available on the n8n dashboard.

3. Select the “Add first step” and then from the menu on the right side, select the “Trigger manually” node.

4. Now we need to connect another node to this trigger, the Google Sheets node. To do that, select the “+” (add node) on the trigger.

5. Search for the Google Sheets option in the menu that appears after selecting the “+” option. Inside Google Sheets, select the “Create spreadsheet” option.

6. Once the Google Sheets node is connected, a dialog box will appear as follows:

7. Here, select the “Credential to connect with” and choose the “Create new credential” option.

8. Sign in with your Google account and select Save.

Note: In the free version of n8n, Google Sheets authentication works with the default built-in credentials. In the paid version, users get an option to enter their own client ID and secret key directly after connecting the Google Sheets node.

Once this workflow is set up, we need to set up our Google Cloud Console.

Step 2: Create a Google Cloud project

Next, we’ll set up a dedicated Google Cloud project to keep your Sheets credentials tidy and isolated. This gives a clean place to enable the API and create OAuth keys for n8n.

Do the following:

1. Go to Google Cloud Console and sign in if you haven’t.

2. Choose the “Select a project” option from the top and then select “New Project”.

3. Name the project (e.g., n8n-workflow).

Note: Pick an organization/ location if prompted.

4. Select the “Create” button.

Once the project is created, you’ll be automatically switched into it. This project will be the foundation for enabling the Sheets API and generating credentials in the next steps.

Step 3: Enable the Google Sheets API

Now that your project is ready, you need to turn on the Google Sheets API so n8n can read from and write to your spreadsheets.

Here’s how to enable the Google Sheets API:

1. Make sure that the project we created in step 1 is selected at the top.

2. Use the search bar at the top to look for Google Sheets API.

3. Select the Google Sheets API option and click on “Enable”.

Once enabled, your project can now connect with Google Sheets.

Step 4: Create OAuth credentials

To let n8n access your Google Sheets, you need to create OAuth 2.0 credentials in your Google Cloud project. These credentials act like a secure pass. Here’s how you can create the credentials:

1. Once the Google Sheets API is enabled, you’ll be redirected to the API/Service details page.

2. Select the “OAuth consent screen” option from the left navigation bar.

3. Here, you can fill the required information like app name, your email id (user support email), etc.

4. For audience options, select external. Here, external makes your app accessible to any Google account user, not just users in your organization. This is required because n8n isn’t tied to your Google Workspace domain.

5. Add contact information as required and select “Finish” to complete the process.

Step 5: Create the client and get the keys

Once the OAuth setup is done, it’s time to create the client. A client is essentially the identity of your app in Google’s ecosystem. It tells Google who is making the request and ensures secure communication. To create a client:

1. Select the “Create OAuth client” option on the screen.

2. Select the application type as “Web application” and give it a name.

3. Now, if you are a paid user of the n8n workflows, you should have gotten a client ID right after the Google Sheets node was connected. Paste that client ID in the Authorised JavaScript origins sections here.

Note: In the free version of n8n, Google Sheets authentication works with the default built-in credentials, so you don’t need to add a client ID here.

4. Once done, select “Create” and a dialog box will appear which will highlight the client ID and the secret key. If you are a paid n8n user, copy and paste this secret key into the workflow you created.

Now that the integration is done, let us test our workflow!

Step 6: Testing the n8n workflow

Go back to the n8n workflow created in step 2. Change the operation to “create” and give a title. This will be the title (name) of the sheet that will get created. Once the details are added, select the “Execute this step” option.

Once this step is completed, open your Google Sheets and you will be able to see this sheet created there.

And there we go, we’ve created a blank Google Sheet using our n8n workflow!

Furthermore, let’s say we added some data to this sheet as follows:

This data can be read, manipulated, and deleted using the operations available in the workflow. Just ensure that you choose the correct sheet number and sheet name, and the operation to perform.

Here, we’ve tried to read the data from our sheet as follows:

Choose the operation you want to perform from the operations menu in this dialog box!

Your Google Sheets account is now fully integrated with n8n. From here on, you won’t need to repeat the setup, just drag in the Google Sheets node whenever a workflow calls for it.

So, what can we actually do with such n8n workflows? Let’s look at some of the most common Google Sheets workflows you can build in n8n.

Common workflows in n8n for Google Sheets

The magic of Google Sheets integration happens when you start automating everyday tasks. Instead of manually updating rows or copying data across tools, you can design workflows in n8n that do the heavy lifting for you. Let’s look at a few practical examples.

Automating data from forms into Google Sheets

This workflow ensures that every response submitted through a form is automatically recorded in Google Sheets. It saves teachers from manually entering student data, attendance, or quiz responses.

Here:

• Form Trigger Node: Captures real-time form submissions.

• Google Sheets Node: Inserts student data into specific columns of the s

It saves from manually entering student data, attendance, or quiz responses.

Schedule trigger → Fetch API data → Google Sheets

This workflow pulls in external data on a schedule, such as weather updates, exchange rates, or stock prices, and logs it in Google Sheets for tracking or reporting. It removes the need to manually check APIs every day.

The nodes here:

• Schedule Trigger Node: Defines when the workflow runs.

• HTTP Request Node: Calls the external API.

• Google Sheets Node: Logs the API response into a sheet.

It’s a perfect workflow for daily reports, dashboards, or tracking time-sensitive data like weather logs or financial data.

Data clean-up from Google Sheets

This workflow helps clean messy or raw spreadsheet data and organize it into a polished new sheet. For example, you could remove duplicates, split names, or calculate grades from raw scores.

The nodes present here are:

• Google Sheets Node (Read): Pulls raw data from the source sheet.

• Function/Set/IF Nodes: Clean and transform the data.

• Google Sheets Node (Write): Outputs cleaned results into a fresh sheet.

It’s helpful for preparing attendance records, cleaning survey data, or structuring grades before analysis.

Use cases for n8n and Google Sheets integration

Now that we’ve seen how workflows can be built step by step, let’s zoom out and look at the bigger picture about what kinds of problems n8n + Google Sheets can solve:

• Tracking and logging operational data: Keep a running log of activities such as form submissions, support tickets, or error reports directly in Google Sheets for easy review and sharing.

• Managing spreadsheet-based tasks from other tools: Automatically update task lists or project trackers in Sheets whenever something changes in connected tools like Trello, Slack, or Asana.

• Generating sheets dynamically from workflow inputs: Create new sheets automatically for new clients, projects, or campaigns, with data filled in as workflows run.

• Using Sheets as a lightweight data store or log: When a full database isn’t necessary, Google Sheets can act as a simple structured store for workflow outputs and records.

• Visualizing processed data in spreadsheet format: Use Sheets’ built-in charts, filters, and formulas to visualize results coming from your n8n workflows.

Conclusion

We explored how n8n and Google Sheets can work together to simplify repetitive tasks, manage data more effectively, and support classroom needs. Along the way, we looked at the steps to integrate Google Sheets with n8n, walked through practical workflows teachers can build, and highlighted broader use cases where this automation saves time and reduces manual work.

If you’d like to take the next step and build automation skills hands-on, check out Codecademy’s Learn Prompt Engineering course.

Frequently asked questions

1. How to connect Google Services to n8n?

You can connect Google services (like Google Sheets or Gmail) to n8n using OAuth2 credentials. Once you create and add your Google API credentials in n8n, you’ll be able to authenticate and use Google services as nodes in your workflows.

2. Can I use n8n for commercial use?

Yes, n8n offers a fair-code license. You can use it commercially, but if you plan to provide n8n as a service to third parties, you’ll need an enterprise license.

3. Is n8n totally free?

The core version of n8n is free and open source under the fair-code license. You can self-host without cost. However, additional services like n8n.cloud (the hosted version) come with pricing plans.

4. What is better than n8n?

That depends on your needs. Tools like Zapier, Make (formerly Integromat), or Apache Airflow may be “better” if you want specific features like a fully managed SaaS solution (Zapier), advanced data integrations (Make), or enterprise-grade pipelines (Airflow). n8n stands out for flexibility and open-source customization.

5. Is n8n an ETL?

Yes, n8n can function as a lightweight ETL (Extract, Transform, Load) tool. You can pull in data from multiple sources, process or transform it within workflows, and then push it into a target system like Google Sheets, databases, or APIs.