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.