{"product_id":"n8n-whatsapp-appointment-rescue-workflow-2-hour-check-ins","title":"n8n WhatsApp Appointment Rescue Workflow (2-Hour Check-ins)","description":"\u003ch3\u003eRescue at-risk WhatsApp appointment reminders with 2-hour check-ins\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n WhatsApp Appointment Rescue Workflow\u003c\/strong\u003e runs every hour to automatically contact unconfirmed patients with a WhatsApp check-in 90–150 minutes before their appointment—then routes responses to your team based on what they reply.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule (hourly):\u003c\/strong\u003e loads appointment rows from a demo source (replace with your real data source in production).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates every row:\u003c\/strong\u003e if an \u003cem\u003eappointment_id\u003c\/em\u003e or phone is missing—or if \u003cem\u003estarts_at\u003c\/em\u003e can’t be parsed—the row is sent to an error log with the exact reason.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects only the right appointments:\u003c\/strong\u003e picks \u003cstrong\u003eunconfirmed\u003c\/strong\u003e appointments starting \u003cstrong\u003e90–150 minutes from now\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate check-ins:\u003c\/strong\u003e a static-data guard ensures \u003cstrong\u003eexactly one\u003c\/strong\u003e WhatsApp check-in per appointment even if the workflow fires twice.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a WhatsApp YES\/NO prompt:\u003c\/strong\u003e sends each customer one check-in asking them to reply \u003cstrong\u003eYES\u003c\/strong\u003e or \u003cstrong\u003eNO\u003c\/strong\u003e (placeholder send step in the template).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWaits for an inbound reply:\u003c\/strong\u003e pauses up to \u003cstrong\u003e15 minutes\u003c\/strong\u003e and resumes via a \u003cstrong\u003ewebhook\u003c\/strong\u003e when a reply arrives.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eClassifies responses and routes outcomes:\u003c\/strong\u003e confirmed replies mark the calendar; \u003cstrong\u003ecancel_requested\u003c\/strong\u003e, \u003cstrong\u003eunclear\u003c\/strong\u003e, and \u003cstrong\u003eno_reply\u003c\/strong\u003e are flagged for staff.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReduce missed appointments by confirming attendance via \u003cstrong\u003eWhatsApp\u003c\/strong\u003e before the scheduled time.\u003c\/li\u003e\n  \u003cli\u003eAutomate staff follow-up when patients don’t respond or reply ambiguously.\u003c\/li\u003e\n  \u003cli\u003eSafeguard data quality by logging invalid appointment rows with clear error reasons.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e (runs hourly), \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData requirements:\u003c\/strong\u003e appointment_id, customer_name, phone, starts_at (ISO), practitioner, treatment, status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWhatsApp Business Cloud:\u003c\/strong\u003e add credentials and replace the placeholder send step with a WhatsApp \u003cstrong\u003eSend Message\u003c\/strong\u003e action to the appointment phone number.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192873210035,"sku":"N8N-20456","price":66.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/b0wLhv18_n0OmlFswtDAc_mB5Q5uPQ.png?v=1791537884","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-appointment-rescue-workflow-2-hour-check-ins","provider":"N8N Commerce","version":"1.0","type":"link"}