Keep your ketamine inventory reconciled and stocked
Every night, WebRun opens OptiMantra, reconciles the day's ketamine vial counts against dispensing and waste log entries, logs the running inventory to a Google Sheet, flags any discrepancy for the nurse manager, and drafts a reorder email in Gmail whenever supply falls under your reorder point.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I keep ketamine controlled substance inventory reconciled automatically?
WebRun reconciles your ketamine vial counts in OptiMantra every night against dispensing and waste log entries, flags any discrepancy for the nurse manager, and logs a running audit trail to Google Sheets. When supply falls under your reorder point, it drafts a reorder request in Gmail for the pharmacist in charge to review and send.
- Vial counts are reconciled every night instead of only at a periodic audit
- Discrepancies are flagged the same day they occur, not discovered weeks later
- A reorder draft is ready the moment supply crosses your reorder point
Built for ketamine clinic nurse managers · pharmacists in charge · clinic compliance officers · ketamine clinic owners
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
app.optimantra.comin a real browser with your saved login - no setup, no API keys. -
1
OptiMantra - reconcile controlled substance counts
optimantra.com How to Automate OptiMantra
WebRun opens OptiMantra to reconcile controlled substance counts. - Open OptiMantra and pull the day's ketamine dispensing and waste log entries
- Reconcile the running vial count against what was dispensed, wasted, and counted on hand
- Flag any discrepancy between the expected and counted amount for the nurse manager
- Note the current on-hand quantity against your set reorder point
Done when The day's controlled substance count is reconciled, with any discrepancy flagged.
-
2
Google Sheets - log the running inventory audit trail
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the running inventory audit trail. - Open the Controlled Substance Audit Log sheet
- Append the day's dispensed, wasted, and on-hand totals with a timestamp
- Highlight any day where the reconciliation did not balance
Done when The audit log sheet is current and any discrepancy day is highlighted.
-
3
Gmail - draft a reorder request when supply is low
gmail.com How to Automate Gmail
WebRun opens Gmail to draft a reorder request when supply is low. - When the on-hand quantity falls under your reorder point, draft a reorder request to your compounding pharmacy or wholesaler
- Include the quantity needed and the current on-hand count in the draft
- Save the email as a draft only. Never send a reorder request automatically. The pharmacist in charge must review and send it
Done when A reviewable reorder draft exists in Gmail whenever supply is under the reorder point, otherwise none is created.
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
Will it order more ketamine without anyone approving it?
No. WebRun only drafts a reorder email in Gmail and leaves it unsent. Your pharmacist in charge reviews the quantity and sends it themselves.
What happens if the vial count does not balance?
Any day where dispensed, wasted, and on-hand totals do not reconcile is flagged for the nurse manager and highlighted in the audit log, so it gets checked before it becomes a bigger problem.
Does it replace our physical controlled substance count?
No. It reconciles what is already logged in OptiMantra against your recorded counts. A licensed staff member still performs the physical count itself.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.