Skip to main content
The Google Sheets action allows you to update data to Google Sheets directly from your journey. You can use it to automatically store leads, update existing records. Before using this action, you must connect your Google account.
Once connected, choose the desired Action Type.
Currently, the following operations are supported:
  • Append Rows - Add one or more new rows to a Google Sheet.
  • Update Row – Update specific columns in an existing row.

​
Append Rows

Use Append Rows to insert new data into the selected spreadsheet.

​
Configuration Fields

  • Spreadsheet
    Select the Google Spreadsheet where data should be added.
  • Sheet
    Choose the worksheet within the selected spreadsheet.
  • Values
    Define the data to be appended.
    • Add Row – Insert multiple rows in a single operation.
    • Add Column – Add additional columns for each row.
    • Each cell supports dynamic variables, allowing you to populate values from your workflow.
    Example:

​
Update Row

Use Update Row to modify an existing row in your spreadsheet.

​
Configuration Fields

  • Spreadsheet
    Select the Google Spreadsheet.
  • Sheet
    Choose the worksheet containing the row to update.
  • Search Column Index
    Enter the column number used to locate the row.     Examples:
    • Column A → 1
    • Column B → 2
    • Column C → 3
  • Search Value
    Specify the value to search for within the selected column. Dynamic variables are supported.     Example: {{contact.phone_number}}
  • Columns to Update
    Specify which columns should be updated and provide the corresponding values.     Example:
    • Column 2 → {{contact.first_name}}
    • Column 5 → Interested

​
Example Use Case

Suppose you’re building a lead qualification journey.
  1. A user provides their name, phone number, and budget.
  2. Use Append Rows to store the lead in a Google Sheet.
  3. Later, after a sales representative updates the lead status, use Update Row to modify the corresponding row by searching with the user’s phone number.
This allows Google Sheets to act as a lightweight CRM while keeping your journey fully automated.