Automated Reservation System with Telegram, Google Gemini AI, and Google Sheets

Description

💡 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 for live availability tracking and automatically sends confirmation emails to your users.



⚙️ How It Works





Telegram Chatbot Interface
Users interact with a friendly bot to submit their reservation request. The bot collects:





Date



Name



Email



Resource / Service



Start Time & End Time



Final confirmation
All in one seamless message.



Conflict-Free Booking System
The bot checks your existing reservation sheet to avoid time overlaps before confirming.



Google Sheets Integration
Two spreadsheets are used:





Resource Info: Define available services, resources, or assets.



Reservation Log: Store confirmed reservations in structured rows.



Confirmation via Email
Once a reservation is accepted, the bot sends a detailed confirmation email to the user.



🚀 Setup Steps





Import the n8n Workflow





Use the provided .json template inside your n8n workspace.



Create Your Google Sheets





Sheet 1: Resource Info (e.g., rooms, courts, sessions, etc.)



Sheet 2: Reservation Log with these headers:



CopyEditDate | Name | Email | Resource | Start Time | End Time | Status





Set Telegram Bot Token





Create a Telegram bot and paste the token into n8n credentials.



Connect Google Sheets





Add your Google account to n8n and allow spreadsheet access.



Customize for Your Use Case





Rename “Resource” to anything (e.g., Room, Coach, Equipment).



Edit confirmation text and branding inside the “Set” and “Email” nodes.



Go Live!





Enable the workflow, and you’re ready to accept real-time reservations.

📦 What You Get





✅ One-click Telegram reservation system



✅ Conflict checker with Google Sheets



✅ Auto email confirmation



✅ User-friendly one-shot data collection



✅ Fully editable & extendable workflow



✅ Future updates and support options

🙋 Need Help Setting It Up?

If you'd like help customizing or deploying this workflow, I offer quick setup assistance and extended support.📧 Contact: [email protected]
💬 Whatsapp: +201061803236
Whether you're setting it up for your team, your club, or your business—I’m here to help!