n8n Telegram Support Bot: Gemini AI, Google Sheets & Calendar

Turn Telegram (and n8n Chat) messages into AI support, pricing, and appointment workflows—fully automated with Google Gemini

This n8n workflow connects Telegram (and an n8n Chat trigger) to Gemini AI for instant customer support from your knowledge base, while also handling Google Sheets pricing and Google Calendar appointments. If answers are missing, it escalates to your team via Telegram—and logs complaints to Google Sheets.

What this workflow does

• Receives messages from Telegram or an n8n Chat trigger.
• Normalizes the payload into a unified session, user, and message format, loads recent conversation history, and classifies the request as Support, Appointment/Pricing, or Complaint.
• Support requests: uses Google Gemini to answer support questions by searching a Supabase vector store document collection (using OpenAI embeddings). If the knowledge lookup can’t support an answer, it notifies the business owner via Telegram.
• Appointment/Pricing requests: retrieves pricing from Google Sheets, then checks/creates/updates/cancels appointments in Google Calendar. The business owner receives a brief Telegram notification.
• Complaint requests: generates an apology plus a structured summary, appends the complaint to Google Sheets, alerts the business owner via Telegram, and prepares the customer-facing response.
• Returns the final response to the customer in Telegram (or back to the chat channel, depending on the trigger source).

Use cases

• Customer support for a SaaS or service business that needs instant answers from vector docs.
• Automated scheduling: confirm, update, or cancel bookings in Google Calendar with pricing from Google Sheets.
• Complaint intake with structured logging and owner alerts—without manual copy/paste.

Technical details

• Core n8n nodes: if, set, code, telegram, sticky note, google drive.
• AI + knowledge: Google Gemini + Supabase vector store search with OpenAI embeddings.
• Data + actions: Google Sheets (pricing + complaint logging) and Google Calendar (appointment lifecycle management).
• Escalation: Telegram owner notifications when support answers are missing.
• Document sync: separate trigger on Google Drive document create/update to download files (for keeping knowledge current).