Google Sheets Node

Read, write, and manage data inside Google Sheets directly from your workflows.

This node allows you to automate spreadsheets for use cases like:

• Logging form submissions

• Storing orders or transactions

• Updating dashboards

• Syncing external data

What This Node Does

With the Google Sheets node, you can:

• Fetch data from a spreadsheet

• Append new rows

• Update existing rows

• Clear ranges

• Create new sheets

• Perform batch updates

⚠️ Before You Start (Important)

This integration uses a Google Service Account, not OAuth.

That means:

• You must create credentials in Google Cloud

• You must share your spreadsheet with that account

Step 1: Create Google Sheets Credentials (Service Account)

Follow this carefully 👇

1. Go to Google Cloud Console

Open:
👉 https://console.cloud.google.com/

2. Create a Project

• Click Select Project

• Click New Project

• Give it a name (e.g. syncaut-sheets)

• Click Create

3. Enable Google Sheets API

• Go to APIs & Services → Library

• Search: Google Sheets API

• Click it

• Click Enable

4. Create Service Account

• Go to APIs & Services → Credentials

• Click Create Credentials

• Select Service Account

Fill:

• Name: syncaut-bot

• Click Create

Skip roles → Click Done

5. Generate JSON Key

• Click your service account

• Go to Keys

• Click Add Key → Create New Key

• Choose JSON

• Download the file

⚠️ This JSON file is your credential

6. Share Your Spreadsheet

Open your Google Sheet and:

• Click Share

• Add the service account email (from JSON)

• Give Editor access

Example email:

[email protected]

Step 2: Add Credential in Your App

Inside your app:

1. 
   Go to Credentials
   

2. 
   Create new → Google Sheets
   

3. 
   Paste the entire JSON file
   

4. 
   Save
   

Now it will appear in the dropdown.

Step 3: Get Spreadsheet ID

From your sheet URL:

https://docs.google.com/spreadsheets/d/SPREADSHEET_ID/edit

Copy the SPREADSHEET_ID

Step 4: Configure the Node

Variable Name

Used to reference output later.

Example:

mySheet

Usage:

{{mySheet.values}}

Credentials

Select your saved Google Sheets credential.

Spreadsheet ID

Paste your spreadsheet ID.

Sheet Name (Optional)

Default sheet for operations.

Example:

Sheet1

Action

Choose what you want to do:

ActionDescriptionget_valuesRead dataappend_rowAdd new rowupdate_rowUpdate existing rowclear_rangeDelete datacreate_sheetAdd new sheetbatch_updateMultiple updates

Payload (JSON)

This defines the operation.

You can use variables like:

{{orderId}}
{{customerName}}

Actions Explained (With Examples)

1. Get Values

Fetch data from a range.

{
  "range": "Sheet1!A1:D10"
}

2. Append Row

Add new row to sheet.

{
  "range": "Sheet1!A:D",
  "values": [
    ["{{orderId}}", "{{customerName}}", "{{total}}", "{{date}}"]
  ]
}

3. Update Row

Overwrite a specific row.

{
  "range": "Sheet1!A2:D2",
  "values": [
    ["{{orderId}}", "{{customerName}}", "{{total}}", "{{date}}"]
  ]
}

4. Clear Range

Delete values in a range.

{
  "range": "Sheet1!A2:D100"
}

5. Create Sheet

Create a new tab.

{
  "title": "New Sheet {{timestamp}}"
}

6. Batch Update

Perform multiple updates at once.

{
  "data": [
    {
      "range": "Sheet1!A2:A2",
      "values": [["Updated Value"]]
    },
    {
      "range": "Sheet1!B2:B2",
      "values": [["Another Value"]]
    }
  ]
}

Using Variables

You can inject data from previous nodes:

SyntaxMeaning{{variable}}Simple value{{variable.field}}Nested value{{json.variable}}Full object

Example Workflow

Flow:

1. 
   Form Submission
   

2. 
   AI Node → Generate summary
   

3. 
   Google Sheets → Store data
   

Payload:

{
  "range": "Sheet1!A:D",
  "values": [
    ["{{form.name}}", "{{form.email}}", "{{myAI.text}}", "{{timestamp}}"]
  ]
}

Output

The node returns:

{
  "values": [...],
  "updatedRows": 1,
  "updatedCells": 4,
  "action": "append_row"
}

Usage:

{{mySheet.values}}
{{mySheet.updatedRows}}

Execution Status

• Running → Processing request
  

• Success → Operation completed
  

• Error → Something failed
  

Common Errors & Fixes

Missing Credentials

Fix:

• 
  Ensure you selected a credential
  

Spreadsheet Not Accessible

Error:

Google Sheets API Error: The caller does not have permission

Fix:

• 
  Share the sheet with your service account email
  

Invalid JSON Payload

Fix:

• 
  Ensure valid JSON format
  

• 
  Check for missing commas or quotes
  

Missing Required Fields

Examples:

• range is required
  

• values are required
  

Fix:

• 
  Follow payload examples exactly
  

Best Practices

• 
  Always test with small ranges first
  

• 
  Use variables for dynamic workflows
  

• 
  Keep payloads clean and valid JSON
  

• 
  Share sheets properly with service account
  

When to Use This Node

Use Google Sheets when you want to:

• 
  Store structured workflow data
  

• 
  Build internal dashboards
  

• 
  Track users, orders, or logs
  

• 
  Replace simple databases
  

Pro Tip (Very Important)

If your node runs but returns empty data, 90% of the time:

👉 Your sheet is not shared with the service account