The Google Sheets action nodes in Advanced Flow Builder let you automatically create, update, and manage rows in your connected spreadsheets. This makes it easier to sync customer data, order records, or subscription details between SleekFlow and your Google Sheets without manual entry.

In this article, we will guide you through the available Google Sheets action nodes and how to configure them step by step.
 

Search Google Sheet rows

The “Search Google Sheet row” action node searches for and retrieves the matching rows in the selected Google Sheet based on the specified search conditions. This action is often used together with the “Update Google Sheet row” action node, allowing you to dynamically locate a specific row and update its details seamlessly within your workflow.

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. Set search conditions
      1. Google Sheet column: Select the column you want to search in (e.g. Email, Order ID, Member ID).
      2. Operator: Choose the condition to apply (e.g. equals, contains, starts with).
      3. Value: Enter the value you want to match, or insert a variable (e.g. Contact email, Subscription ID).

Example:

• Search by Order ID column with the value from a trigger variable to find the correct order row.
• Retrieve the subscription status column from the row and use it to decide whether to send a renewal reminder.
   

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

Update Google Sheet row

The “Update Google Sheet row” action node modifies an existing row in the selected Google Sheet based on specified conditions. It ensures that records remain accurate and up to date without manual edits.

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
   [image]
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. Choose which row to update (Row)
      1. Pick how the row is identified:
         1. Static row: Manually select a specific row number (e.g., 2).
         2. Flow variables: Provide the row index/ID via a variable (e.g., from a prior Search Google Sheet rows step).
   3. Map column values
      1. For each field you want to change:
         1. Google Sheet column: Select the target column (e.g., Status, Tracking URL, Tier).
         2. Value: Enter a static value or insert a variable using the picker.
         3. Click Add to update multiple columns in the same row.