Google Sheets Step

The Google Sheets step appends a row to a worksheet in an existing spreadsheet using a named connection. Each time a session runs and reaches this step, one row is added to the sheet with the values you configure.

Configuration

name	type	required	description
`connection`	string	yes	The name of the Google Sheets connection to use, as configured in Integrations.
`action`	string	yes	The operation to perform. Must be `APPEND_ROW`.
`spreadsheet`	string	yes	The ID of the target spreadsheet.
`spreadsheetName`	string	yes	The human-readable name of the spreadsheet. Used for display purposes.
`worksheet`	string	yes	The name of the target worksheet or tab.
`hasHeaderRow`	boolean	yes	Whether the first row of the sheet contains column headers.
`values`	array	yes	An ordered list of cell values to append. Each string corresponds to a column, left to right. Supports mapping placeholders.

Example

The example below appends a row to a "Submissions" worksheet, recording a timestamp, name, email, and plan tier for a new session.

{
  "connection": "gsheets-prod",
  "action": "APPEND_ROW",
  "spreadsheet": "1x2y3z",
  "spreadsheetName": "Customer Intake",
  "worksheet": "Submissions",
  "hasHeaderRow": true,
  "values": [
    "2025-09-16T10:30:00Z",
    "Marc-Andre",
    "[email protected]",
    "Pro"
  ]
}