Saltar al contenido principal

The Google Sheets Node allows your assistant to save customer information, search inventory or order statuses, and update spreadsheet rows in real time.

Google Sheets Automation

What You Can Do with This Node​

  1. Find rows (findRows): Look up rows matching a specific phone number, email, or order ID.
  2. Insert rows (insertRows): Append new customer entries to your sheet.
  3. Update rows (updateRows): Modify existing columns (e.g. changing status to "Completed").
  4. Delete rows (deleteRows): Remove rows matching specific criteria.

Configuration Fields​

connectionIdstringrequired

Your configured Google Service Account connection.

spreadsheetIdstringrequired

Unique spreadsheet ID found in your browser URL: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit

worksheetNamestringoptional

Name of the tab inside the sheet (e.g. Leads, Sales, Sheet1).

operationenumdefault: insertRows

Action to perform: findRows (Find), insertRows (Insert), updateRows (Update), or deleteRows (Delete).

rowsJsonarrayoptional

Data to append to the spreadsheet. Keys must match your column names:

[
  {
    "Date": "{current_date}",
    "Name": "{user_name}",
    "Phone": "{user_phone}",
    "Service": "{service_interest}"
  }
]
filtersJsonobjectoptional

Search criteria used to find a specific row:

{
  "Phone": "{user_phone}"
}
outputVariablestringdefault: sheets_result

Name of the variable to store the result for subsequent blocks.

Practical Examples​

Example 1: Save a new contact from WhatsApp​

When a user finishes submitting their details in the chat, the node appends a new row to your sheet:

  • Operation: insertRows
  • Spreadsheet ID: Your Google Sheets ID
  • Tab: Leads
  • Data to insert: 
    [
      {
        "Date": "{current_date}",
        "Name": "{user_name}",
        "Phone": "{user_phone}",
        "Status": "New"
      }
    ]

Example 2: Look up an order status​

To answer a customer about their delivery status:

  1. Find the row by tracking number: 
    {
      "TrackingNumber": "{tracking_number}"
    }
  2. In the next message, reply: 
    Hi {sheets_result.rows.0.values.Name}, your order status is: {sheets_result.rows.0.values.Status}.

Important Permission in Google Drive​

Share the sheet with your service account

Open your Google Sheet, click Share, and add your service account email (ending in @...gserviceaccount.com) with the Editor role.