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

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 "ReportsLog" 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