This automated n8n workflow reads patient data from Google Sheets daily at 8 AM, sends email and WhatsApp reports to do…
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. An n8n automation workflow template by Oneclick AI Squad.
Oneclick AI Squad
web
free
Others in the same category, ranked by how often they are opened.
