n8n WhatsApp Booking Workflow: OpenAI + Airtable Scheduler

Automate WhatsApp bookings with OpenAI + Airtable Scheduler in n8n

Turn incoming WhatsApp messages into a full booking experience: this n8n WhatsApp Booking Workflow uses OpenAI and Airtable to check availability, create and confirm bookings, handle cancellations, answer FAQs from business info, and escalate to human support when needed.

What this workflow does

• Receives WhatsApp webhook events and returns the verification challenge for subscription requests, or acknowledges message events with EVENT_RECEIVED.
• Ignores irrelevant events that don’t include an incoming message.
• Checks “human mode” by looking up the sender’s phone number in an Airtable Conversations table—if the chat is set to human mode, the workflow stops without sending an automated reply.
• Handles voice notes: fetches the media URL from WhatsApp, downloads the audio via HTTP, and uses OpenAI to transcribe it to text.
• Handles text messages: extracts the message body and phone number directly from the webhook payload.
• Runs an OpenAI-powered agent that can query Airtable for availability and business information, create pending bookings, confirm bookings, cancel bookings, or escalate to human support.
• Sends the agent reply back to the customer through WhatsApp (unless the response is marked as “no response needed”).

Use cases

• Customers text or leave a voice note to book an appointment—availability is checked and booking is confirmed automatically.
• Responding to booking questions like hours, services, or FAQ items stored in your business info within Airtable.
• Switching to human support for complex cases by toggling “human mode” in Airtable Conversations.
• Processing cancellations requested via WhatsApp text or voice.

Technical details

• WhatsApp Business Cloud API webhook trigger + WhatsApp send (configure Phone Number ID).
• Nodes/integrations: webhook, if, set, airtable, whats app, plus sticky note for workflow documentation.
• Uses HTTP to download voice media, then OpenAI for transcription and booking logic via an agent.

Setup tip: Create and connect your WhatsApp Business Cloud API account in n8n, and set the Phone Number ID in the WhatsApp send node.