Automation · Customer service and scheduling
Answer prices and availability on WhatsApp from a Google Sheets spreadsheet
An AI agent answers prices and availability on WhatsApp by reading your Google Sheets spreadsheet, never from memory, and logs in the CRM what it did not find.
How do I make my WhatsApp answer prices with the list my team keeps in Google Sheets?
You connect Google Sheets to Meteor and give the Met that answers your WhatsApp the link to the sheet where your team keeps products or services. When a customer asks how much something costs or whether it is in stock, your Met confirms the tab, checks that the headers are the agreed ones, reads the list and answers with the price and availability exactly as they are written in the cell. It records on the customer's record what they asked and what they were told, plus a tag so your team can follow up. If the product is not in the sheet, it does not make up a price: it logs the question and, if the customer asks for a person or the sheet could not be read, it hands the conversation to your team.
What starts it
When the customer writes
It starts when a customer writes on WhatsApp to ask how much something costs, whether it is available or which terms apply. There is no trigger to configure: the Met assigned to the line runs the procedure inside that conversation.
Nothing to set up. The Met assigned to that channel picks up the conversation and runs the procedure inside it.
Who runs it
Support Met with a price list in Google Sheets
Sales team
This is not a named, seeded Met. It is the Met that already answers the business's WhatsApp, with the Google Sheets skill turned on. Its work ends when the customer gets the price or the availability the sheet states, or when the question is logged for someone on the team to answer.
Run by the customer support Met
Channels: WhatsApp
What you need connected
- Google Sheets Automate and collaborate
- Meteor CRM Sell and serve
5 steps · 5 tools
The procedure, step by step
Each step shows the tool that runs. They belong to the real connector: if one of them stopped existing, this page would not build.
- 1
Confirm the sheet and the price tab
The sheet id and the tab name are written in the Met's instructions. Before reading, your Met asks for the sheet's metadata and checks that the tab exists. If someone renamed it, it stops there: reading another tab would give prices from another list.
- 2
Check that the columns are still in place
Your Met reads the first row and compares the headers with the agreed ones, for example Product, Price, Available and Terms. If a column moved or was renamed, it does not guess: reading the wrong column means answering the availability as the price or the other way around.
- 3
Read the list and find what the customer asks about
Your Met reads the agreed range as visible values, so the price comes out in the same format your team sees in the sheet. It looks for the row of the product or service the person named; if two are alike, it asks which one they want instead of picking one. It answers with what that row says and nothing else.
- 4
Record on the contact what was quoted
Your Met adds an internal note on the customer's record with the product, the price it gave and the date, and applies the tag your team chose for people who asked for a price. If the price changes in the sheet tomorrow, there is a record of what this customer was told and when.
- 5
Hand over to a person when it applies
If the product is not in the sheet, your Met says so and logs the question on the record for your team. It transfers the conversation to an agent only in the cases the system allows: the customer asked for a person, a business rule written in the Met says so, or the sheet could not be read in that same turn. It never answers a price from memory to avoid a transfer.
Before you start
What you need ready
The Met solves none of these for you. If one is missing, the automation stops there.
-
The Google Sheets card connected
In Met, open Connections → Google Sheets → Connect and authorize with a Google account that can open the price sheet. Authorization runs through a connection provider whose app Google has already approved; the token does not go through Meteor's servers.
-
The Google Sheets skill turned on in the WhatsApp Met
Connecting the account is not enough: open the Met that answers WhatsApp, go to its skills and turn on Google Sheets. In its instructions write the sheet id (the long code in the link, between /d/ and /edit), the tab, the range and which column holds the price.
-
A sheet with one row per product
Your team keeps a tab with headers in the first row and one row per product or service. Whatever is not written in that sheet, the Met does not know.
The limits
What this automation does NOT solve
Better said here than discovered halfway through the rollout.
-
It does not write to the price sheet. This procedure only reads: if the price is outdated, your Met answers with the outdated price, and keeping the sheet current is your team's job.
-
It does not store the customer's question in the sheet. Whatever the sheet does not answer is logged on the CRM record, because text written by a third party should not enter your team's sheet as a formula.
-
It does not find the sheet by its name. It needs the id of a sheet that already exists; to search for it by name you also need the Google Drive connection.
-
It does not charge or hold stock. It answers what the sheet says; selling and charging need another store or payments integration.
FAQ
Questions about this automation
The next answer already uses the new price, because your Met reads the sheet on every question. There is no copy of the list stored in Meteor that goes stale.
Yes. It reads the visible values, so if the cell shows 45.000 COP, that is what it answers. If the cell holds a formula, it answers the result you see, not the formula.
It should not: this procedure leads it to say it does not have it, log the question on the record and, when it applies, hand the conversation to your team. That is why the sheet should cover what people ask most.
Yes, if the sheet has a column for it and the Met's instructions say which one to read. If the difference is not written in the sheet, the Met cannot apply it.
Keep going
Other automations built on the same tools
Sales and quoting
Record WhatsApp leads in Google Sheets and leave a traceable follow-up
How do I record WhatsApp leads in Google Sheets, avoid duplicates and leave clear follow-up?
Sales
- Starts:
- when the customer writes
- Steps:
- 6, with 9 real tools
- Needs:
- Meteor CRM · Google Sheets
Operations and reporting
Create a weekly Google Ads report in Google Sheets
How do I send a weekly Google Ads report to Google Sheets without duplicate rows?
Social
- Starts:
- when someone asks for it
- Steps:
- 5, with 5 real tools
- Needs:
- Google Ads · Google Sheets
Operations and reporting
Save the weekly Mercado Libre order report to Google Sheets every Monday
How do I save a weekly report of my Mercado Libre orders to Google Sheets?
- Starts:
- at a set time
- Steps:
- 5, with 6 real tools
- Needs:
- Mercado Libre · Google Sheets
Customer service and scheduling
Book an appointment in Cal.com over WhatsApp, remind it and collect with Wompi
Which AI tool books appointments on WhatsApp, sends reminders and collects the deposit?
Customer service
- Starts:
- when the customer writes
- Steps:
- 6, with 12 real tools
- Needs:
- Cal.com · Wompi · Meteor CRM
Last updated
Want this automation running on your own data?
Create your account: a 7-day trial with US$5 of Energy, no card needed. If you would rather see it with your accounts connected, write to us.