Monitor Blood Bank Stock & Send Low Level Alerts with Google Sheets and WhatsApp

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.