Superchat Booking to Sheets

Superchat Booking Assistant

This workflow automates the process of handling booking requests coming from Superchat. It captures incoming booking data, processes and confirms the booking details, logs them into Google Sheets, and sends a friendly confirmation message back to the customer through Superchat's Telegram channel.

What It Does

1. Listens for incoming booking requests from Superchat via a webhook trigger.
2. Uses an AI agent to extract and process customer and booking details, including parsing appointment times and deciding booking status.
3. Logs each booking into a specified Google Sheets spreadsheet for record-keeping.
4. Sends a personalized confirmation message back to the customer through Superchat's Telegram channel.
5. Handles cases where bookings might be made for someone other than the customer by analyzing the service and name data.

What You Need

• A Superchat account with access to Telegram channel integration.
• API credentials for Superchat (API key and Telegram channel ID).
• A Google Sheets account with access to the target spreadsheet and a worksheet named "Sheet1".
• A Needle platform account configured with connectors for Google Sheets and Superchat.

How the Flow Works

Step-by-Step Breakdown

1. Webhook Trigger — The workflow starts when Superchat sends a booking request payload to the webhook endpoint. This payload includes the customer's name, requested service, appointment date/time, and conversation ID.

2. AI Agent Processing — The AI agent receives the raw booking data and performs several tasks:

   • Combines the customer's first and last name.
   • Parses the requested appointment time into RFC 3339 format in the Berlin timezone (+02:00).
   • Calculates a one-hour appointment window.
   • Reads existing bookings from Google Sheets to check for conflicts and sets the booking status to "confirmed" or "denied" accordingly.
   • Logs the new booking as a row in the specified Google Sheets spreadsheet.
   • Composes a friendly, personalized reply message in the customer's language.

3. Confirmation Message — The HTTP Request node sends the generated reply message back to the customer via Superchat's Telegram channel API, using the conversation identifier and your API credentials.

Output

At the end of this workflow, the customer receives a friendly, personalized confirmation message in their preferred language confirming their booking details. Meanwhile, the booking information is securely logged into Google Sheets for easy tracking and management.

Notes

• The AI agent converts the requested appointment time to Berlin timezone (+02:00) and calculates a one-hour appointment window.
• Booking status is determined based on existing booked slots read from Google Sheets, helping avoid double bookings.
• Since some customers might book on behalf of friends, the AI agent analyzes the service name field to correctly identify the actual customer's name.
• Make sure your Google Sheets connector has permission to add and read rows from the specified spreadsheet before running the workflow.
• Keep your Superchat API key and Telegram Channel ID secure to prevent unauthorized access.