Automated Contrast Lot Expiry Tracking
Every Monday, WebRun opens HI-IQ, reads contrast media inventory by lot and expiry date, flags lots expiring within your window or already past date, logs them to a Google Sheet in first-to-expire order, and sends a short use-first list to Telegram so stock is rotated before it is wasted.
How do I track contrast media lot expiry dates each week?
WebRun opens HI-IQ every Monday and reads contrast media lots with their expiry dates. It flags lots expiring within your window or already past date, logs them to a Google Sheet in first-to-expire order, and sends a use-first list to Telegram, so your team rotates stock and pulls expired lots before contrast is wasted.
- Expiring lots get used before they hit the expiry date
- Expired contrast is pulled from the shelf the same week
- Value at risk from soon-to-expire stock is tallied every Monday
Built for IR inventory buyers · angio lab coordinators · interventional radiology pharmacy techs · OBL materials 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.hi-iq.comin a real browser with your saved login - no setup, no API keys. -
1
HI-IQ - read contrast lots and expiry dates
hi-iq.com
WebRun opens HI-IQ to read contrast lots and expiry dates. - Open HI-IQ and go to the contrast media inventory view
- List each lot with product, concentration, quantity on hand, storage location, and expiry date
- Flag lots expiring within your alert window and any lot already past its expiry date
- Sort the flagged lots from soonest expiry to latest
Done when Every contrast lot expiring soon or already expired is listed with its quantity, location, and date.
-
2
Google Sheets - log lots by expiry order
google.com
WebRun opens Google Sheets to log lots by expiry order. - Open the Contrast Lot Expiry sheet and refresh it for this week
- List one row per flagged lot with product, lot number, quantity, location, and expiry date
- Sort first-to-expire at the top and mark already-expired rows clearly
- Keep a running tally of quantity and estimated value at risk
Done when The sheet lists this week's expiring and expired lots in first-to-expire order with a value tally.
-
3
Telegram - send the use-first list
telegram.org
WebRun opens Telegram to send the use-first list. - Send a short use-first message to the IR supply Telegram group
- List the lots expiring this week with quantity, location, and days until expiry
- Call out any already-expired lot to pull from the shelf and link to the full Google Sheet
Done when The supply group has this week's use-first list with expiring lots and any expired stock to pull.
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 adjust inventory in HI-IQ?
No. WebRun only reads the contrast lots and expiry dates. It writes a use-first list to Google Sheets and Telegram. Pulling expired stock and adjusting counts stays a manual step your team controls.
How far ahead does it warn?
It uses the alert window you set, for example lots expiring within 30 days. Anything inside that window is listed first-to-expire, and lots already past date are called out separately to pull from the shelf.
Why send this to Telegram?
Telegram reaches the supply team fast on the floor, and the list holds no patient information, only product, lot, quantity, location, and dates. The full detail sits in the linked Google Sheet.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.