An automated assistant developed with Openclaw Skills that handles studio bookings, qualifications, and secure payments directly inside Telegram.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install studio-booking
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install studio-booking using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Studio Booking?
The Studio Booking assistant is a production-ready scheduling and transaction management solution designed to handle the complex operations of recording studios, rehearsal spaces, and vocal booths. Utilizing the capabilities of Openclaw Skills, this system establishes a reliable AI agent inside Telegram to manage reservations, check real-time slot availability, recommend complementary production packages, and process secure payments.
By deploying this automation, studio owners can eliminate manual booking back-and-forth, automate client qualification, and reduce calendar empty spots. Built with enterprise-grade transactional integrity, the system manages high-concurrency scheduling, processes secure checkout links via TelegaPay, and synchronizes status updates in real-time.
Studio Booking Use Cases
- Managing and scheduling recording studio reservations, instrument tracking, vocal sessions, mixing, or rehearsals via Telegram.
- Automating lead qualification for sound engineers by determining client project scope, necessary gear, and budget limits.
- Eliminating billing friction by sending instant, secure TelegaPay checkout links for automated invoicing, holds, and refunds.
- Coordinating calendar operations such as booking cancellations, session rescheduling, and slot availability updates.
- Running automated follow-ups and marketing campaigns based on customer booking history and loyalty milestones.
How Studio Booking Works
- Structured Intake: The customer interacts with the Telegram bot interface to initialize a session reservation.
- Lead Qualification: The system qualifies the user, determining if they are a new or returning client, and references previous configurations or loyalty metrics.
- Availability Checks: The assistant queries the SQL database to discover open slots for the requested date, ignoring pending or unconfirmed sessions.
- Cross-Selling Engine: Based on the primary selection, the system applies a dynamic matrix to offer extra services (e.g., sound engineer, mastering) with defined markup rules.
- SAGA Booking Registration: To ensure database consistency, a 5-step SAGA orchestration engine books the slot, reserves the payment hold, updates the admin, and confirms the details with the user.
- Secure Payment Execution: A cryptographically signed TelegaPay payment link is generated using HMAC-SHA256 for fast, direct, in-app transactions.
Studio Booking Setup
Prerequisites
- Python 3.10+
- SQLite or compatible PostgreSQL database
- Telegram Bot API token
- TelegaPay credentials (API Key and Shop ID)
1. Install Dependencies
Install the required Python packages using your CLI:
pip install python-telegram-bot databases aiosqlite cryptography
2. Configure Environment Variables
Define the following environment configurations:
export TELEGRAM_BOT_TOKEN="your_telegram_bot_token"
export TELEGAPAY_SECRET_KEY="your_telegapay_secret"
export TELEGAPAY_SHOP_ID="your_shop_id"
export DATABASE_URL="sqlite:///studio_booking.db"
3. Initialize Database Schema
Run migrations or execute the SQL schema to create your slots, bookings, and services tables prior to starting the Telegram bot coordinator.
Studio Booking Data Schema & Taxonomy
This Openclaw Skills blueprint relies on a standardized relational schema for scheduling and payment logging. Below is the structured schema taxonomy:
Database Schema
| Table | Columns | Details | Description |
|---|---|---|---|
slots |
id (PK), date, start_time, end_time, price, is_available |
ISO 8601 (YYYY-MM-DD), 24-hour time (HH:MM), price in minor units. |
Logs hourly calendar windows and scheduling availability. |
bookings |
id (PK), user_id, slot_id, service_id, amount, status, invoice_id, cancelled_at |
Status types: pending, confirmed, paid, cancelled. |
Tracks reservation statuses, client IDs, invoices, and transaction records. |
services |
id (PK), name, base_price |
Name (text), Price (integer). | Catalogs studio service types (e.g., Voice Recording, Mixing). |
Pricing Engine & Rules (Units in Cents/Kopecks)
- Base Hourly Price:
250000(e.g., 2500.00 RUB) - Minimum Reservation Duration: 2 Hours
- Pricing Modifier Matrix:
- Session >= 3 Hours: 5% discount
- Session >= 5 Hours: 10% discount
- Night Schedule: 20% discount
- Weekend Rate: 15% surcharge
- Loyal Client Index (5+ bookings): 10% discount
Studio Booking Advanced Features
- SAGA Transaction Implementation: Guarantees consistency across SQL databases, TelegaPay holds, and bot notifications. If any stage in the 5-step transaction lifecycle fails, compensating rollbacks run immediately in reverse order.
- Dynamic Pricing Modifier Matrix: Computes invoice amounts programmatically on the fly, calculating night rates, weekend surcharges, and volume discounts.
- Automated Retention Notifications: Schedules and sends Telegram reminders 2 hours before the session, feedback prompts 1 hour after, and re-engagement campaigns 1 day post-session.
- Intelligent Error Resilience: Features an exponential backoff retry mechanism (1s, 3s, 9s) for payment timeouts, checks for past date inputs, and restricts bookings within a 2-hour minimum notice window.
- Occupancy Tracking Analytics: Generates real-time monthly occupancy reports, giving administrators deep insights into peak booking days and hours directly from the Telegram interface.
SKILL.md
Loading
Related Openclaw Skills
drivethru-stripe
Look up products in your Stripe catalog and generate hosted Checkout Sessions for one-time payments or subscriptions.
Instagram Reel Comment Strategist
An AI-powered command-line tool that analyzes Instagram Reels and posts to generate eight distinct categories of highly engaging, visibility-boosting comments.
baoyu-electron-extract
An advanced extraction tool for reverse-engineering Electron applications by unpacking .asar bundles, formatting minified code, and reconstructing original source trees from source maps.
Surplus Funds Recovery
An automated business-in-a-box solution that scans county records, skip-traces previous owners, sends outreach SMS, and generates surplus funds claim documents.
ElevenLabs Voice Pipeline
An advanced voice production pipeline for ElevenLabs, featuring batch generation, instant voice cloning, multilingual TTS, and Telegram voice message integration.
blogwatcher
A command-line tool designed to monitor and track updates from blogs and RSS/Atom feeds seamlessly.
Featured*
