Send Patient Condition Updates with Google Sheets, Email & WhatsApp Alerts

Description

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 | [email protected] | +1234567890 | Normal | Active | 2024-01-15
P002 | Jane Smith | 32 | Fever | 101.8 | 130/85 | 88 | Tylenol | [email protected] | +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.