Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets

This n8n workflow monitors pharmacy inventory stored in a Google Sheet, checks daily for low stock or near-expiry medicines, and sends alerts to the pharmacist via email, ensuring timely restocking and waste prevention.

Why Use It

This workflow automates inventory management for pharmacies, reducing the risk of stockouts or expired medicines, saving time, minimizing losses, and ensuring compliance with safety standards by providing proactive alerts.

How to Import It

1. Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. 2. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. 3. Configure Credentials: Set up Google Sheets, email (e.g., SMTP), and optional SMS (e.g., Twilio) credentials in n8n. 4. Run the Workflow: Activate the scheduled trigger and test with a sample Google Sheet.

System Architecture

- Daily Stock Check (9 AM): Automated trigger to monitor inventory levels - Fetch Stock Data: Retrieves current medicine data from Google Sheets - Wait For All Data: Ensures complete data retrieval before processing - Check Expiry Date and Low Stock: Analyzes inventory for alerts - Update Google Sheet: Records alert status and timestamps - Send Email Alert: Notifies pharmacist of low stock and expiry issues

Google Sheet File Structure