n8n Workflow: Recover No-Show Fees via WhatsApp/SMS

Recover No-Show Fees with Automated WhatsApp/SMS Escalations (n8n Workflow)

This n8n workflow automatically finds recent appointment no-shows, validates the records, and generates a ready-to-send WhatsApp/SMS message to recover fees—then logs each case as “awaiting payment” for recovery tracking.

What this workflow does

• Runs on a schedule: A Schedule Trigger executes the workflow every 12 hours.
• Pulls and prepares no-show data: It retrieves no-show records from a demo data source, parses the missed_at timestamp, and validates required fields.
• Handles invalid records: Any record failing validation is routed to an error log output with the specific validation reason.
• Targets the right recovery window: It filters to only those missed 20–30 hours ago and skips items not yet due.
• Builds escalation messaging: It generates a polite recovery message that distinguishes first-time vs repeat no-show, includes the fee amount, and adds a PAYMENTLINK placeholder.
• Sends and tracks: A placeholder WhatsApp/SMS send step produces the send-ready message, and a recovery-tracking step records the case as awaiting payment.

Use cases

• Healthcare, salons, and service businesses that want no-show fee recovery via WhatsApp/SMS.
• SaaS operators running n8n to manage missed appointments and reduce revenue leakage.
• Automation engineers testing a reliable template for scheduled escalation workflows with validation and logging.

Technical details

• Nodes / logic: Schedule Trigger, if, code, sticky note.
• Data requirements: appointment_id, customer_name, phone, missed_at (ISO), treatment, fee_eur, prior_no_shows.
• Setup guidance: Replace the demo no-show source (e.g., Google Sheets) and swap the placeholder send step with your messaging provider (e.g., WhatsApp Business Cloud API or an SMS gateway).
• Configurable behavior: Update message templates (replace PAYMENTLINK) and adjust the 20–30 hour window or repeat threshold.