{"product_id":"n8n-whatsapp-appointment-reminder-workflow-google-calendar-gmail","title":"n8n WhatsApp Appointment Reminder Workflow (Google Calendar + Gmail)","description":"\u003ch3\u003eSend WhatsApp appointment reminders automatically—24 hours and 2 hours before—and manage patient replies in your calendar\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e every 15 minutes and sends \u003cstrong\u003eWhatsApp appointment reminders\u003c\/strong\u003e to patients 24 hours and 2 hours before their events. It also logs each reminder to prevent duplicates and routes patient responses to either calendar confirmation or your front desk via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every 15 minutes:\u003c\/strong\u003e pulls upcoming Google Calendar events for the next \u003cstrong\u003e25 hours\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAvoids duplicate reminders:\u003c\/strong\u003e reads previously sent reminders from an n8n \u003cstrong\u003eData Table\u003c\/strong\u003e named \u003ccode\u003eappointment_reminders\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends reminders at the right time:\u003c\/strong\u003e selects only events due for a \u003cstrong\u003e24-hour\u003c\/strong\u003e or \u003cstrong\u003e2-hour\u003c\/strong\u003e reminder.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts patient phone numbers:\u003c\/strong\u003e reads the patient phone number from the event description.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a WhatsApp template message:\u003c\/strong\u003e includes quick-reply buttons for \u003cstrong\u003eConfirm\u003c\/strong\u003e and \u003cstrong\u003eReschedule\u003c\/strong\u003e, then records the send in the Data Table (columns include \u003ccode\u003eeventId\u003c\/code\u003e, \u003ccode\u003etype\u003c\/code\u003e, \u003ccode\u003ephone\u003c\/code\u003e, \u003ccode\u003esentAt\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHandles inbound WhatsApp replies:\u003c\/strong\u003e when a message arrives, it parses the button payload or text to detect intent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfirms appointments:\u003c\/strong\u003e if the patient confirms, the workflow updates the Google Calendar event color and sends a WhatsApp confirmation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReschedules \/ routes other requests:\u003c\/strong\u003e if the patient requests rescheduling (or sends any other message), it emails the front desk via \u003cstrong\u003eGmail\u003c\/strong\u003e and includes the calendar link for reschedules; it sends a WhatsApp acknowledgement for reschedule requests.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDental\/clinic scheduling: reduce no-shows with WhatsApp reminders timed to patient appointments.\u003c\/li\u003e\n  \u003cli\u003eFront-desk triage: automatically notify staff in Gmail when patients choose reschedule.\u003c\/li\u003e\n  \u003cli\u003eOperational reliability: guarantee “only one reminder per event” using the n8n Data Table log.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Calendar, WhatsApp Cloud API (Meta), Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n building blocks:\u003c\/strong\u003e schedule, \u003cstrong\u003edata table\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, WhatsApp trigger\/handling, and a \u003cstrong\u003esticky note\u003c\/strong\u003e for guidance\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192847192243,"sku":"N8N-20668","price":64.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/NaJ5gNebI82u6l5yugs9o_5453D6Oo.png?v=1791537127","url":"https:\/\/buyflowscripts.com\/products\/n8n-whatsapp-appointment-reminder-workflow-google-calendar-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}