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.