An AI order-status bot answers “Where is my order?” automatically. In Botconsole you combine an AI dialog node (to understand the message and extract the order number) with a Google Sheets integration (to look up status) and a reply node — published to Telegram or web chat without custom code.
This is one of the highest-ROI bots for e‑commerce and retail teams living in Telegram.
Why Sheets + AI (not AI alone)
| Approach | Result |
|---|---|
| AI only | Invents tracking numbers; customers lose trust |
| Sheets/API only | Rigid menus; users hate order ID forms |
| AI + Sheets | Natural language in, verified data out |
Botconsole is built for that middle path: AI for intent, integrations for truth.
Prerequisites
- Botconsole project with Telegram connected
- A Google Sheet of orders (or a read-only export from your store)
- Columns such as:
order_id,status,tracking_url,customer_name
Example rows:
| order_id | status | tracking_url |
|---|---|---|
| 1024 | shipped | https://… |
| 1025 | packing |
Flow design (canvas)
1. Welcome
“Send your order number or ask: Where is order 1024?”
2. AI dialog — extract the order number
Prompt sketch:
- You extract
order_idfrom the user message. - Return structured fields the flow can store in variables.
- If missing, ask one clarifying question.
Store output in something like {{ai_result.order_id}} (exact variable names depend on your AI node config).
3. Google Sheets — find the row
Add a Sheets node:
- Authorize Google once
- Search/read by
order_id - Map
statusandtracking_urlinto variables
4. Branch
- Found → reply with status + tracking link
- Not found → “I couldn’t find that order. Check the number or talk to support.”
- Ambiguous → ask for email/phone used at checkout (optional second lookup)
5. Optional human handoff
If the user is angry or the order is “problem,” route to a manager path. Botconsole keeps full conversation history so the agent sees context.
Sample conversation
User: Where is my order #1024?
AI: (extracts 1024)
Sheets: shipped
Bot: Order #1024 is shipped. Track it here: …
That is the exact pattern shown on the Botconsole landing page for e‑commerce.
Tips for production
- Normalize IDs — strip
#and spaces before lookup. - Rate limits — cache frequent orders if volume is high.
- Privacy — don’t echo full addresses unless authenticated.
- Analytics — watch drop-off after “not found” replies.
- Same flow on web — publish the widget so site visitors get the same status bot (paid plans with web widget).
FAQ
Do I need a developer to connect Sheets?
No. Authorize Google in the integration node and map fields with variables.
Can I use Shopify/Airtable instead of Sheets?
Yes via REST/custom API nodes or available integrations — same AI extract → lookup → reply pattern.
Will AI invent tracking links?
Not if status comes from Sheets/API and the prompt forbids inventing logistics data. Always prefer integration fields in the final message.
Related
- How to Create a Telegram Bot Without Coding
- Chatbot CRM: Leads, UTMs & History
- One Flow: Telegram + Website Widget
Start building free → Open Botconsole, connect Sheets, and ship order status automation today.
Terms of material usage
Full or partial copying of materials is allowed only with an active and indexed link to the original source: https://botconsole.net/blog/en/3/ai-order-status-bot-google-sheets
