Appointment Booking System

A complete appointment booking and management system for service businesses. Handles booking intake, confirmation emails, automated reminders, no-show detection, and daily schedule reports.

Problem

Service businesses (salons, clinics, consultants, studios) lose revenue from missed appointments, no-shows, and scheduling chaos. Booking platforms charge $30-100+/month and often lack customization. Manual reminders are unreliable.

This system provides self-hosted booking management with zero monthly fees.

What It Does

1. Booking Intake — Webhook API receives bookings, validates fields, generates booking ID, stores in Sheets
2. Confirmation — Sends confirmation email to client and notification to staff immediately
3. Smart Reminders — Sends 24-hour and 2-hour reminders automatically
4. No-Show Followup — Detects missed appointments and sends rescheduling email
5. Daily Schedule — Morning email with today's and tomorrow's appointments plus weekly stats

Included Workflows