I built an n8n workflow that rebooks no‑shows automatically — here's how it works

Описание и применение

Новый workflow n8n автоматически обнаруживает пропущенные встречи, отправляет персонализированные SMS с предложением перенести, обрабатывает ответы и отправляет только один напоминание, повышая коэффициент повторного бронирования.

Задача

Missed appointments cost US healthcare ~$150B a year, and most no‑shows never rebook on their own.

Результат

The workflow continuously monitors appointments, automatically reaches out to no‑show customers with slot options, processes their replies, and limits nudges to one per customer, improving the likelihood of rebooking and reducing revenue loss.

Рабочий процесс

• 1. Every 30 minutes, read today’s Appointments sheet and flag appointments that passed 15+ minutes without check‑in.
• 2. For each flagged no‑show, pull up to 3 open slots from OpenSlots sheet and generate a personalized SMS via an AI model (default gpt‑4o‑mini).
• 3. Send the SMS through Twilio and log the attempt to RescueLog sheet.
• 4. Receive replies via Twilio webhook; parse YES (+ slot number) to book automatically, NO to log as lost, unclear replies to human review.
• 5. If no reply after 2 hours, send one gentle nudge; once nudged, never nudge again for that phone number.

Доказательства

Every empty chair in an appointment book is money walking out the door. Missed appointments cost US healthcare an estimated ~$150B a year

Источник

The workflow reads today's Appointments sheet and flags anyone whose time passed 15+ minutes ago without a check‑in

Источник

For each no‑show, it pulls up to 3 open slots from an OpenSlots sheet, and an AI agent drafts a personal text: "Hi Sarah, we missed you at 2pm — want Thu 10am or Fri 3pm instead?" Sent via Twilio, logged to a RescueLog sheet

Источник

A Twilio webhook parses replies: YES (+ slot number) books the slot automatically, NO is logged as lost, anything unclear goes to human review. No reply after 2 hours gets exactly one nudge — then silence

Источник

Reply parsing is defensive. "NO 2" is a no, not a yes-with-slot-2. Bare "2" counts as yes-with-slot-2. "STOP" is treated as lost (no more messages — correct behavior for an opt‑out).

Источник