Delivery Booking in Chat for a Google Sheets Store
Yes. AeroChat books the delivery for orders in your Google Sheets store, in the same chat. It offers the delivery options you run, quotes the fee, books the shipment with your courier through its API once the order is paid, adds the courier and tracking reference to the order row in your Sheet and sends the tracking link to the customer.
This recipe books delivery for chat orders. Part of connecting Google Sheets to WhatsApp and AI chat, using the built-in Google Sheets store.
What happens today
An order comes in on chat. You open the courier’s website, retype the address, pick a pickup slot, copy the tracking number back into your Sheet and message it to the customer. A customer who wants same-day delivery waits while you get a quote.
The flow that works
- The customer orders in chat. AeroChat writes the order to the Orders tab with the delivery address.
- It offers the delivery options you set, such as standard or same-day, with the fee from your knowledge base or a live quote from your courier’s API.
- The customer picks one. AeroChat adds the delivery fee to the order and sends the payment link.
- When the payment is confirmed, it books the shipment with your courier through its API, using the address and the parcel size you set for that product.
- It writes the courier and tracking reference to the order row and sends the tracking link in the chat.
- If the courier cannot take the booking, for example the address is outside its area, it tells the customer and hands the conversation to your team.
What it looks like on WhatsApp
Customer: Can I get the flower box delivered today? (example)
AeroChat: Yes, for orders paid before 1pm. Same-day delivery to your address is US$9.40 and standard next-day delivery is US$5 (example). Which would you like?
Customer: Same day please
AeroChat: Your total is US$64.40. Pay here and I will book the driver: [payment link]
AeroChat: Payment received. Your same-day delivery is booked and the driver picks up at 2pm. Track it here: [tracking link]
In your Google Sheet: the order row is marked paid, with the courier and the tracking reference added.
The recipe
Copy this into AeroChat
When a customer orders and needs delivery, follow these steps.
- Make sure the order in the Orders tab has the full delivery address.
- Offer standard delivery at US$5 (example). If they ask for same-day and it is before 1pm (example), get a live same-day quote from our courier and offer it.
- Add the delivery fee they chose to the order and send the payment link.
- When it is paid, book the shipment with our courier for that address and option.
- Add the courier and tracking reference to the order row and send them the tracking link.
- If the courier cannot take the booking, tell them and hand the conversation to our team.
Never book delivery for an unpaid order. Never promise a delivery time the courier did not give. Reply in the customer’s language.
Change the fees, the same-day cut-off and the courier 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 courier. POS Malaysia is built in for sellers in Malaysia. Couriers and shipping tools with a public API connect with their key, for example Lalamove for same-day delivery, EasyParcel, Easyship and Shippo.
- Payment. Airwallex is built in. Stripe and HitPay connect with an API key. Payment links are on Growth and above.
- Your knowledge base. Add your delivery options, fees, areas, cut-off times and the parcel size for each product.
After you paste the recipe, AeroChat builds the workflow as a draft and shows a checklist: add your courier’s key and your delivery settings, then 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
- Which delivery options you offer, and their fees and cut-off times.
- Which courier books each option.
- When a booking problem goes to your team.
The result to expect
Paid chat orders get booked with the courier without you retyping addresses, and the tracking reference is in your Sheet and in the customer’s chat at the same time.
Measure it with your own numbers: time from payment to booking, and address mistakes, for a month before and after.
Next: see every Google Sheets workflow, including order status. For other store platforms, see delivery booking 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 and courier behind it. On TikTok Shop, shipping stays in TikTok Shop.
Book the courier from the chat
Start the trial, connect your store Sheet and your courier, paste the recipe and book a test delivery from 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.