n8n AI Support Routing: Telegram & Chat + Gemini, Google Sheets

Route Telegram and Chat messages to the right support workflow—powered by Google Gemini

This n8n automation workflow intelligently handles customer support, appointment/price requests, and complaints coming from Telegram or an n8n Chat embed—using Google Gemini for intent routing and Google Sheets / Google Calendar for real operational updates.

What this workflow does

• Triggers from your customers when a user sends a message via the n8n Chat Trigger or Telegram.
• Normalizes messages and loads conversation context for the session so routing decisions stay consistent.
• Uses Google Gemini to classify each message intent into:
  • Support
  • Appointment/Price
  • Complaint
  • A fallback route when intent can’t be determined confidently
• Support flow: searches a Supabase vector store of support documents and replies based only on retrieved content; if no answer is found, the business owner is notified on Telegram.
• Appointment & pricing: reads price information from Google Sheets, then creates/updates/cancels bookings in Google Calendar; the business owner is notified on Telegram.
• Complaint handling: generates an apology message, appends structured complaint metadata to a Google Sheets log, and alerts the business owner on Telegram.
• Returns the final response to the customer through the correct channel (Telegram message or chat output).
• Document-to-vector sync: monitors a specific Google Drive folder, updates the Supabase vectors for changed files, and refreshes searchable support knowledge.

Use cases

• Automate customer support answers for a knowledge base stored in Google Drive → Supabase vectors.
• Handle appointment and pricing requests without manual back-and-forth (Sheets + Calendar).
• Centralize complaint intake with a Google Sheets log and immediate owner notifications via Telegram.

Technical details

• n8n workflow with nodes including if, set, code, telegram, sticky note, and google drive.
• Google Gemini for intent classification and response generation (with fallback).
• Supabase vector search for support retrieval, synced from Google Drive documents.
• Google Sheets for price lists and complaint logging.
• Google Calendar for booking management.