Automated Omnicell Medication Expiry Reports
Every Monday, WebRun opens Omnicell, checks the expiry date on every cabinet item across all units, logs everything expiring within the next 60 days to a Google Sheet organized by unit, and texts the pharmacy technician responsible for each unit their pull list through Twilio.
How do I catch expiring medication in Omnicell cabinets before it's wasted?
Every Monday, WebRun checks the expiry date on every item in Omnicell cabinets, logs everything expiring within 60 days to a Google Sheet organized by unit, and texts each responsible technician their own pull list through Twilio, urgent items first. That gives the team weeks of lead time to rotate or use stock before it turns into waste.
- Technicians get weeks of lead time instead of finding expired stock during a count
- Waste and expiry write-offs drop because stock gets rotated before it lapses
- Each technician only hears about their own unit, not a hospital-wide list
Built for pharmacy inventory technicians · hospital pharmacy directors · unit-based pharmacy techs · pharmacy operations managers
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.omnicell.comin a real browser with your saved login - no setup, no API keys. -
1
Omnicell - check expiry dates across every cabinet
omnicell.com
WebRun opens Omnicell to check expiry dates across every cabinet. - Open Omnicell and pull the expiry date for every item currently stocked in a cabinet
- Filter to items expiring within the next 60 days
- Group the results by nursing unit and by the technician assigned to that unit
Done when Every item expiring within 60 days is identified with its unit and days remaining.
-
2
Google Sheets - log what's expiring within 60 days
google.com
WebRun opens Google Sheets to log what's expiring within 60 days. - Open the Expiring Medication Tracker sheet
- Append a row per item with the unit, drug, quantity, and expiry date
- Mark items expiring within 14 days in a separate urgent section
Done when This week's full expiring medication list is logged, with the most urgent items separated out.
-
3
Twilio - text each technician their pull list
twilio.com
WebRun opens Twilio to text each technician their pull list. - Text each technician their own unit's pull list, urgent items first
- Keep the text to item, quantity, and expiry date so it's actionable from a phone
- Send nothing to a technician whose unit has nothing expiring this week
Done when Every technician with expiring stock on their unit has received their pull list by text.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it remove or return the expiring stock automatically?
No. WebRun only identifies what's expiring and texts the responsible technician a pull list. Physically pulling, quarantining, or returning stock to your wholesaler is done by your team.
Why a 60 day window instead of just what's already expired?
A 60 day window gives the technician time to rotate stock or use it before it expires, instead of only learning about waste after the fact. The most urgent items, expiring within 14 days, are called out separately.
What if a unit has nothing expiring that week?
That technician simply doesn't get a text. Only units with genuinely expiring stock receive a pull list, so nobody is checking a message that says there's nothing to do.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.