Order Confirmation in Chat for a Google Sheets Store
Yes. AeroChat confirms every order from your Google Sheets store in the chat it came from. It writes the order to the Orders tab of your Sheet, sends the customer a clear summary of the items, total, delivery fee and address to check, and confirms again once the payment comes in, with the order marked paid in your Sheet.
This recipe sends the order confirmation for orders taken in chat. Part of connecting Google Sheets to WhatsApp and AI chat, using the built-in Google Sheets store.
What happens today
A customer orders in chat. You type the order into your Sheet, work out the total and delivery fee, and send a message back. A wrong size or a missing unit number only shows up when the parcel comes back. The customer pays and then asks whether you got the money, because no one confirmed it.
The flow that works
- The customer chooses products in chat. AeroChat reads the price, options and stock from the Products tab.
- It collects the name, phone number and delivery address.
- It writes the order to the Orders tab with the items, amount, delivery fee and customer details.
- It sends a summary to check: each item with its option and quantity, the delivery fee, the total and the address.
- If the customer corrects anything, it updates the order row before payment.
- It sends the payment link. When the payment is confirmed, it marks the order paid in the Sheet and sends the confirmation with the order reference and your dispatch time.
What it looks like on WhatsApp
Customer: Ok I’ll take 2 of the lemon cakes, the 6 inch. (example)
AeroChat: Sure. What name and delivery address should I put on the order?
Customer: Mei Lin, Block 12 Tampines St 41, #05-210
AeroChat: Please check your order. 2 x Lemon cake, 6 inch, US$28 each. Delivery US$5. Total US$61. Deliver to Mei Lin, Block 12 Tampines St 41, #05-210 (example). Is this right?
Customer: Yes
AeroChat: Thank you. Here is your payment link: [link]
AeroChat: Payment received. Your order SH-1042 is confirmed and goes out on Thursday (example).
In your Google Sheet: a new row in the Orders tab with the items, amount, delivery fee and customer details, marked paid.
The recipe
Copy this into AeroChat
When a customer orders in chat, follow these steps.
- Use the Products tab for prices, options and stock. Offer only products in stock.
- Ask for their name, phone number and delivery address.
- Create the order in the Orders tab with the items, amount, delivery fee and customer details.
- Send a summary to check: each item with option and quantity, the delivery fee, the total and the address. Ask them to confirm.
- If they change anything, update the order before sending the payment link.
- Send the payment link. When it is paid, mark the order paid and confirm it with the order reference and our dispatch time.
- If they want to change the order after paying, hand the conversation to our team.
Never confirm an order that is not paid. Never offer a discount. Reply in the customer’s language.
Add your delivery fees and dispatch days to your knowledge base before you paste it.
What to connect
- Your Google Sheets store. Built in. Copy the AeroChat store template into your Google Drive. It has Products, Orders and Settings tabs. 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.
- Payment. Airwallex is built in, and funds settle into your Airwallex balance. Stripe and HitPay connect with an API key. Payment links are on Growth and above.
- Your knowledge base. Add your delivery fees, delivery areas and dispatch days.
After you paste the recipe, AeroChat builds the workflow as a draft and shows a checklist of what is left to connect. Then you switch it on.
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
- Your delivery fees, delivery areas and dispatch days.
- What the confirmation message says after payment.
- Which changes after payment go to your team.
The result to expect
Every chat order lands in your Sheet with the right items and address, checked by the customer before they pay. Customers get a confirmation the moment the payment comes in, so they stop asking whether you received it.
Measure it with your own numbers: orders with a wrong address or item, and “did you get my payment?” messages, for a month before and after.
Next: see every Google Sheets workflow, including payment links and order status. For the same workflow on other store platforms, see order confirmation 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. On TikTok Shop, orders and payment stay in TikTok Shop. If you later send confirmations outside the 24-hour WhatsApp customer service window, use an approved template, such as the order confirmation templates.
Confirm every chat order without typing it out
Start the trial, copy the store template, paste the recipe and place a test order in your own chat.
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.