🔧 Send patient condition updates with Google Sheets, Email & WhatsApp alerts

⚡ 641 views · 🔧 Miscellaneous

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 | 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.

🔗 Nodes Used

Cron, Send Email, Google Sheets, HTTP Request, Filter

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup