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

# Update Row

## Overview &#x20;

The Update Row action helps you:

* Update existing spreadsheet rows automatically
* Modify customer details dynamically
* Store lead information in Google Sheets
* Update mobile numbers, email IDs, and custom fields
* Sync bot responses with spreadsheet records

This feature is useful for:

* Lead management
* CRM updates
* Customer record maintenance
* Order tracking workflows
* Automated data synchronization

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

## Prerequisites &#x20;

Before starting, ensure:

* Google Sheets connection is already created
* Google account access is active
* Spreadsheet is available in Google Sheets
* Bot Builder access is enabled
* Required variables are already created in the bot flow

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

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

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

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

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

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

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

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

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

You can view the sheet Activated Status.<br>

{% embed url="<https://app.supademo.com/demo/cmpnuk63q01h14h0j0kzmnbm0?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/cmpnul5nc01mn2q0j4vu68usl?utm_source=link>" %}

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

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

After that, click the Add Node button to insert a new node into your workflow.

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

## 3. Configure Update Row Action &#x20;

After that, click the Connections tab to view and manage bot integrations.<br>

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

Following that, click on Google Sheet to expand the available row management options.

Now, click the Update Row option to configure the action for updating spreadsheet data.<br>

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

After that, enter a descriptive name for this action in the text field.<br>

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

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

Then, select a connection from the dropdown to configure the database integration.

Next up, select Sample GSheet Uploading from the connection dropdown list.[<br>](https://app.supademo.com/demo/cmpnvn6nc012e0v0jrrpcnknh?utm_source=link)<https://app.supademo.com/demo/cmpnvn6nc012e0v0jrrpcnknh?utm\\_source=link>

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

Next up, select Sample Data from the dropdown list to proceed.<br>

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

## 5. Select Spreadsheet and Sheet &#x20;

Select the required sheet from the dropdown menu to proceed.

Following this, select Sheet1 from the dropdown to specify the target sheet.<br>

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

After that, enter the cell range in the Range field to specify update location.

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

## 6. Configure First Column Update &#x20;

Afterwards, select the name column from the dropdown to specify the field to update.

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

Following that, enter the desired value in the Value field to update the row.

From here, click Add variable to include additional column-value pairs for the row update.

Then, search for and select the variable you need from the dropdown list.

Now, select name from the dropdown to set the column name for your update.

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

## 7. Configure Mobile Number Column &#x20;

Following that, click New value to add another column mapping to your spreadsheet update.

From here, select a column to update the second data field value.

Following this, select the mobile option to assign the mobile number column to the row update.<br>

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

Then, click Add variable to include additional fields for the row update.

Next, use the search field to find and select the variable you need.

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

## 8. Configure Email Column &#x20;

Now, click New value to add another row to your update form.

After that, select a column from the dropdown to specify which field to update.

Next up, select email from the dropdown to set it as the third column field.<br>

Afterwards, click Add variable to include another field in the row update.

Then, search for the variable you need in the dropdown menu.

Select the email variable for the email column.<br>

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

## 9. Save Update Row Configuration &#x20;

Afterwards, click the Create button to save your row updates to the spreadsheet.

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

The Update Row action lets you automatically modify existing data in a specific Google\
Sheets row, such as:

* Customer details
* Lead status
* Mobile numbers
* Email addresses
* Order updates<br>

## 10. Publish the Bot &#x20;

To conclude, click the Publish button to finalize and deploy your bot actions.

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

Once published, the bot will automatically update rows in Google Sheets whenever the configured workflow is triggered.

## Workflow Summary &#x20;

Apps\
&#x20;  ↓\
Google Sheet\
&#x20;  ↓\
Bot Builder\
&#x20;  ↓\
Add Node\
&#x20;  ↓\
Connections\
&#x20;  ↓\
Update Row\
&#x20;  ↓\
Select Spreadsheet\
&#x20;  ↓\
Map Variables\
&#x20;  ↓\
Create\
&#x20;  ↓\
Publish

## Expected Output  <br>

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

After successful configuration:

* Existing spreadsheet rows are updated automatically
* Customer details are synced dynamically
* Mobile and email values are updated correctly
* Bot variables are mapped into spreadsheet columns
* Data synchronization happens automatically through the workflow
