Monitor blood bank stock & send low level alerts with Google Sheets and WhatsApp
Needs changesWhat this workflow does
This workflow has 5 nodes and runs on a schedule (legacy Cron node). Along the way it connects WhatsApp Business Cloud and Google Sheets.
How it runs
Trigger: On a schedule (legacy Cron node).
- Fetch Blood Stock (Google Sheets): uses Google Sheets
- Get All Stock (Loop Over Items (Split in Batches)): loops over the items in batches
- Check Stock Availability (Code): runs custom JavaScript code
- Send Alert Message (WhatsApp Business Cloud): send
Services it uses
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 Check Blood Stock : 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 Check Blood Stock | Schedule Trigger |
Nodes used (5)
- Code
n8n-nodes-base.code - WhatsApp Business Cloud
n8n-nodes-base.whatsApp - Google Sheets
n8n-nodes-base.googleSheets - Cron
n8n-nodes-base.cron - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
This n8n workflow monitors blood stock levels daily and sends alerts when availability is low. It fetches data from a Google Sheet, checks stock status, and notifies via WhatsApp. Key Features - Daily Monitoring: Checks blood stock every day. - Automated…