Automated HRT Control Provider Utilization Reports
On the first of each month, WebRun opens HRT Control, counts last month's completed and no-show visits by provider, matches them against each provider's available slots on Google Calendar, and logs a utilization report to a Google Sheet.
How do I track provider schedule utilization across locations?
On the first of every month, WebRun compares last month's booked visits in HRT Control against each provider's available slots on Google Calendar, and logs a utilization rate by provider and location to a Google Sheets tracker. It flags any provider under 70 percent utilization, so scheduling gaps get noticed early instead of at the next quarterly review.
- Scheduling gaps get flagged the first week of the month, not the next quarter
- Utilization is calculated from real calendar availability, not a fixed assumption
- A month-over-month history builds automatically in one tracker
Built for HRT clinic owners · TRT practice managers · multi-location clinic operators · clinic schedulers
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.hrtcontrol.comin a real browser with your saved login - no setup, no API keys. -
1
HRT Control - count booked visits by provider
hrtcontrol.com
WebRun opens HRT Control to count booked visits by provider. - Open HRT Control and count last month's completed and no-show visits by provider
- Break the counts out by clinic location
- Note any provider with a no-show rate above 10 percent
Done when Last month's visit and no-show counts are captured by provider and location.
-
2
Google Calendar - count available slots
calendar.google.com
WebRun opens Google Calendar to count available slots. - Count each provider's total available appointment slots for the month
- Match booked visits against open slots to get a utilization rate
- Flag any provider under 70 percent utilization
Done when A utilization rate is calculated for every provider.
-
3
Google Sheets - log the utilization report
google.com
WebRun opens Google Sheets to log the utilization report. - Log the utilization report with visits, no-shows, and utilization rate by provider
- Sort the report with the lowest-utilization provider first
- Keep a month-over-month history in the same tracker
Done when The utilization tracker reflects every provider's rate for the month.
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
Where do the available slots come from?
From each provider's own Google Calendar, so the utilization rate reflects the hours they actually made available that month, not a fixed assumption.
Does this report single out a provider publicly?
No. It's logged to an internal Google Sheets tracker for practice management, not shared or posted anywhere patients or providers outside management would see it.
What counts as a no-show in the report?
Any booked visit HRT Control shows as not completed and not cancelled in advance, counted separately from utilization so the two numbers can be read side by side.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.