Pharmacy inventory alerts for low stock & expiring medicine with Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 6 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets.
How it runs
Trigger: On a schedule (legacy Cron node).
- Fetch Stock Data (Google Sheets): uses Google Sheets
- Wait: pauses before continuing
- Check Expiry Date and Low Stock (Code): runs custom JavaScript code
- Update Google Sheet (Google Sheets): update
- Send Email: sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron in Daily Stock Check: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Daily Stock Check | Schedule Trigger |
Nodes used (5)
- Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - Send Email
n8n-nodes-base.emailSend - Wait
n8n-nodes-base.wait - Code
n8n-nodes-base.code
From the author
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…