How to conntect n8n to google seet

Written by

Thong Dang

in

Automating your workflows can save hours of manual effort, and one of the most popular ways to do this is by connecting tools like n8n with Google Sheets. Whether you want to move data, generate reports, or trigger notifications, integrating these platforms opens up a world of possibilities. This guide walks you through the process in simple steps, making it friendly for beginners.

Prerequisites

  • An active n8n instance (cloud or self-hosted)
  • Access to a Google account with Google Sheets
  • Familiarity with basic n8n concepts (nodes, workflows)

Step 1: Prepare Your Google Sheet

Before connecting n8n, you’ll need the Google Sheet ready that you want to interact with.

  1. Create a new sheet or open an existing one in Google Sheets.
  2. Take note of the sheet name and column headers, as you’ll need these later.

Step 2: Set Up Google Sheets Credentials in n8n

To allow n8n to interact with Google Sheets, you’ll need to add your Google account credentials in n8n.

2.1: Obtain Google API Credentials

  1. Go to the Google Cloud Console and log in with your Google account.
  2. Create a new project or select an existing one.
  3. Navigate to APIs & Services > Credentials.
  4. Click Create Credentials and choose OAuth client ID.
  5. Set the application type to Web application.
  6. Add https://YOUR_N8N_INSTANCE_URL/rest/oauth2-credential/callback as an Authorized redirect URI. Replace YOUR_N8N_INSTANCE_URL with your actual n8n URL.
  7. Save and copy the Client ID and Client Secret.

2.2: Add Google Sheets Credentials in n8n

  1. In your n8n dashboard, go to Credentials.
  2. Click + New Credential and select Google Sheets OAuth2 API.
  3. Paste the Client ID and Client Secret from the previous step.
  4. Click Connect and follow the prompts to log in and authorize access to your Google account.

Step 3: Create Your n8n Workflow

Once credentials are set, you’re ready to build a basic workflow to connect to Google Sheets.

3.1: Add the Google Sheets Node

  1. Click + Add Node in your workflow editor.
  2. Search for and select the Google Sheets node.
  3. Select the credentials you just created from the dropdown.

3.2: Configure the Node

  1. Choose the Operation you wish to perform (e.g., Read Rows, Append Row).
  2. Specify the Spreadsheet ID (found in your Google Sheets URL).
  3. Enter the Sheet name and other required fields.

3.3: Test Your Workflow

  1. Click Execute Node to test the connection and action.
  2. Verify the result in your Google Sheet to confirm that the integration works.

Troubleshooting Common Issues

  • Authentication errors: Double-check your OAuth credentials and redirect URIs.
  • Permission errors: Ensure your Google account has access to the specific Sheet.
  • Invalid Spreadsheet ID: Copy the correct ID from your Google Sheets URL.

Conclusion

Connecting n8n to Google Sheets can streamline your workflows and automate repetitive tasks with ease. By following the steps above, even beginners can set up a seamless integration and start benefiting from dynamic data automation. Explore further by combining Google Sheets actions with other services in n8n to truly unlock its potential.

More posts