Pharmacy Low Stock & Expiry Alerts with Google Sheets
Automates daily monitoring of pharmacy inventory in Google Sheets for low stock and expiring medicines, sending email alerts to pharmacists for timely action.
This n8n workflow automates pharmacy inventory management by daily checking stock levels and expiry dates in a Google Sheet. It triggers at 9 AM, fetches data on medicine names, quantities, and expiry dates, processes for low stock or near-expiry items, updates the sheet with alert statuses, and sends detailed email notifications to pharmacists.
Benefits include preventing stockouts that disrupt patient care, minimizing waste from expired medicines, saving manual checking time, and ensuring regulatory compliance. Ideal for small to medium pharmacies relying on spreadsheets for inventory, it reduces losses and improves efficiency without complex ERP systems.
Use cases: Independent pharmacies tracking 20-100 medicines; clinics managing supplies; or any business using Google Sheets for inventory. Easy setup requires Google Sheets and SMTP credentials; scalable by adjusting sheet ranges or adding SMS alerts.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Secure checkout powered by Stripe
Support
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related File & Document Management workflows
- Automate Invoice Data Extraction to Airtable with OCR and AI$14.99
- Automate PDF Invoice Creation from Google Sheets Using PDF.co$4.99
- Create Custom PDF Documents from Templates with Gemini & Google Drive$24.99
- Automatically Save and Organize Outlook Email Attachments in OneDrive Folders$9.99
- Automate Invoice Data Extraction from Google Drive to Google Sheets with Mistral OCR$14.99
- Convert Files to Markdown with Datalab.to API in n8n$9.99
More from Nora Brennan
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.