Send patient condition updates with Google Sheets, Email & WhatsApp alerts
Needs changesWhat this workflow does
This workflow has 9 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets. It also calls api.whatsapp.com over HTTP.
How it runs
Trigger: On a schedule (legacy Cron node).
- Read Patient Data (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Process Patient Data (Code): runs custom JavaScript code
- Send Email: sends an email over SMTP
- Send WhatsApp Message (HTTP Request): calls api.whatsapp.com
- Filter: keeps only the items that match a condition
- Log Report to Sheet (Google Sheets): uses Google Sheets
- Send Critical Alert (Send Email): sends an email over SMTP
Services it uses
HTTP calls to: api.whatsapp.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily Trigger (8 AM): replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily Trigger (8 AM) | Schedule Trigger |
Nodes used (6)
- Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Send Email
n8n-nodes-base.emailSend - HTTP Request
n8n-nodes-base.httpRequest
From the author
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…