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 (e.g., A+, O-).
-
Quantity: Current stock amount.
-
Threshold: Minimum acceptable stock level.
-
Last Updated: Date and time of last update.
-
Status: Current status (e.g., 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: Include email or SMS alerts.
-
Update Frequency: Modify daily trigger time.
