Healthcare

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.

The Pharmacy Stock & Expiry Monitor workflow on the n8n canvas, with its 32 nodes and connections
The workflow on the n8n canvas. Click to open it full size.

At a glance

Category
Healthcare
Nodes
32
Apps
Google Sheets, HTTP
Price
Free
Download JSON
On this page

How it works

  1. A daily check reads the full inventory.
  2. Expiry status and stock levels are calculated.
  3. Alerts are sent for expired, expiring and low-stock medicines.
  4. Sales recorded through a form reduce stock in real time.
  5. 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.

TableColumns
Pharmacy Inventory Sheet → Sheet1Google Sheetsbatch_nostatusexpiring_soonreorder_qtylast_updatequantitymedicine_namemin_stockpurchase_dateexpiry_datepurchase_priceselling_pricemedicine_typesupplier_namelocationnotes

Setup

  1. 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.
  2. Connect the credentials listed above.
  3. Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
  4. Replace placeholder emails, phone numbers, and form links with your own.
  5. 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

NodeType
Daily Inventory Check TriggerscheduleTrigger
Fetch Inventory DatagoogleSheets
Calculate Expiry Statuscode
Check Low Stockif
Check Expiring Soonif
Check Expired Medicinesif
Send Expired Medicine Alerttwilio
Send Expiry Medicine Alerttwilio
Send Low Stock Medicine Alerttwilio
Calculate Reorder Quantitycode
Update Inventory StatusgoogleSheets
Medicine Sale Form TriggerformTrigger
Prepare Sale Dataset
Fetch Medicine RecordgoogleSheets
Calculate Updated Stockcode
Update Stock in InventorygoogleSheets
Check Low Stock After Saleif
Send Low Stock Alerttwilio
No Operation, do nothingnoOp
Daily Reorder Check TriggerscheduleTrigger
Fetch Inventory Data1googleSheets
Prepare Inventory Datacode
Check Reorder Requirementif
Calculate Reorder Quantity1code
Update Reorder DatagoogleSheets
Medicine Entry Form TriggerformTrigger
Save Medicine to InventorygoogleSheets

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.

Keep exploring
  • n8n canvas of the Daily Wellness Tip on Telegram workflow

    Healthcare4 nodes

    Daily Wellness Tip on Telegram

    Picks a random wellness tip from Airtable every day and posts it to your Telegram group, which keeps the community engaged.

  • n8n canvas of the Patient Appointment Booking WhatsApp Agent workflow

    Healthcare12 nodes

    Patient Appointment Booking WhatsApp Agent

    Patients book, check and reschedule appointments over WhatsApp. The AI agent checks Google Calendar availability, creates the event and records the booking in Google Sheets.

  • n8n canvas of the Patient Appointment Reminder Emails workflow

    Healthcare3 nodes

    Patient Appointment Reminder Emails

    Every day, today's appointments are read from Google Sheets and each patient gets a reminder email, which helps reduce no-shows.