Automated Pharmacy Daily Script Volume Report
Every morning, WebRun opens BestRx, pulls the prior day's prescription count, revenue, generic dispensing rate, and top-10 drugs by volume, appends the data to a running Google Sheet, and posts a concise Slack digest so the pharmacist-owner sees performance before the day starts.
How can a pharmacy automatically generate a daily prescription volume and revenue report?
WebRun pulls the prior day's prescription count, revenue, generic dispensing rate, and top drugs from BestRx every morning, appends the data to a 90-day Google Sheet log, and posts a concise Slack digest so the pharmacist-owner sees yesterday's performance before the first patient of the day.
- Pharmacist-owner sees yesterday's Rx count and revenue before the morning rush, without logging in
- 90-day trend sheet shows volume patterns for staffing and ordering decisions
- Week-on-week dips are flagged the morning they happen, not discovered at month-end
Built for independent pharmacy owners · community pharmacists · pharmacy 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.bestrx.comin a real browser with your saved login - no setup, no API keys. -
1
BestRx - pull prior day prescription and revenue totals
bestrx.com
WebRun opens BestRx to pull prior day prescription and revenue totals. - Open BestRx and run the daily dispensing or prescription volume report for the prior business day
- Capture total prescriptions filled, total revenue, new vs. refill split, and generic dispensing rate
- Note the top 10 drugs by prescription count for the day
- Compare against the same day in the prior week to calculate week-on-week change
Done when Yesterday's prescription volume, revenue, generic rate, and top drugs are captured.
-
2
Google Sheets - append to running daily performance log
google.com
WebRun opens Google Sheets to append to running daily performance log. - Append a new row to the daily performance tracking sheet with date, total Rx, revenue, generic rate, and week-on-week change
- Update the top-10 drug tab with yesterday's data
- Keep a rolling 90-day view so trends are visible without scrolling back through large datasets
Done when The Google Sheet is updated with yesterday's performance data and 90-day trend.
-
3
Slack - post morning script volume digest
slack.com
WebRun opens Slack to post morning script volume digest. - Post the morning digest to the pharmacy Slack channel with Rx count, revenue, generic rate, and week-on-week comparison
- Highlight any significant change (up or down more than 10%) with a brief label
- Include a link to the Google Sheet for the full 90-day trend view
Done when The pharmacist-owner sees yesterday's key metrics in Slack before the first patient arrives.
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 include patient-identifiable information in the Slack digest?
No. The Slack digest contains only aggregate metrics: total Rx count, revenue, generic dispensing rate, and top drugs by volume. No patient names, dates of birth, or prescription details are posted to Slack.
Can I see trends beyond a single day?
Yes. WebRun appends each day to a running Google Sheet that maintains a 90-day rolling view, so you can spot weekly and monthly patterns from the same sheet the daily digest links to.
What counts as a significant change that gets highlighted?
By default, any week-on-week change of more than 10% in either Rx count or revenue is labeled in the Slack post. You can adjust this threshold in your WebRun workflow settings.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.