> For the complete documentation index, see [llms.txt](https://docs.ownchat.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ownchat.app/bot/connections/google-sheet/fetch-the-first-10-matched-row-values.md).

# 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.

{% embed url="<https://app.supademo.com/demo/cmpi66m260vebqms9tbr2ltgl?utm_source=link>" %}

## Overview &#x20;

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 &#x20;

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 &#x20;

To get started, click the Apps icon in the left sidebar to access available integrations.<br>

{% embed url="<https://app.supademo.com/demo/cmpo0gy4202274h0je5ajp0o7?utm_source=link>" %}

Next, click on the CRM filter to view all available CRM applications.<br>

{% embed url="<https://app.supademo.com/demo/cmpo0i8em020f220j71ms5511?utm_source=link>" %}

Next up, click the Google Sheet app card to view integration details and options.

{% embed url="<https://app.supademo.com/demo/cmpo0jpej000z2u0jcgczfvow?utm_source=link>" %}

Following this, click the Sample GSheet Uploading connection to view and manage its details.

You can view the sheet Activated Status.

{% embed url="<https://app.supademo.com/demo/cmpo0ma6a02i62q0jtk6h8uvs?utm_source=link>" %}

## 2. Open Bot Builder &#x20;

So, now click the Bot menu option in the sidebar to access bot configuration settings.<br>

{% embed url="<https://app.supademo.com/demo/cmpo0nya7002o2j0jl6485gn0?utm_source=link>" %}

Next up, click the Open Builder button to configure the Bot actions workflow.

{% embed url="<https://app.supademo.com/demo/cmpo0oy8a007l2a0jur14ycj3?utm_source=link>" %}

Start by clicking the Add Node button to create a new bot action node.

{% embed url="<https://app.supademo.com/demo/cmpo0q6g90216220jwp1dyfcb?utm_source=link>" %}

## 3. Configure Fetch The First 10 Matched Row Values Action &#x20;

Following this, click the Connections tab to view available integrations for your bot.

{% embed url="<https://app.supademo.com/demo/cmpo0uhu1022s4h0juku35b3s?utm_source=link>" %}

Now, click Google Sheet to configure the data integration for your bot.

{% embed url="<https://app.supademo.com/demo/cmpo0x0ek022w4h0jybwrkizi?utm_source=link>" %}

Now, click Fetch The First 10 Matched Row Values to retrieve database records.

{% embed url="<https://app.supademo.com/demo/cmpo0yyve02ih2q0j860ykgkl?utm_source=link>" %}

Next up, enter a descriptive action name for your matched row values fetch.

{% embed url="<https://app.supademo.com/demo/cmpo10sws01m10v0j7j60rsot?utm_source=link>" %}

## 4. Select Google Sheets Connection &#x20;

Following that, select Sample GSheet Uploading from the connection dropdown list.<br>

{% embed url="<https://app.supademo.com/demo/cmpo12efl006a2u0j39rqq1bs?utm_source=link>" %}

After that, select the desired spreadsheet from the dropdown menu list.\
Next up, select Sample upload from the dropdown list to proceed.<br>

{% embed url="<https://app.supademo.com/demo/cmpo14ahp0291220jmyh9am14?utm_source=link>" %}

## 5. Select Spreadsheet Sheet &#x20;

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.<br>

{% embed url="<https://app.supademo.com/demo/cmpo1588j007s2a0jskkzyxx3?utm_source=link>" %}

## 6. Configure Search Range &#x20;

Next, enter the range of cells to fetch data from the spreadsheet.<br>

{% embed url="<https://app.supademo.com/demo/cmpo16lhc000q1k0jiuxpswlh?utm_source=link>" %}

Example:

A1:D100

This range determines where the system searches for matching records.

## 7. Configure Match Conditions &#x20;

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.<br>

{% embed url="<https://app.supademo.com/demo/cmpo264an02a1220ju72mfvyj?utm_source=link>" %}

Example:

| Column Name | Value      |
| ----------- | ---------- |
| mobile      | 9876543210 |

The system searches the selected column and retrieves up to 10 matching records.

## 8. Complete Action Setup &#x20;

Then, click the Create button to finalize and execute your configured action.<br>

{% embed url="<https://app.supademo.com/demo/cmpo29y8e02a9220jlzuemhxl?utm_source=link>" %}

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.<br>

{% embed url="<https://app.supademo.com/demo/cmpo29y8e02a9220jlzuemhxl?utm_source=link>" %}

## 9. Publish the Bot &#x20;

To conclude, click the Publish button to save and deploy your bot configuration.<br>

{% embed url="<https://app.supademo.com/demo/cmpo2ef1o02ah220j2i8rxlfg?utm_source=link>" %}

Once published, the bot automatically retrieves matching spreadsheet records whenever the workflow is triggered.

## Using Matched Row Values &#x20;

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 &#x20;

Apps\
&#x20;  ↓\
Google Sheet\
&#x20;  ↓\
Bot Builder\
&#x20;  ↓\
Add Node\
&#x20;  ↓\
Connections\
&#x20;  ↓\
Fetch The First 10 Matched Row Values\
&#x20;  ↓\
Select Spreadsheet\
&#x20;  ↓\
Set Search Range\
&#x20;  ↓\
Configure Match Conditions\
&#x20;  ↓\
Create\
&#x20;  ↓\
Publish

## Expected Output &#x20;

After successful configuration:

{% embed url="<https://app.supademo.com/demo/cmpo2ef1o02ah220j2i8rxlfg?utm_source=link>" %}

* 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
