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

**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** 1. Import the n8n Workflow - Use the provided .json template inside your n8n workspace. 2. Create Your Google Sheets - Sheet 1: Resource Info (e.g., rooms, courts, sessions, etc.) - Sheet 2: Reservation Log with these headers: - Date | Name | Email | Resource | Start Time | End Time | Status 3. Set Telegram Bot Token - Create a Telegram bot and paste the token into n8n credentials. 4. Connect Google Sheets - Add your Google account to n8n and allow spreadsheet access. 5. 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. 6. 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: tharwat.elsayed.hamad@gmail.com WhatsApp: +201061803236 Whether you're setting it up for your team, your club, or your business—I'm here to help!

Platform

n8n

Category

Communication

Price

Free

Creator

Tharwat Mohamed

• telegram
• gmailTool
• stickyNote
• aiTransform
• agent
• telegramTrigger
• googleSheetsTool
• lmChatGoogleGemini
• memoryPostgresChat