Oct 20 • General discussion
Done task
Booking + Payment Proof + Admin Approval (Telegram)
📌 Overview:
This workflow automates the end-to-end booking process, including:
Booking intake via Telegram
Intelligent message handling with AI
Google Sheet updates for service details and payment records
Admin approval & event creation in Google Calendar
Automatic customer notifications
---
🧩 Step-by-Step Breakdown
1. Telegram Trigger & Message Normalization
The workflow starts when a customer sends a message to the Telegram bot.
The message is then normalized (e.g., callback queries, message text) to ensure a consistent format for processing.
---
2. AI Processing & Intent Detection
An AI Agent (OpenAI Chat node with Simple Memory) analyzes the message to detect the user’s intent (e.g., book, faq, payment).
The response is parsed into structured JSON for routing.
---
3. FAQ & Booking Handling
If the intent is FAQ, the bot automatically replies with pre-defined answers.
If the intent is Booking:
If customer details are incomplete, the bot requests more info.
If details are complete, it appends booking data to a Google Sheet.
---
4. Service Price & Receipt Collection
The workflow applies service price rules and branches based on the selected service (e.g., Haircut, Hair Color, Manicure, Pedicure).
It asks the user to send a payment receipt for the corresponding service.
Once received, the price is added to the correct Google Sheet tab.
---
5. Payment Proof Handling
For messages with payment proof intent, the bot retrieves the file from Telegram, downloads it, and uploads it to a storage (e.g., Google Drive).
The corresponding row in the sheet is updated with a link to the uploaded receipt.
The admin is notified for verification.
---
6. Admin Approval & Calendar Event
The workflow waits for an admin approval action via Telegram.
If approved:
The booking is marked as “Approved” in the sheet.
A Google Calendar event is created with the booking details.
The customer receives a Telegram confirmation message.
---
📝 Key Features
✅ Fully automated Telegram-to-Google Sheets booking pipeline
🧠 Intent detection with AI (no manual routing)
📎 Receipt handling with file upload and admin checks
📅 Google Calendar integration for confirmed bookings
🔔 Automated notifications for both admin and customer
4:46
11
11 comments
Done task
skool.com/ai-automation-agency-ph
This is a community where anyone can join, learn, and apply real-world AI and automation skills no tech background needed.
Leaderboard (30-day)
1
🔥
+20
2
+6
3
+6
4
+2
5
+2
Powered by