Get a weekly nephrology provider utilization digest without pulling reports yourself
Every Monday morning, WebRun opens Acumen, reads the prior week's completed visits and scheduled capacity per provider, calculates a utilization rate for each nephrologist, appends the metrics to a running Google Sheets log, and posts a digest to the practice management Slack channel.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I get a weekly nephrology provider utilization report automatically?
Every Monday morning, WebRun opens Acumen and pulls each nephrologist's scheduled slots and completed visits for the prior week, calculates a utilization rate, appends the results to a Google Sheets log, and posts a digest to Slack. Practice leaders see under-booked providers flagged before Monday's scheduling decisions are made.
- Under-booked providers are visible every Monday morning before scheduling decisions
- A rolling four-week utilization trend surfaces in Google Sheets automatically
- Practice leaders replace a manual report pull with a five-second Slack read
Built for nephrology practice administrators · CKD clinic operations managers · nephrology medical directors · dialysis practice 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
service.acumenmd.comin a real browser with your saved login - no setup, no API keys. -
1
Acumen - pull provider visit and schedule data
acumenmd.com How to Automate Acumen
WebRun opens Acumen to pull provider visit and schedule data. - Open Acumen and navigate to the scheduling and visit reports section
- For each active provider, collect total scheduled slots, completed visits, and canceled or no-show counts for the prior week
- Calculate a utilization rate as completed visits divided by available slots
- Note each provider's most common appointment types for context
Done when Utilization metrics for every active nephrology provider are calculated for the prior week.
-
2
Google Sheets - append weekly utilization log
google.com How to Automate Google Sheets
WebRun opens Google Sheets to append weekly utilization log. - Append a new row per provider to the Provider Utilization Log sheet
- Record week ending date, provider name, scheduled slots, completed visits, cancellations, and utilization rate
- Update a summary tab with a rolling four-week average per provider
Done when The utilization log is updated with last week's data and four-week averages are refreshed.
-
3
Slack - post utilization digest
slack.com How to Automate Slack
WebRun opens Slack to post utilization digest. - Post a Monday morning digest to the practice management Slack channel
- List each provider's utilization rate for last week alongside their four-week average
- Highlight any provider whose rate fell below 70% and include a link to the Google Sheets log
Done when Practice leaders have last week's utilization snapshot in Slack before Monday's scheduling calls.
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 make any scheduling changes automatically?
No. WebRun only reads and reports utilization data. All scheduling decisions and capacity changes are made by practice management staff after reviewing the digest.
What counts as an available slot?
It counts all slots on the provider's Acumen schedule that were not blocked or marked as administrative. You can adjust the slot definition in the workflow settings to match your practice's scheduling model.
How far back does the four-week average go?
The rolling average uses the four most recently completed weeks logged in Google Sheets. The first four weeks after setup will build incrementally until a full rolling window is available.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.