Pharmacy Inventory Alerts: Low Stock & Expiry with Google Sheets

This n8n workflow monitors pharmacy inventory data stored in a Google Sheet, running daily at 9 AM to fetch medicine details including names, stock quantities, and expiry dates. It analyzes the data to identify items with low stock levels or approaching expiry, then updates the sheet with alert statuses and timestamps before sending detailed email notifications to the pharmacist.

Key benefits include proactive inventory management, reducing stockouts that disrupt patient care, minimizing financial losses from expired medicines, and ensuring regulatory compliance. By automating manual checks, it saves hours of daily labor, allowing staff to focus on core operations like patient service.

Ideal for independent pharmacies, small clinics, or hospital dispensaries using Google Sheets for inventory. Easily customizable for thresholds (e.g., stock <10 or expiry <30 days), supports additional integrations like SMS via Twilio, and scales with growing inventories by adjusting sheet ranges.