Who This Is For / When to Use
This article is for users who need to:
Find one specific row in Google Sheets based on a column value.
Reuse spreadsheet data in messages, conditions, or updates.
Control workflow behavior when a row is found or not found.
This is a Premium Action and incurs additional charges per execution.
What the Lookup Spreadsheet Row Action Does
This action searches a worksheet and returns one matching row based on your lookup criteria.
Key behaviors:
The first row is always treated as headers.
Matching data is stored as lookup variables.
Results can be reused in later workflow actions.
If no row is found, dependent Google Sheets actions are skipped.
Accessing the Workflow Builder
Go to Automations & Workflows > Workflows.
Open an existing workflow or create a new one.
Click Please select action under your trigger.
Adding the Google Sheets Action
In the action picker, search for Google Sheets.
Select Google Sheets from the list.
Selecting the Lookup Spreadsheet Row Action
Open the Action dropdown.
Select Lookup Spreadsheet Row.
Connecting Your Google Sheet
Complete the required connection fields:
Choose an account – Select the connected Google account.
Drive – Choose the Google Drive location.
Spreadsheet – Select the spreadsheet.
Worksheet – Select the worksheet to search.
Search – Choose whether to search from the top or bottom.
Use Refresh Headers if column names have changed.
Defining Lookup Criteria
Select a Column from the header list.
Enter the Value to match.
Use + Column to require multiple column matches.
Optional settings:
Case Sensitive Lookup – Enforces exact text matching.
Create new spreadsheet row if it doesn’t exist yet – Inserts a row when no match is found.
How Lookup Results Are Stored
Each Lookup Spreadsheet Row action automatically creates an index:
The index appears as
#1,#2, etc. in the workflow.The index cannot be edited or removed.
The index is used to reference lookup values later.
Example row number reference:
Using Lookup Values in Other Actions
All column values from the matched row are available as dynamic fields.
You can use lookup values in:
SMS or Email actions
Contact or account updates
Conditions (If/Else)
Additional Google Sheets actions
Access them via Google Sheets Lookup in the variable picker.
Using Lookup Results in Conditions
You can branch workflow logic based on lookup results.
Common use cases:
If a row exists → update it.
If no row exists → create a new row.
Route contacts differently based on spreadsheet data.
Common Issues and Fixes
No Row Found
Confirm the column header matches exactly.
Check Case Sensitive Lookup settings.
Verify there are no leading/trailing spaces in the sheet.
Headers Not Appearing
Click Refresh Headers after editing the sheet.
Ensure the first row contains headers only.
Downstream Actions Skipped
If no row is found, Google Sheets actions that depend on the lookup are skipped.
Use an If/Else condition to handle “row not found” scenarios.
FAQ
What happens if no matching row is found?
If no row is found, any Google Sheets actions that rely on this lookup result are skipped.
Is this different from Lookup Multiple Spreadsheet Row(s)?
Yes. This action returns one row only. Lookup Multiple Spreadsheet Row(s) returns multiple matches.
Can I search using more than one column?
Yes. Add additional columns and all conditions must match for the row to be returned.
Are lookup values available in messages and conditions?
Yes. Lookup values behave like standard workflow variables and can be used anywhere.
Why can’t I edit or remove the lookup index?
The index is required for internal variable mapping and cannot be modified.
Is the lookup case-sensitive?
No by default. Enable Case Sensitive Lookup if exact matching is required.