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 Alerts : Sends notifications when stock is low.
-
Real-Time Updates : Uses live data from Google Sheets.
-
Efficient Delivery : Alerts sent instantly via WhatsApp.
-
Continuous Check : Loops to ensure ongoing monitoring.
Workflow Process
-
Daily Check Blood Stock : Triggers the workflow daily.
-
Fetch Blood Stock : Reads data from a Google Sheet.
-
Get All Stock : Collects all available blood stock details.
-
Check Stock Availability : Analyzes stock levels for low thresholds.
-
Send Alert Message : Sends WhatsApp alerts if stock is low.
Sheet Columns
-
Blood Type : Type of blood (eg, A+, O-).
-
Quantity : Current stock amount.
-
Threshold : Minimum acceptable stock level.
-
Last Updated : Date and time of last update.
-
Status : Current status (eg, Low, Sufficient).
Setup Instructions
-
Import Workflow : Add the workflow to n8n via the import option.
-
Configure Sheet : Set up a Google Sheet with blood stock data.
-
Set Up WhatsApp : Configure WhatsApp API credentials in n8n.
-
Activate : Save and enable the workflow.
-
Test : Simulate low stock to verify alerts.
Requirements
-
n8n Instance : Hosted or cloud-based n8n setup.
-
Google Sheets : Access with stock data.
-
WhatsApp API : Integration for sending alerts.
-
Admin Access : For monitoring and updates.
Customization Options
-
Adjust Threshold : Change low stock limits.
-
Add Channels : Includes email or SMS alerts.
-
Update Frequency : Modify daily trigger time.