This workflow is designed to automatically monitor blood stock levels from a Google Sheet and send WhatsApp alerts when blood groups reach low stock thresholds. It starts with a daily trigger at 8 AM, then fetches current stock data from Google Sheets, processes the data to identify low stock levels, and finally sends WhatsApp notifications to alert the blood bank team. This automation ensures timely replenishment of blood supplies, helping save lives by preventing stockouts.
Step-by-step, the workflow begins with a cron trigger that initiates daily checks. It then retrieves all blood stock data from Google Sheets, which contains information on blood types, quantities, thresholds, and last updated times. The data is split into batches for processing, where each batch is analyzed to determine if the stock is below the threshold. If low stocks are detected, a WhatsApp message is sent to designated contacts with details of the depleted blood groups. This process is ideal for hospitals, blood banks, or health organizations aiming for proactive inventory management.
Reviews
There are no reviews yet.