{"product_id":"n8n-telegram-support-bot-gemini-ai-google-sheets-calendar","title":"n8n Telegram Support Bot: Gemini AI, Google Sheets \u0026 Calendar","description":"\u003ch3\u003eTurn Telegram (and n8n Chat) messages into AI support, pricing, and appointment workflows—fully automated with Google Gemini\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow connects \u003cstrong\u003eTelegram\u003c\/strong\u003e (and an \u003cstrong\u003en8n Chat trigger\u003c\/strong\u003e) to \u003cstrong\u003eGemini AI\u003c\/strong\u003e for instant customer support from your knowledge base, while also handling \u003cstrong\u003eGoogle Sheets pricing\u003c\/strong\u003e and \u003cstrong\u003eGoogle Calendar appointments\u003c\/strong\u003e. If answers are missing, it escalates to your team via \u003cstrong\u003eTelegram\u003c\/strong\u003e—and logs complaints to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives messages\u003c\/strong\u003e from Telegram or an n8n Chat trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload\u003c\/strong\u003e into a unified session, user, and message format, loads recent conversation history, and classifies the request as \u003cstrong\u003eSupport\u003c\/strong\u003e, \u003cstrong\u003eAppointment\/Pricing\u003c\/strong\u003e, or \u003cstrong\u003eComplaint\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSupport requests:\u003c\/strong\u003e uses \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to answer support questions by searching a \u003cstrong\u003eSupabase vector store\u003c\/strong\u003e document collection (using \u003cstrong\u003eOpenAI embeddings\u003c\/strong\u003e). If the knowledge lookup can’t support an answer, it notifies the business owner via \u003cstrong\u003eTelegram\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppointment\/Pricing requests:\u003c\/strong\u003e retrieves pricing from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, then \u003cstrong\u003echecks\/creates\/updates\/cancels\u003c\/strong\u003e appointments in \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e. The business owner receives a brief \u003cstrong\u003eTelegram\u003c\/strong\u003e notification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComplaint requests:\u003c\/strong\u003e generates an apology plus a structured summary, appends the complaint to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, alerts the business owner via \u003cstrong\u003eTelegram\u003c\/strong\u003e, and prepares the customer-facing response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns the final response\u003c\/strong\u003e to the customer in Telegram (or back to the chat channel, depending on the trigger source).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCustomer support for a SaaS or service business that needs instant answers from vector docs.\u003c\/li\u003e\n  \u003cli\u003eAutomated scheduling: confirm, update, or cancel bookings in Google Calendar with pricing from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eComplaint intake with structured logging and owner alerts—without manual copy\/paste.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore n8n nodes:\u003c\/strong\u003e if, set, code, telegram, sticky note, google drive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI + knowledge:\u003c\/strong\u003e Google Gemini + Supabase vector store search with OpenAI embeddings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData + actions:\u003c\/strong\u003e Google Sheets (pricing + complaint logging) and Google Calendar (appointment lifecycle management).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEscalation:\u003c\/strong\u003e Telegram owner notifications when support answers are missing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDocument sync:\u003c\/strong\u003e separate trigger on \u003cstrong\u003eGoogle Drive\u003c\/strong\u003e document create\/update to download files (for keeping knowledge current).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46217922412723,"sku":"N8N-20816","price":45.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/aCqIJlTY2G1hCoaPWGWJM_tlUdovT0.png?v=1791883390","url":"https:\/\/buyflowscripts.com\/products\/n8n-telegram-support-bot-gemini-ai-google-sheets-calendar","provider":"N8N Commerce","version":"1.0","type":"link"}