Recover no-show appointment fees with an automated WhatsApp or SMS ladder
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 19 nodes and runs on a schedule (every 12 hours) (plus 1 other trigger). It uses only n8n's built-in nodes.
How it runs
Trigger: On a schedule (every 12 hours) (plus 1 other trigger).
- No-shows (demo data) (Code): runs custom JavaScript code
- Valid reply? (If): checks a condition and branches into true / false
- Prepare + validate rows (Code): runs custom JavaScript code
- Classify reply (Code): runs custom JavaScript code
- Respond reply invalid (Respond to Webhook): sends the response back to the webhook caller
- Row valid? (If): checks a condition and branches into true / false
- Payment confirmed? (If): checks a condition and branches into true / false
- In 20-30h window? (If): checks a condition and branches into true / false
- Log invalid rows (Code): runs custom JavaScript code
- Mark recovered (Code): runs custom JavaScript code
…plus 7 more steps. See the full node list below.
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick Overview This workflow runs every Monday at 08:00 to validate last week’s appointment rows, calculate key KPIs (show-up rate, no-show rate, cancellations, revenue, and top booking source), generate a week-over-week digest message, and hand it off to a…