Handle e-commerce support on Telegram with Gemini and Google Sheets

Telegram E-Commerce Customer Support Bot with AI Agent & Google Sheets

An AI-powered Telegram bot that automates customer support for e-commerce stores — handling order tracking, order cancellations, and support ticket creation, all without human intervention.

Built with a Gemini AI Agent + Simple Memory, the bot understands natural language, remembers the conversation context per user, and reads/writes directly to your Google Sheets — no database or backend required.

---

How It Works

- A customer messages the Telegram bot or taps a menu button - The AI Agent (powered by Google Gemini) reads the message and decides what to do - Simple Memory keeps track of the full conversation per user, so the bot never forgets context mid-flow - The agent calls one of three Google Sheets tools depending on intent: - Read Orders Sheet — looks up order details by Order ID or email - Update Order Status — sets an order's status to Cancelled after confirmation - Create Support Ticket — appends a new ticket row to the support sheet with auto-categorisation - The response is sent back to the user via Telegram

---

How to Use