{"product_id":"n8n-ai-support-routing-telegram-chat-gemini-google-sheets","title":"n8n AI Support Routing: Telegram \u0026 Chat + Gemini, Google Sheets","description":"\u003ch3\u003eRoute Telegram and Chat messages to the right support workflow—powered by Google Gemini\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow intelligently handles customer support, appointment\/price requests, and complaints coming from \u003cstrong\u003eTelegram\u003c\/strong\u003e or an \u003cstrong\u003en8n Chat\u003c\/strong\u003e embed—using \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for intent routing and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e \/ \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e for real operational updates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers from your customers\u003c\/strong\u003e when a user sends a message via the \u003cstrong\u003en8n Chat Trigger\u003c\/strong\u003e or \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes messages and loads conversation context\u003c\/strong\u003e for the session so routing decisions stay consistent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini\u003c\/strong\u003e to classify each message intent into:\n    \u003cul\u003e\n      \u003cli\u003e\u003cstrong\u003eSupport\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eAppointment\/Price\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003e\u003cstrong\u003eComplaint\u003c\/strong\u003e\u003c\/li\u003e\n      \u003cli\u003eA \u003cstrong\u003efallback route\u003c\/strong\u003e when intent can’t be determined confidently\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupport flow:\u003c\/strong\u003e searches a \u003cstrong\u003eSupabase vector store\u003c\/strong\u003e of support documents and replies based only on retrieved content; if no answer is found, the business owner is notified on \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppointment \u0026amp; pricing:\u003c\/strong\u003e reads price information from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then creates\/updates\/cancels bookings in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e; the business owner is notified on \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComplaint handling:\u003c\/strong\u003e generates an apology message, appends structured complaint metadata to a \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e log, and alerts the business owner on \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns the final response\u003c\/strong\u003e to the customer through the correct channel (Telegram message or chat output).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDocument-to-vector sync:\u003c\/strong\u003e monitors a specific \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e folder, updates the \u003cstrong\u003eSupabase\u003c\/strong\u003e vectors for changed files, and refreshes searchable support knowledge.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate customer support answers for a knowledge base stored in Google Drive → Supabase vectors.\u003c\/li\u003e\n  \u003cli\u003eHandle appointment and pricing requests without manual back-and-forth (Sheets + Calendar).\u003c\/li\u003e\n  \u003cli\u003eCentralize complaint intake with a Google Sheets log and immediate owner notifications via Telegram.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n\u003c\/strong\u003e workflow with nodes including \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e, and \u003cstrong\u003egoogle drive\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e for intent classification and response generation (with fallback).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupabase vector search\u003c\/strong\u003e for support retrieval, synced from \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e documents.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for price lists and complaint logging.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e for booking management.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46172948070579,"sku":"N8N-20579","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/59N8paIoeVxXKre6g9Is5_BV8cSa7V.png?v=1791364557","url":"https:\/\/buyflowscripts.com\/products\/n8n-ai-support-routing-telegram-chat-gemini-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}