Fetch The First 10 Matched Row Values
The Fetch The First 10 Matched Row Values action allows you to retrieve up to 10 matching rows from a Google Sheet based on a specified condition and use the response dynamically within your workflow.
Overview
The Fetch The First 10 Matched Row Values action helps you:
Search spreadsheet records dynamically
Retrieve matching customer or lead data
Fetch up to 10 matching rows automatically
Use spreadsheet data in workflows
Build data-driven bot automations
This feature is useful for:
Customer record searches
Lead lookup automation
CRM workflows
Dynamic data retrieval
Spreadsheet-based filtering
Prerequisites
Before starting, ensure:
Google Sheets connection is already created
Spreadsheet contains searchable data
Bot Builder access is enabled
Required columns are properly configured
Variables are available if needed
1. Open Google Sheets Integration
To get started, click the Apps icon in the left sidebar to access available integrations.
Next, click on the CRM filter to view all available CRM applications.
Next up, click the Google Sheet app card to view integration details and options.
Following this, click the Sample GSheet Uploading connection to view and manage its details.
You can view the sheet Activated Status.
2. Open Bot Builder
So, now click the Bot menu option in the sidebar to access bot configuration settings.
Next up, click the Open Builder button to configure the Bot actions workflow.
Start by clicking the Add Node button to create a new bot action node.
3. Configure Fetch The First 10 Matched Row Values Action
Following this, click the Connections tab to view available integrations for your bot.
Now, click Google Sheet to configure the data integration for your bot.
Now, click Fetch The First 10 Matched Row Values to retrieve database records.
Next up, enter a descriptive action name for your matched row values fetch.
4. Select Google Sheets Connection
Following that, select Sample GSheet Uploading from the connection dropdown list.
After that, select the desired spreadsheet from the dropdown menu list. Next up, select Sample upload from the dropdown list to proceed.
5. Select Spreadsheet Sheet
From here, select a sheet from the dropdown menu to choose your data source.
After that, select Sheet1 from the dropdown to specify your data source sheet.
6. Configure Search Range
Next, enter the range of cells to fetch data from the spreadsheet.
Example:
A1:D100
This range determines where the system searches for matching records.
7. Configure Match Conditions
Next, click the Column Name field to select which column to fetch matched row values from.
Then, enter the value in the Value field to complete the search criteria.
Example:
Column Name
Value
mobile
9876543210
The system searches the selected column and retrieves up to 10 matching records.
8. Complete Action Setup
Then, click the Create button to finalize and execute your configured action.
The Fetch The First 10 Matched Row Values action returns up to 10 matching rows from your Google Sheet based on the condition you provide.
9. Publish the Bot
To conclude, click the Publish button to save and deploy your bot configuration.
Once published, the bot automatically retrieves matching spreadsheet records whenever the workflow is triggered.
Using Matched Row Values
You can view the fetched records in the Sample Output section and use the values dynamically anywhere in your workflow.
Example:
{{matchedrows.name}} {{matchedrows.mobile}} {{matchedrows.email}}
These response values can be used in:
Bot messages
Conditions
CRM actions
API requests
Customer workflows
Workflow Summary
Apps ↓ Google Sheet ↓ Bot Builder ↓ Add Node ↓ Connections ↓ Fetch The First 10 Matched Row Values ↓ Select Spreadsheet ↓ Set Search Range ↓ Configure Match Conditions ↓ Create ↓ Publish
Expected Output
After successful configuration:
Spreadsheet records are searched dynamically
Up to 10 matching rows are retrieved
Matching values are available in workflow variables
Customer data can be reused dynamically
Spreadsheet filtering becomes fully automated
Last updated