Send multi-channel medication reminders to patients
Workflow preview
$20/month : Unlimited workflows
2500 executions/month
THE #1 IN WEB SCRAPING
Scrape any website without limits
HOSTINGER
Early Deal
DISCOUNT 20% Try free
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Important notice
This workflow is provided as-is. Please review and test before using in production.
Overview
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:
prescription_idpatient_namepatient_phonepatient_emailmedicationdosagetimes_per_day(1, 2, 3, or 4)duration_days(7, 14, 30, etc.)start_date(YYYY-MM-DD)prescription_status(set to "sent")reminders_created(auto-updated to "yes")
"Reminders" Sheet (auto-created): Simple tracking of all scheduled reminders
π§ Workflow Components (Only 10 Nodes!)
Part 1: Schedule Creation
- Watch Sheet β Monitors for "sent" prescriptions
- Filter New β Only processes unscheduled prescriptions
- Create Schedule β Generates reminder times automatically
- Save Reminders β Stores schedule in sheet
- Mark Processed β Prevents duplicate scheduling
Part 2: Send Reminders
- Cron Timer β Checks every 10 minutes
- Get Reminders β Retrieves all scheduled reminders
- Find Due β Identifies reminders due now
- Send Messages β WhatsApp + Email simultaneously
- Mark Sent β Updates status to prevent duplicates
βοΈ Simple Setup
Replace these values:
YOUR_GOOGLE_SHEET_IDYOUR_WHATSAPP_PHONE_NUMBER_ID- Email sender address
Add credentials:
- Google Sheets API
- WhatsApp API
- SMTP for email
Sample data:
prescription_id: RX001
patient_name: John Doe
patient_phone: +1234567890
patient_email: [email protected]
medication: Amoxicillin 500mg
dosage: 1 tablet
times_per_day: 3
duration_days: 7
start_date: 2025-01-15
prescription_status: sent
reminders_created: 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