Telegram Order Tracking & FAQ Bot with Gemini + Google Sheets

Turn Telegram messages into instant order tracking + FAQ replies using Gemini and Google Sheets

This n8n workflow answers customers in Telegram by automatically detecting whether a message asks for order status or an FAQ. It uses Google Gemini (Google PaLM) for intent detection and FAQ generation, pulls the right data from Google Sheets, logs every conversation, and replies back in Telegram—fully automated.

What this workflow does

• Receives an incoming Telegram customer message in n8n.
• Uses Google Gemini to:
  • Classify the message intent: order status vs FAQ
  • Extract an order ID when the user requests status
• If intent is order status, looks up the order in the Google Sheets (ORDERS) sheet by order_id and formats a tracking/status reply (or a “not found” prompt if no match exists).
• If intent is FAQ, reads FAQ entries from the Google Sheets (FAQ) sheet and uses Google Gemini to generate an answer based on the stored question/answer content.
• Writes a conversation log to Google Sheets (CONVERSATION) including timestamp, chat ID, customer message, detected intent, order ID, and the generated reply.
• Sends the prepared response back to the customer via Telegram.

Use cases

• Customers message your Telegram bot to get real-time shipping/tracking updates using an order ID.
• Reduce support load by answering common questions from a centralized FAQ stored in Google Sheets.
• For SaaS operators, maintain one conversational layer across order inquiries and product/service FAQ—without manual handling.

Technical details

• Telegram node for inbound/outbound messaging
• Google Gemini (Google PaLM) for intent detection and FAQ answering
• Google Sheets with required sheets: ORDERS, FAQ, CONVERSATION
• n8n logic using nodes including if, set, and aggregate

Set up credentials for Telegram, Google Gemini, and Google Sheets (service account + sheet sharing), update your spreadsheet ID and sheet names if needed, and your Telegram bot will start replying automatically.