Skip to content

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

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. 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. 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. 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. 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. 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 limits

What this automation does NOT solve

Better said here than discovered halfway through the rollout.

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

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.