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.