> 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-row-value.md).

# Fetch the Row Value

The Fetch The Row Value action allows you to retrieve data from a specific row in a Google Sheet and store the response dynamically inside bot variables for further workflow processing.

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

## Overview &#x20;

The Fetch The Row Value action helps you:

* Retrieve spreadsheet row data dynamically
* Fetch customer details from Google Sheets
* Store spreadsheet responses in variables
* Use fetched values throughout the workflow
* Automate customer data retrieval processes

This feature is useful for:

* Customer lookup workflows
* CRM data retrieval
* Lead verification
* Dynamic response handling
* Spreadsheet-based automation

## Prerequisites &#x20;

Before starting, ensure:

* Google Sheets connection is already created
* Spreadsheet access permissions are enabled
* Bot Builder access is available
* Target spreadsheet contains the required data
* Variables are configured properly

## 1. Open Google Sheets Integration &#x20;

Firstly, click the Apps icon in the left sidebar to access all available applications.<br>

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

Following that, click the CRM filter to view customer relationship management applications.<br>

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

From here, click the Google Sheets card to view connection options and manage spreadsheet integrations.<br>

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

Next, open 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/cmpnzste201zp220jicsa0lyy?utm_source=link>" %}

## 2. Open Bot Builder &#x20;

After that, click the Bot menu item in the left sidebar to access bot management features.<br>

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

Next up, use the search field to find and filter specific bots from your list.<br>

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

After that, click the Plus (+) icon to add a new node to your bot flow.

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

## 3. Configure Fetch The Row Value Action &#x20;

Next, click the Connections tab to view and manage available integrations.<br>

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

Next, click Google Sheet to configure the spreadsheet connection for data operations.<br>

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

Then, click the Fetch The Row Value action to configure retrieving data from spreadsheets.<br>

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

Next, enter a descriptive name for this action in the Action Name field.

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

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

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

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

Following that, select the Spread Sheet field to choose your target spreadsheet.

Now, select Sample Data from the dropdown to choose your spreadsheet source.

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

## 5. Select Spreadsheet Sheet &#x20;

Next, select Sheet1 from the dropdown to specify which sheet contains your data.<br>

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

Then, enter the range for your data to fetch the specific row values.

Example:

A1:D10

This range determines which spreadsheet rows and columns are included in the fetch operation.

## 6. Configure Response Variable &#x20;

Following this, enter a variable to store the fetched row response data.<br>

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

Following this, select:

Create new variable: customerdata

This variable stores the fetched spreadsheet response dynamically for later workflow usage.

## 7. Complete Action Setup &#x20;

Next up, click the Create button to complete the fetch row action setup.<br>

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

The Fetch The Row Value action is used to retrieve data from a specific row in your Google Sheet and store it in a variable for further workflow actions.

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

## 8. Publish the Bot &#x20;

Finally, click the Publish button to save and deploy your bot changes.

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

Once published, the bot can dynamically retrieve row data from Google Sheets during workflow execution.

## Using Fetched Row Data &#x20;

You can see the fetched row data in the Sample Output section and use the response values dynamically anywhere in your workflow.

Example usage:

{{customerdata.name}}\
{{customerdata.mobile}}\
{{customerdata.email}}

These variables can be used in:

* Messages
* Conditions
* API requests
* CRM workflows
* Customer response flows

## Workflow Summary &#x20;

Apps\
&#x20;  ↓\
Google Sheets\
&#x20;  ↓\
Bot Builder\
&#x20;  ↓\
Add Node\
&#x20;  ↓\
Connections\
&#x20;  ↓\
Fetch The Row Value\
&#x20;  ↓\
Select Spreadsheet\
&#x20;  ↓\
Set Range\
&#x20;  ↓\
Store Response Variable\
&#x20;  ↓\
Create\
&#x20;  ↓\
Publish

## Expected Output &#x20;

After successful configuration:<br>

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

* Spreadsheet row data is fetched dynamically
* Response values are stored in variables
* Customer details can be accessed anywhere in the workflow
* Spreadsheet responses can be reused dynamically

Workflow automation becomes data-driven
