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

1. Daily Check Blood Stock: Triggers the workflow daily.
2. Fetch Blood Stock: Reads data from a Google Sheet.
3. Get All Stock: Collects all available blood stock details.
4. Check Stock Availability: Analyzes stock levels for low thresholds.
5. 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.