Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets
n8n6 modulesv1.0This 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 W
At a glance
Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, Twilio. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, Twilio
- Modules
- 6
- Price
- Free
- Version
- v1.0
About this workflow
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 - Sheet Name: PharmacyInventory - Range: A1:E20 (or adjust based on needs) | A | B | C | D | E | |------------|---------------|------------|---------------|---------------| | medicinename | stockquantity | expirydate | alertstatus | lastchecked | | Paracetamol | 15 | 2025-09-15 | Notified | 2025-08-08 | | Aspirin | 5 | 2025-08-20 | Pending | 2025-08-07 | | Ibuprofen | 20 | 2026-01-10 | - | 2025-08-08 | - Columns: - medicinename: Name of the medicine. - stockquantity: Current stock level (e.g., number of units). - expirydate: Expiry date of the medicine (e.g., YYYY-MM-DD). - alertstatus: Status of the alert (e.g., Pending, Notified, - for no alert). - lastchecked: Date of the last inventory check. Customization Ideas - Adjust Thresholds: Change the low stock threshold (e.g., from 10 to 5) or expiry window (e.g., from 30 to 15 days). - Add SMS Alerts: Integrate Twilio or another SMS service for additional notifications. - Incorporate Barcode Scanning: Add a node to import inventory updates via barcode scanners. - Dashboard Integration: Connect to a dashboard (e.g., Google Data Studio) for real-time inventory tracking. - Automated Restock Orders: Add logic to generate purchase orders for low stock items. Requirements to Run This Workflow - Google Sheets Account: For storing and managing inventory data. - Email Service: Gmail, SMTP, or similar for email alerts. - n8n Instance: With Google Sheets and email connectors configured. - Cron Service: For scheduling the daily trigger. - Internet Connection: To access Google Sheets and email APIs. - Optional SMS Service: Twilio or similar for SMS alerts (requires additional credentials). Want a tailored workflow for your business? Our experts can craft it quickly Contact our team
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Send Go4Clients personalized SMS to new Google Sheet Spreadsheet rows
Track portfolio performance and risk using Google Sheets and Alpha Vantage
Capture a Website by CloudConvert and upload the output files to Google Drive
Automated PR code reviews with GitHub, GPT-4, and Google Sheets best practices
Newsletter summarization & briefing with Gmail, AI, Google Sheets & Email
Generate videos with AI, ElevenLabs,PIAPI Shotstack/Creatomate & post to Youtube
Extract structured data from medical documents with Google Gemini AI
AI Shopify product descriptions: GPT-4o Vision + Claude + Analytics
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you