Lookup Spreadsheet Rows

This guide explains how to search specific rows in a Google Sheet based on conditions using the Lookup Spreadsheet Rows block.

Step 1: Add Lookup Rows Block #

1. Go to Automation → Add App
2. Search for Google Sheets
3. Select Lookup Spreadsheet Rows

Step 2: Configure Settings #

1. Select authentication
2. Choose the spreadsheet
3. Select the sub-sheet
4. Enter the column to search (e.g., B)
5. Select condition (e.g., Equals)
6. Enter the search value (e.g., phone number)

Step 3: Advanced Settings (Optional) #

• Select operator (for multi-column conditions)
• Set number of rows to search
• Choose sorting order (Top/Bottom)

Step 4: Run & Save #

• Click Run & Save to fetch matching data

Step 5: View Output #

• Go to Run History → Output → Response
• Check retrieved data (e.g., complaint number, status)
• Use the fetched data in your flow (e.g., send status message)
• Save the workflow