This automated n8n workflow reads patient data from Google Sheets daily at 8 AM, sends email and WhatsApp reports to doctors, alerts staff for critical patients, and logs activities back to sheets.
Good to Know
- Runs daily at 8 AM via cron trigger.
- Filters active patients only.
- Requires Google service account, Gmail app password, and WhatsApp API token.
- Logs all sent reports in a dedicated sheet.
How It Works
-
Cron Trigger - Schedules daily run at 8 AM.
-
Google Sheets (Read) - Fetches patient data from "Patients" sheet.
-
Filter Node - Selects active patients.
-
Code Node - Processes data, creates report content, checks for critical conditions.
-
Email Send Node - Sends reports to doctors via Gmail.
-
HTTP Request Node - Sends WhatsApp messages.
-
Filter Critical - Identifies critical patients.
-
Critical Alert Email - Notifies hospital staff.
-
Google Sheets (Write) - Logs reports to "Reports_Log" sheet.
Google Sheet Structure
Sheet 1:
A: Patient ID | B: Patient Name | C: Age | D: Current Condition
E: Temperature | F: Blood Pressure | G: Heart Rate | H: Current Medication
I: Doctor Email | J: Doctor WhatsApp | K: Priority | L: Status | M: Last Updated
Sample Data:
P001 | John Doe | 45 | Stable | 98.6 | 120/80 | 72 | Aspirin | dr@hospital.com | +1234567890 | Normal | Active | 2024-01-15
P002 | Jane Smith | 32 | Fever | 101.8 | 130/85 | 88 | Tylenol | dr2@hospital.com | +1987654321 | Critical | Active | 2024-01-15
Sheet 2:
A: Report Date | B: Patient ID | C: Patient Name | D: Status | E: Sent
How to Use
- Import workflow JSON into n8n.
- Configure nodes with Google credentials, sheet ID, Gmail app password, WhatsApp token.
- Add patients to Google Sheet with "Active" status.
- Test manually, then activate for daily runs.
Requirements
- Google Sheet with specified structure.
- Google Cloud service account JSON.
- Gmail with 2FA and app password.
- WhatsApp Business API token.
- n8n instance.
Customizing This Workflow
- Adjust cron expression for different schedule.
- Modify Code Node for custom report formats or critical thresholds.
- Update email/WhatsApp nodes for additional recipients or templates.
- Extend filters for more patient statuses.
