Send multi-channel medication reminders to patients
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Cron Check Every 10 Minutes | Schedule Trigger |
Nodes used (7)
- Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Cron
n8n-nodes-base.cron - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Send Email
n8n-nodes-base.emailSend
What it does
This workflow automatically sends timely medication reminders to patients after a prescription is marked as sent in the system. It reads the medication schedule from prescription data, schedules reminders for each dosage time, and delivers notifications via WhatsApp, SMS, or email. All reminders are tracked and logged, ensuring patients stay on track with their treatment while providing healthcare providers with acknowledgment records. 📋 Simple Google Sheets Structure "Prescriptions" Sheet - Required columns: - prescriptionid - patientname - patientphone - patientemail - medication - dosage - timesperday (1, 2, 3, or 4) - durationdays (7, 14, 30, etc.) - startdate (YYYY-MM-DD) - prescriptionstatus (set to "sent") - reminderscreated (auto-updated to "yes") "Reminders" Sheet (auto-created): Simple tracking of all scheduled reminders 🔧 Workflow Components (Only 10 Nodes!) Part 1: Schedule Creation 1. Watch Sheet → Monitors for "sent" prescriptions 2. Filter New → Only processes unscheduled prescriptions 3. Create Schedule → Generates reminder times automatically 4. Save Reminders → Stores schedule in sheet 5. Mark Processed → Prevents duplicate scheduling Part 2: Send Reminders 6. Cron Timer → Checks every 10 minutes 7. Get Reminders → Retrieves all scheduled reminders 8. Find Due → Identifies reminders due now 9. Send Messages → WhatsApp + Email simultaneously 10. Mark Sent → Updates status to prevent duplicates ⚙️ Simple Setup 1. Replace these values: - YOURGOOGLESHEETID - YOURWHATSAPPPHONENUMBERID - Email sender address 2. Add credentials: - Google Sheets API - WhatsApp API - SMTP for email 3. Sample data: prescriptionid: RX001 patientname: John Doe patientphone: +1234567890 patientemail: [email protected] medication: Amoxicillin 500mg dosage: 1 tablet timesperday: 3 durationdays: 7 startdate: 2025-01-15 prescriptionstatus: sent reminderscreated: no 📱 Default Schedule - 1x daily: 9:00 AM - 2x daily: 9:00 AM, 9:00 PM - 3x daily: 8:00 AM, 2:00 PM, 8:00 PM - 4x daily: 8:00 AM, 12:00 PM, 4:00 PM, 8:00 PM