Order Status in Chat for a Google Sheets Store
Yes. AeroChat answers “where is my order?” from the Orders tab of your Google Sheets store. It finds the customer’s order by their phone number, and replies with the payment status, the delivery status and the tracking reference your team entered in the Sheet. If your courier has a public API, it can check the latest scan too.
This recipe handles order status questions from your own Sheet. Part of connecting Google Sheets to WhatsApp and AI chat, using the built-in Google Sheets store.
What happens today
A customer asks where their order is. You open the Sheet, search for their name, scroll to the delivery column, copy the tracking number and reply. On a busy day you do this dozens of times, and the customers you have not answered yet ask again.
The flow that works
- The customer asks about their order in chat.
- AeroChat looks up the order in the Orders tab by the customer’s phone number. If they have more than one order, it asks which one.
- It reads the payment status, the delivery status and the tracking reference in that row.
- It replies in plain words. If there is a tracking reference, it sends it with the courier’s tracking link.
- If the order is paid but not yet sent, it gives your dispatch time.
- If the order is late against your delivery times, or the customer reports a problem, it hands the conversation to your team with the order row.
What it looks like on WhatsApp
Customer: Hi, any update on my order? (example)
AeroChat: I found your order SH-1187 from Monday: 1 x Batik shirt, size L. It is paid and was sent yesterday. The tracking reference is EP123456789MY (example). You can track it here: [tracking link]
Customer: Ok great thanks
In your Google Sheet: nothing changes. AeroChat read the order row for that phone number.
The recipe
Copy this into AeroChat
When a customer asks about their order, follow these steps.
- Look up their orders in the Orders tab by their phone number. If they write from a different number, ask for the order reference and the phone number on the order.
- If there is more than one order, ask which one.
- Tell them the payment status and delivery status in plain words.
- If there is a tracking reference, send it with the tracking link.
- If the order is paid but not sent, tell them we send orders within 2 working days of payment (example).
- If it has not arrived 5 working days after sending (example), or they report a problem, hand the conversation to our team.
Never guess a delivery date. Never share another customer’s order. Reply in the customer’s language.
Change the dispatch and delivery times to your own.
What to connect
- Your Google Sheets store. Built in. Copy the AeroChat store template into your Google Drive, share it with AeroChat as an editor, paste the connection code into the Settings tab, and paste the Sheet’s link into AeroChat. See sell from a Google Sheet.
- Your delivery and tracking columns. Your team types the delivery status and tracking reference into the Orders tab. AeroChat reads them back and never overwrites cells it did not change.
- Your courier, if you want live scans. POS Malaysia is built in for sellers in Malaysia. Tracking tools such as AfterShip and 17TRACK connect through their APIs.
Using a different system? If it has a public API, it connects to AeroChat the same way: describe what you want, paste in its key, and it runs.
Can’t find your tool? Message us in the chat on this page and we’ll tell you how it connects.
What you still decide
- The words AeroChat uses for each delivery status you type in the Sheet.
- Your dispatch and delivery times.
- When a late order goes to your team.
The result to expect
Customers get their order status in seconds, any time of day, from the same Sheet your team already updates. You stop searching rows to answer the same question.
Measure it with your own numbers: order status questions answered in chat, and repeat “any update?” messages, for a month before and after.
Next: see every Google Sheets workflow, including delivery booking. For other store platforms, see order status in chat.
Works on every chat channel
This workflow runs the same way on WhatsApp, Instagram, Facebook Messenger, Telegram, web chat and email, with the same Google Sheet behind it. See the WhatsApp order tracking workflow.
Answer order questions from your Sheet
Start the trial, connect your store Sheet, paste the recipe and ask your own chat where a test order is.
Start your 7-day free trial. No credit card needed.
Sign up for an annual plan on Growth or above and we’ll set up your workflows and connect your store for you, free. See plans.