n8n Healthcare Appointment Webhook with GPT-5-mini + Google Sheets

Turn patient messages into scheduled appointments—automatically

This n8n Healthcare Appointment Webhook workflow uses GPT-5-mini to understand incoming patient requests, checks Google Sheets for doctor availability, and then returns available slots, books an appointment, or cancels an existing one—directly via an n8n webhook.

What this workflow does

• Receives patient messages via a webhook POST containing the patient’s message (and patient ID) for appointment help.
• Uses OpenAI to extract structured intent—the workflow interprets what the patient wants (availability, booking, or cancellation), including the relevant doctor and requested date/time.
• Consults Google Sheets data for Doctors, Doctor Availability, and existing Appointments.
• Normalizes AI output into structured fields (including selected slot start/end times and any matching appointment ID).
• Routes the request by intent:
  • Availability check: responds with the doctor/date and available time slots.
  • Booking: generates an appointment ID, appends a “Confirmed” record to the Appointments sheet, and returns a confirmation.
  • Cancellation: updates the matching appointment to “Cancelled” and returns a cancellation confirmation.
  • Fallback intent: returns a generic intent message when needed.

Use cases

• A patient texts or submits a request for “Dr. Smith tomorrow morning” and gets a list of available slots.
• A patient selects a time; the workflow books the appointment and records it in Google Sheets.
• Patients request cancellation; the workflow updates the existing appointment status to “Cancelled.”

Technical details

• Tech stack / nodes: code, merge, switch, webhook, sticky note, google sheets
• Integrations: OpenAI (GPT-5-mini) for intent/date/slot extraction; Google Sheets for Doctors, Doctor Availability, and Appointments.
• Setup: add OpenAI API credentials (or update model selection) and configure Google Sheets OAuth2. Ensure the three required spreadsheets exist.