Yes, the workflow itself is free; you only need an n8n instance and Google Sheets plus email accounts.

What do I need to get started?

An n8n account, Google Sheets credentials, and email (SMTP) credentials.

Download the JSON, go to Workflows in n8n, choose Import from File, then configure the credentials.

Pharmacy Inventory Alerts for Low Stock & Expiring Medicine with Google Sheets

Verified

Monitors Google Sheets inventory and emails alerts for low stock or expirations.

n8nData & SyncBeginner👁 15 views

Open template

Updated 2026-06-15

What this workflow does

This automation reads inventory records from Google Sheets, evaluates stock levels and expiry dates, and dispatches email notifications when conditions are met.

It is intended for pharmacies that track stock in spreadsheets and need automated daily checks to prevent shortages or expired products.

Who is this for?

Pharmacists and pharmacy managers at small to medium pharmacies who track inventory in Google Sheets and need automated alerts.

What problem it solves

Manual daily checks of medicine stock and expiry dates are time-consuming and error-prone, leading to stockouts or wasted expired products.

Live workflow preview

Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.

Open the template on n8n to import and run it. View source template →

What it automates

Morning low-stock check

Runs at 9 AM to email the pharmacist when any item falls below a set quantity threshold.

Expiry prevention

Flags medicines expiring within 30 days so the team can prioritize sales or returns before waste occurs.

Weekly restock planning

Provides a single daily email summarizing all items needing attention, helping plan supplier orders efficiently.

How the workflow works

The 3 nodes in this automation, in order.

1Send EmailemailSend
2Google SheetsgoogleSheets
3Codecode

Apps & integrations used

Send EmailGoogle Sheets

How to set up Pharmacy Inventory Alerts for Low Stock & Expiring Medicine with Google Sheets

1Import the workflow JSON file into your n8n instance
2Add Google Sheets credentials and point the node to the PharmacyInventory sheet
3Configure the Send Email node with your SMTP or email service credentials
4Set the Schedule Trigger to run daily at 9 AM
5Update the stock threshold and expiry window values inside the Check node
6Activate the workflow and test with sample data

How to customize this workflow

→Change the daily trigger time or add a second schedule
→Add another email recipient or CC address in the Send Email node
→Extend the Google Sheets range or add new columns for minimum stock levels
→Insert a filter node to skip certain medicine categories