💡 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
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!