"Add Google Sheet row" action node

Learn how to configure "Add Google Sheet row"

Written By Ray Tang (Administrator)

Updated at June 5th, 2026

Table of Contents

Before configuring “Google Sheets” action nodes, you will need to have at least one Google Sheets integrations connected in your company. You can refer to this Help Center article to learn more about Google Sheets integrations.

 

 

Add Google Sheet row

The “Add Google Sheet row” action node allows you to insert a new row into the selected Google Sheet with predefined values. You can use this to log customer details, transaction records, or any relevant data automatically.

To set up the node, follow these steps:

  1. Click on the “Search Google Sheet rows” action node to open up its form, which will appear on the right side of the screen
  2. The node form contains the following fields for you to configure your action:
    1. Select a Google account and sheet
      1. Google account: Choose the connected Google account. If no Google account is connected, you can refer to the Help Center article here to set up your Google Sheets integration. 
      2. Google Sheet: Select the spreadsheet you want to search in.
      3. Sheet: Pick the specific tab (worksheet) inside the spreadsheet.
      4. Header row: Enter the row number that contains the column headers (usually 1).
    2. Map column values
      1. Under Map column values, add one mapping per column you want to fill:
        1. Google Sheet column: Select the target column (e.g., Order ID, Email, Tier,
        2. Value: Type a static value or insert a variable (trigger, contact, or mid‑flow) using the {x} variable picker.
        3. Click “Add”  to include more column

Notes and tips

  • Headers must exist in the specified header row; only those columns can be mapped.
  • Map only the columns you need—unmapped columns remain blank or keep default sheet formulas.
  • If your sheet uses formulas (e.g., totals), keep formula columns unmapped so Google Sheets calculates them automatically.
  • Ensure values match the expected format (e.g., dates, numbers) to avoid sheet errors.