All action nodes require setting up in a node form, where you specify the parameters for the selected action.

In this article, we will guide you on how to set up every “Google Sheet” action nodes so your flow can execute the appropriate tasks to achieve your desired outcome.
 

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. Select a Google account. If no Google account is connected, you can refer to the Help Center article here to set up your Google Sheets integration. 
3. Select a Google Sheet and a Sheet within
4. The node form contains the following fields for you to configure your action:
   
   1. Search conditions: This is an optional step for you to define the search condition
   2. Add condition: You can click “Add condition” to add more search conditions

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. Select a Google account. If no Google account is connected, you can refer to the Help Center article here to set up your Google Sheets integration 
3. Select a Google Sheet and a Sheet within
4. The node form contains the following fields for you to configure your action:
   
   1. Map column values: Select the Google Sheet columns where data should be added. You will need to map each column to a corresponding variable or static value.
   2. Add condition: You can click “Add Condition” to include more columns as needed

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
   
2. Select a Google account. If no Google account is connected, you can refer to the Help Center article here to set up your Google Sheets integration
3. Choose a Google Sheet and specify the Sheet where the row should be updated
4. Configure the following fields in the node settings:
   
   1. Select row
      1. Select the row that needs to be updated
      2. You can choose to update a static row by selecting a specific row, or select flow variables
   2. Map column values
      1. Specify the column headers to update in the selected row
      2. Assign new values to these columns, either as static values or dynamic variables from the flow.
   3. Add condition (optional)
      1. Click “Add Condition” to include additional columns for updates.