Pharmacy Stock & Expiry Monitor
Tracks medicine stock and expiry dates, sends alerts for low, expiring and expired items, updates stock on every sale and suggests reorder quantities.

On this page
How it works
- A daily check reads the full inventory.
- Expiry status and stock levels are calculated.
- Alerts are sent for expired, expiring and low-stock medicines.
- Sales recorded through a form reduce stock in real time.
- Reorder quantities are calculated and inventory status is updated.
Use cases
- Pharmacies and chemists
- Hospital stores
- Clinic dispensaries
What you need
This workflow connects to these apps.
- Google Sheets
- n8n
- HTTP
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- Google Sheets account
- Twilio account
Data setup
Create these tables with these exact column names before the first run.
| Table | Columns |
|---|---|
| Pharmacy Inventory Sheet → Sheet1Google Sheets | batch_nostatusexpiring_soonreorder_qtylast_updatequantitymedicine_namemin_stockpurchase_dateexpiry_datepurchase_priceselling_pricemedicine_typesupplier_namelocationnotes |
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| Daily Inventory Check Trigger | scheduleTrigger |
| Fetch Inventory Data | googleSheets |
| Calculate Expiry Status | code |
| Check Low Stock | if |
| Check Expiring Soon | if |
| Check Expired Medicines | if |
| Send Expired Medicine Alert | twilio |
| Send Expiry Medicine Alert | twilio |
| Send Low Stock Medicine Alert | twilio |
| Calculate Reorder Quantity | code |
| Update Inventory Status | googleSheets |
| Medicine Sale Form Trigger | formTrigger |
| Prepare Sale Data | set |
| Fetch Medicine Record | googleSheets |
| Calculate Updated Stock | code |
| Update Stock in Inventory | googleSheets |
| Check Low Stock After Sale | if |
| Send Low Stock Alert | twilio |
| No Operation, do nothing | noOp |
| Daily Reorder Check Trigger | scheduleTrigger |
| Fetch Inventory Data1 | googleSheets |
| Prepare Inventory Data | code |
| Check Reorder Requirement | if |
| Calculate Reorder Quantity1 | code |
| Update Reorder Data | googleSheets |
| Medicine Entry Form Trigger | formTrigger |
| Save Medicine to Inventory | googleSheets |
Frequently asked questions
Tracks medicine stock and expiry dates, sends alerts for low, expiring and expired items, updates stock on every sale and suggests reorder quantities. It's a 32-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for Google Sheets and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.
It works with 1 table in Google Sheets. Create it with the column names listed under Data setup on this page before the first run.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



