Who This Is For / When to Use
This article is for users building advanced workflows that need to:
Retrieve more than one matching row from a Google Sheet.
Perform bulk lookups based on column values.
Use Google Sheets data inside Kyrios workflows.
This is a Premium Action and requires premium workflow access.
What the Lookup Multiple Spreadsheet Row(s) Action Does
This action searches a selected Google Sheet and returns multiple rows that match your specified column criteria.
Key behaviors:
Searches from a defined point in the worksheet.
Supports multiple column conditions.
Allows a maximum number of rows to be returned.
Can optionally create a new row if no match is found.
Accessing the Workflow Builder
Navigate to Automations > Workflows.
Open an existing workflow or create a new one.
Adding the Google Sheets Action
In the workflow builder, click the plus (+) icon below your trigger.
Select Add Action.
Search for Google Sheets.
Selecting the Premium Google Sheets Action
From the action list, select Lookup Multiple Spreadsheet Row(s).
Note the premium action indicator in the action panel.
Configuring Google Sheets Connection Settings
Complete the following required fields:
Choose an Account – Select the connected Google account.
Drive – Choose the Google Drive where the file exists.
Spreadsheet – Select the spreadsheet.
Worksheet – Select the worksheet to search.
Defining Search Criteria
Use these fields to control how rows are matched:
Search – Choose where the search begins (for example, from the top of the sheet).
Column – Select the column to evaluate.
Value – Enter the value to match.
+ Column – Add additional column conditions if needed.
Optional settings:
Row Count – Maximum number of rows to return.
Case Sensitive Lookup – Match exact letter casing.
Create new spreadsheet row if it doesn’t exist yet – Inserts a new row when no match is found.
Saving the Action
Review all configuration fields.
Click Save Action.
Testing and Publishing the Workflow
Click Test Workflow to validate results.
Confirm returned row data is correct.
Toggle Publish to activate the workflow.
Common Issues and Fixes
No Rows Returned
Verify column names match the worksheet headers.
Confirm Case Sensitive Lookup is correctly set.
Ensure the Row Count is greater than zero.
Incorrect Data Returned
Confirm the correct worksheet is selected.
Refresh headers if the sheet structure changed.
Check for extra spaces or formatting differences in values.
Action Not Available
This is a Premium Action. Confirm premium workflow access is enabled.
FAQ
What does the Lookup Multiple Spreadsheet Row(s) action do?
It retrieves multiple rows from a Google Sheet that match defined column criteria within a workflow.
Is this a premium workflow action?
Yes. Google Sheets lookup actions that retrieve multiple rows are premium actions.
Can I search using more than one column?
Yes. You can add multiple column conditions to narrow results.
How many rows can be returned?
You control this using the Row Count field. For performance, keep results within a reasonable range.
What happens if no matching row exists?
If enabled, the action can create a new spreadsheet row automatically.
Does the worksheet header row matter?
Yes. Kyrios treats the first row as headers and uses them for column mapping.
Can I use the returned rows in later workflow steps?
Yes. Returned row data can be referenced in subsequent workflow actions.
Should I test before publishing?
Yes. Always use Test Workflow to confirm the correct rows are returned before publishing.