telegram court agent

🧠 Purpose
This workflow powers a general-purpose reservation bot using Telegram, Google Sheets, and Email. Users send one message to request a reservation—it's validated against existing bookings, stored, and confirmed automatically.

📥 Input Collected (in one go):

Date

Name

Email

Resource (court, room, etc.)

Start Time

End Time

Confirm (by replying "yes")

🧩 Main Logic Flow

Telegram Trigger → captures full request

Function → parses message fields

Google Sheets → checks for availability

Decision Node → validates time slot

Google Sheets → appends confirmed data

Email Node → sends confirmation

Telegram → replies with confirmation summary

📄 Google Sheets Setup Required

Resource Info sheet (optional reference)

Reservation Log sheet with these headers:


Copy
Edit
Date | Name | Email | Resource | Start Time | End Time | Status
⚠️ Notes

All data is captured from a single user input (no multi-step flow).

Time conflict logic uses date + resource + time slot.

You can rename "Resource" to anything (Room, Coach, Session, etc.)

📬 Publisher Support
Need help customizing or deploying this bot?
📧 tharwat.elsayed.hamad@gmail.com