Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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