Daily check of blood bank inventory against thresholds, sending instant WhatsApp alerts for any type falling below minimum stock levels.
Verified 2026-07-07
Ops-IT
What it does
You get instant WhatsApp alerts whenever your blood bank inventory drops below safe levels. The system checks your Google Sheets daily and notifies you immediately via WhatsApp when a specific blood type needs restocking.
How it works
When it runs
On a schedule · Scheduled · daily
How hands-off
Assists you, you do the final step
Setup
An afternoon · about an afternoon
Works with
Google Sheets, WhatsApp Business Cloud, Code
Tools that fit
Services
Google Sheets : Store and read blood stock data
WhatsApp Business Cloud : Send low stock alerts
LLM
Code : Check stock thresholds and logic
Watch out for
⚠ WhatsApp Business Cloud requires a valid phone number ID which must be configured in your Meta developer account before sending messages so the API accepts the request.
⚠ Google Sheets API quotas can be exceeded if the sheet is accessed too frequently, add caching logic or reduce trigger frequency to stay within limits.
⚠ Hardcoded thresholds in the code make updates difficult, store minimum stock values in a separate configuration object or environment variables for easy maintenance.
⚠ WhatsApp message templates require pre-approval from Meta if they contain promotional content, use transactional text formats to avoid approval delays.
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.