{"product_id":"telegram-order-tracking-faq-bot-with-gemini-google-sheets","title":"Telegram Order Tracking \u0026 FAQ Bot with Gemini + Google Sheets","description":"\u003ch3\u003eTurn Telegram messages into instant order tracking + FAQ replies using Gemini and Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow answers customers in \u003cstrong\u003eTelegram\u003c\/strong\u003e by automatically detecting whether a message asks for \u003cstrong\u003eorder status\u003c\/strong\u003e or an \u003cstrong\u003eFAQ\u003c\/strong\u003e. It uses \u003cstrong\u003eGoogle Gemini (Google PaLM)\u003c\/strong\u003e for intent detection and FAQ generation, pulls the right data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, logs every conversation, and replies back in Telegram—fully automated.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives an incoming \u003cstrong\u003eTelegram\u003c\/strong\u003e customer message in n8n.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to:\n    \u003cul\u003e\n      \u003cli\u003eClassify the message intent: \u003cem\u003eorder status\u003c\/em\u003e vs \u003cem\u003eFAQ\u003c\/em\u003e\n\u003c\/li\u003e\n      \u003cli\u003eExtract an \u003cstrong\u003eorder ID\u003c\/strong\u003e when the user requests status\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eIf intent is \u003cstrong\u003eorder status\u003c\/strong\u003e, looks up the order in the \u003cstrong\u003eGoogle Sheets (ORDERS)\u003c\/strong\u003e sheet by \u003cstrong\u003eorder_id\u003c\/strong\u003e and formats a tracking\/status reply (or a “not found” prompt if no match exists).\u003c\/li\u003e\n  \u003cli\u003eIf intent is \u003cstrong\u003eFAQ\u003c\/strong\u003e, reads FAQ entries from the \u003cstrong\u003eGoogle Sheets (FAQ)\u003c\/strong\u003e sheet and uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to generate an answer based on the stored question\/answer content.\u003c\/li\u003e\n  \u003cli\u003eWrites a conversation log to \u003cstrong\u003eGoogle Sheets (CONVERSATION)\u003c\/strong\u003e including timestamp, chat ID, customer message, detected intent, order ID, and the generated reply.\u003c\/li\u003e\n  \u003cli\u003eSends the prepared response back to the customer via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCustomers message your Telegram bot to get real-time shipping\/tracking updates using an order ID.\u003c\/li\u003e\n  \u003cli\u003eReduce support load by answering common questions from a centralized FAQ stored in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eFor SaaS operators, maintain one conversational layer across order inquiries and product\/service FAQ—without manual handling.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e node for inbound\/outbound messaging\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini (Google PaLM)\u003c\/strong\u003e for intent detection and FAQ answering\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with required sheets: \u003cstrong\u003eORDERS\u003c\/strong\u003e, \u003cstrong\u003eFAQ\u003c\/strong\u003e, \u003cstrong\u003eCONVERSATION\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003en8n logic using nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, and \u003cstrong\u003eaggregate\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eSet 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.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45862249038003,"sku":"N8N-18320","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/DPwgcqejpg7btFFBXtQGa_nfS5JzNO.png?v=1786957723","url":"https:\/\/buyflowscripts.com\/products\/telegram-order-tracking-faq-bot-with-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}