Skip to main content

ChatRex and Google Sheets: data immediately in the table

The AI bot adds requests to the selected sheet, updates existing rows by key, and receives data to respond to the client. Fields and types are preset

  • Responds using your scenario
  • Stores customer data
  • Transfers the context

How ChatRex works with Google Sheets

ChatRexonline · new line
Today
Need advice on tariffs. My name is Irina10:24
Give me your phone number and confirm your application10:24✓✓
+7 999 123-45-67, yes, you can make an appointment10:25
Thank you. I pass the name, phone and subject to the selected table10:25✓✓
Action completed in Google SheetsA line with application data has been added to Google Sheets
Scenario 01

Writes the request to the table

After confirmation, ChatRex transfers the name, phone number, service and conversation summary to the corresponding columns of the selected sheet

Four confirmed actions

Adding, updating, searching for rows and getting a row by key

Custom Columns

Before starting, the sheet, fields, data types and a single key are selected

Update without duplicates

The string is searched by key, and the behavior in the absence of a result is set separately

How ChatRex integrates with Google Sheets

What happens to each request, why it matters to the business, and where the team saves time

Four confirmed actions

Adding, updating, searching for rows and getting a row by key

Custom Columns

Before starting, the sheet, fields, data types and a single key are selected

Update without duplicates

The string is searched by key, and the behavior in the absence of a result is set separately

Only the data you need

The bot responds with selected columns and a limited number of results.

Data types are taken into account

Phone, number, date, email and text are processed according to the column settings

Multiple processes separately

You can connect separate tables and sheets for leads, catalog and orders

Where teams use this integration

Practical scenarios with a clear handoff and an observable result for the team.

Leads

Saving a new application

Name, phone number, service and the result of the conversation are written in one line

Orders

Update status by number

The required fields are changed in the existing row by key

Support

Answer from the table

The bot finds the record and returns only the necessary values to the client

Let's show ChatRex on a Google Sheets test sheet

Let's set up the columns and key, add a test request and check the update and data retrieval.

How to launch the integration

1

Connecting Google Sheets

Select a Google account, table and specific sheet

2

Comparing columns

We set data types and a unique key for searching and updating

3

Check on a test sheet

Testing adding, updating, searching and no results

How ChatRex compares with other solutions

Criterion
ChatRex
Other solutions
New application
Line after confirmation
Manual copy from chat
Update
By configured key
Search for a string by an employee
Response to client
From selected columns
Manual table check
Replays
Controlled by action logic
Risk of re-entry