Low stock and expiry alerts for your pharmacy
Checks your pharmacy inventory sheet every morning and emails the medicines running low or near expiry, marking each in the sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in the order it first runs them, and what it is for.
- 1Google SheetsRead rowsReads every medicine on the inventory tab, with its quantity, expiry date, reorder level and current alert status.
- 2GmailSendSends the pharmacist one email listing the medicines low on stock, expired or expiring soon, and any rows that could not be read.
- 3Google SheetsWrite rowWrites the alert and the date it was first raised into the row's Alert Status cell, or clears it once the medicine is fine again.
How it works
What happens on each run, in plain English.
Every morning at 09:00, the inventory tab of your spreadsheet is read and each medicine is checked two ways: its quantity against its reorder level, and its expiry date against today. Everything at or below the reorder level, already expired, or expiring within your warning window goes into one email to the pharmacist, split into what is new today and what is still outstanding from earlier runs.
Each alert is then written into the sheet's Alert Status column with the date it was first raised, and cleared again once the medicine has been restocked or replaced, so the sheet always shows the current state. Only that one cell of a row is written. A row whose quantity or expiry date cannot be read is listed in the same email rather than skipped, and a blank tab or a missing column stops the run with a message saying what to fix. When every medicine is stocked and in date, nothing is sent.
Before the first run you need a spreadsheet tab with a header row naming the medicine, quantity and expiry date columns, a column headed Alert Status, an optional Reorder Level column, and the pharmacist's email address.
You May Also Be Interested In
Daily inventory monitor for low stock and expiryChecks your inventory sheet every morning and emails what is out of stock, running low, expired or expiring soon, marking each row.
Turn order emails into spreadsheet rowsReads order emails hourly, has AI pull out each line item, and appends it to your order sheet.
Personalised marketing emails from customer dataReads each customer's purchases and feedback, lets AI decide who earns a coupon, and sends a tailored email from Gmail.Send sentiment-aware emails with couponsEmails each customer about their purchase in your tone, reads their feedback first, and adds a coupon when the feedback is negative.
Start from a workflow that already works.
Add "Low stock and expiry alerts for your pharmacy" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required