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