Automated reservation system with Telegram, Google Gemini AI, and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs on Telegram events (message). Along the way it connects Telegram, Google Gemini Chat Model, Google Sheets and Gmail and 1 more.
How it runs
Trigger: On Telegram events (message).
- Prepare Prompt (AI Transform): uses AI Transform
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 3 tools (Gmail, court info, Google Sheets); memory: Postgres Chat Memory
- Telegram: uses Telegram
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
- Also check AI Transform: Automatically migrated to a Code node on upgrade, keeping the generated JavaScript. You can no longer add new AI Transform nodes.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Telegram Trigger
n8n-nodes-base.telegramTrigger - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - Gmail Tool
n8n-nodes-base.gmailTool - Telegram
n8n-nodes-base.telegram - AI Agent
@n8n/n8n-nodes-langchain.agent - AI Transform
n8n-nodes-base.aiTransform - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat
From the author
💡 What It Is SmartReserve is a flexible, automated Telegram chatbot built in n8n that allows users to request and confirm reservations for any kind of resource—training sessions, equipment, appointments, event slots, or more. It connects with Google Sheets…