WhatsApp Appointment Booking Chatbot

Complete n8n workflow for a WhatsApp chatbot that automatically schedules appointments, syncs with Google Calendar, and sends 24-hour reminders.

What's Included

• calendar_whatsapp.json - Complete n8n workflow ready to import
• supabase_schema.sql - SQL schema for the 3 required tables

Features

• Conversational booking via WhatsApp
• Automatic Google Calendar sync
• 24-hour appointment reminders
• Conversation history storage
• User management

Database Schema

The workflow uses 3 Supabase tables:

Quick Setup

1. Import the workflow

   • Open n8n > Workflows > Import from File
   • Select calendar_whatsapp.json

2. Create Supabase tables

   • Run supabase_schema.sql in your Supabase SQL editor

3. Configure credentials

   • OpenAI API key
   • WhatsApp Business API
   • Google Calendar OAuth
   • Supabase API credentials

4. Activate the workflow

   • Enable the WhatsApp trigger
   • Test with a message

How It Works

1. User sends WhatsApp message
2. AI understands intent and checks availability
3. Creates appointment in database
4. Syncs event to Google Calendar
5. Sends confirmation via WhatsApp
6. 24h reminder triggers automatically

Related Resources

• YouTube Tutorial
• n8n Documentation