{"product_id":"n8n-appointment-reminder-workflow-google-sheets-whatsapp-email","title":"n8n Appointment Reminder Workflow: Google Sheets + WhatsApp\/Email","description":"\u003ch3\u003eSend appointment reminders automatically—WhatsApp or email—just in time\u003c\/h3\u003e\n\u003cp\u003eThis n8n Appointment Reminder Workflow checks upcoming appointments every 6 hours, generates the right reminder message (based on how soon the appointment starts), and routes same-day reminders into a separate priority dispatch lane for WhatsApp or email. Perfect for n8n users who want reliable, scheduled appointment nudges.\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 every 6 hours\u003c\/strong\u003e using a \u003cem\u003eSchedule Trigger\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads appointment records\u003c\/strong\u003e from the built-in \u003cstrong\u003edemo data\u003c\/strong\u003e (or from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e when enabled).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters appointments starting within the next 48 hours\u003c\/strong\u003e and prepares reminder content for each record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses shorter templates for urgent reminders\u003c\/strong\u003e—appointments within \u003cstrong\u003e3 hours\u003c\/strong\u003e receive a different, more immediate message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets the correct channel per record\u003c\/strong\u003e using each item’s \u003ccode\u003echannel_preference\u003c\/code\u003e:\n    \u003cul\u003e\n      \u003cli\u003eWhatsApp reminders go to the \u003ccode\u003ephone\u003c\/code\u003e field\u003c\/li\u003e\n      \u003cli\u003eEmail reminders go to the \u003ccode\u003eemail\u003c\/code\u003e field\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits same-day vs upcoming reminders\u003c\/strong\u003e so you can handle urgent messages separately.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLabels each reminder with a dispatch queue and timestamp\u003c\/strong\u003e so you can connect your WhatsApp and email sending steps cleanly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDemo and test an appointment reminder flow in n8n using the built-in sample data.\u003c\/li\u003e\n  \u003cli\u003eDrive reminders from a SaaS admin Google Sheets export (appointments, customer details, and timing).\u003c\/li\u003e\n  \u003cli\u003eEnsure same-day appointment alerts receive special priority before sending via WhatsApp\/Email integrations.\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 every 6 hours)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e node (optional; requires credentials, spreadsheet ID, sheet name)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eif\u003c\/strong\u003e node (channel and time-window logic)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ecode\u003c\/strong\u003e node (message preparation and routing metadata)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003esticky note\u003c\/strong\u003e (workflow documentation)\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eGoogle Sheets columns expected:\u003c\/strong\u003e \u003ccode\u003eappointment_id\u003c\/code\u003e, \u003ccode\u003ecustomer_name\u003c\/code\u003e, \u003ccode\u003ephone\u003c\/code\u003e, \u003ccode\u003eemail\u003c\/code\u003e, \u003ccode\u003estarts_at\u003c\/code\u003e (ISO), \u003ccode\u003epractitioner\u003c\/code\u003e, \u003ccode\u003etreatment\u003c\/code\u003e, \u003ccode\u003echannel_preference\u003c\/code\u003e. Adjust reminder windows and message text in the message-building step to match your process.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086635159731,"sku":"N8N-19924","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ylPkFVGegXKvWIdF7j42X_c43XwiYR.png?v=1790326909","url":"https:\/\/buyflowscripts.com\/products\/n8n-appointment-reminder-workflow-google-sheets-whatsapp-email","provider":"N8N Commerce","version":"1.0","type":"link"}