Integration · Google Sheets
Leads from Google Sheets — straight to the customer on WhatsApp
Chato watches your spreadsheet: when a new row with a phone number appears, the customer gets a message, and the reply lands in the shared inbox together with your other chats.
The problem
Leads from the website, ads and forms land in a Google Sheet, and then someone has to open it, copy the number and write by hand. That takes hours, and in the meantime the customer goes to whoever replied first.
Connect the spreadsheet once — Chato will check it on its own. As soon as a new row appears in the sheet, the platform takes the phone number from it and sends the customer a preset message: from a regular WhatsApp number or as an official template via the WhatsApp Business API.
The customer's reply does not disappear into nowhere: the conversation opens in the shared Chato inbox next to your other chats, the whole team can see it, and it can be handed to a manager. If the AI assistant is on, it picks up the conversation itself — asks about the line of business, the task and the budget, and calls in a person when the customer is ready to talk specifics.
It works the other way too. Chato can append the people the AI has already qualified to the spreadsheet: you set the columns yourself in the settings, and the date is written in the workspace time zone. The result is a closed loop: a lead from the spreadsheet — a message — a conversation — back to the spreadsheet, now with the answers.
What the integration can do
A message for every new row
A lead comes in — the customer gets a message within minutes, not whenever someone gets around to the spreadsheet.
Values from columns
Name, service, city — any fields from the row are inserted into the message text.
Regular number or WABA
You can write from your business WhatsApp or with an official Meta template if the list is cold.
Replies go to the shared inbox
The conversation opens next to your other chats, the team can see it, and it can be handed to a colleague.
AI picks up the conversation
The assistant qualifies the customer and calls in a manager when the conversation gets down to business.
Results written back
Qualified customers are appended to the spreadsheet — with the columns you have set.
How to set it up
Connect your Google account
In the integrations section, allow Chato access to the spreadsheet you need — only to it, not to your whole Drive.
Choose the sheet and the phone number column
Chato takes the number from the selected column and converts it to international format on its own.
Write the message text
Plain text for a business number, or an approved template if you send via WABA.
Turn it on and test it
Add one test row with your own number to the spreadsheet and make sure the message arrives.
Frequently asked questions
What format should the numbers be in?
Almost any will do: +7 777 000 00 00, 87770000000 or with a prefix like p:+7777.... Chato cleans up the value and converts it to international format on its own.
What happens to existing rows when I connect?
Nothing is sent to them. Messages go only to rows that appear after you turn it on — so you do not accidentally write to your whole list at once.
Can I write to a cold list?
Only through the official WhatsApp Business API with a Meta-approved template. Bulk first messages from a regular QR number lead to a ban — that is a WhatsApp rule.
How often does Chato check the spreadsheet?
Regularly, in the background. In practice, minutes rather than hours pass between a row appearing and the message being sent.
Do I need a developer?
No. You connect by simply signing in to your Google account, and the message text and columns are chosen in the interface.
Try it with your own customers
The first 3 days are free, no card needed. Connecting channels takes about half an hour.
Start for free