Automated eClinicalWorks GI Provider Utilization Report
Every Monday, WebRun opens eClinicalWorks, pulls the prior week's completed appointments and procedures for each GI provider, calculates utilization metrics including slots used, no-shows, and procedure mix, logs the results to Google Sheets, and posts a leadership digest to Slack so schedule efficiency can be reviewed and improved each week.
How do I get a weekly GI provider utilization report from eClinicalWorks automatically?
WebRun opens eClinicalWorks every Monday and pulls the prior week's appointment and procedure data for each GI provider, calculating utilization rate, no-show rate, and procedure volume by type. The results are logged to Google Sheets with week-over-week trends and a leadership digest goes to Slack so your practice can act on scheduling gaps each week.
- Leadership sees each provider's utilization rate and no-show rate every Monday without running a manual report
- Providers below the utilization threshold are flagged automatically for a scheduling review
- Week-over-week trends in Google Sheets reveal seasonal patterns and scheduling improvements
Built for GI practice administrators · gastroenterology medical directors · GI operations managers · multi-site GI group leaders
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.eclinicalworks.com/loginin a real browser with your saved login - no setup, no API keys. -
1
eClinicalWorks - pull prior week provider appointment and procedure data
eclinicalworks.com
WebRun opens eClinicalWorks to pull prior week provider appointment and procedure data. - Open eClinicalWorks and navigate to the schedule or reporting section
- Pull last week's appointment data filtered by GI provider: total slots, completed, no-show, and cancelled
- Also pull procedure counts by type (colonoscopy, upper endoscopy, flexible sigmoidoscopy) for each provider
Done when Each provider's prior week appointment totals and procedure counts are captured.
-
2
Google Sheets - calculate and log utilization metrics by provider
google.com
WebRun opens Google Sheets to calculate and log utilization metrics by provider. - Open the Provider Utilization Report sheet
- Add a weekly summary row for each provider with slot count, utilization rate, no-show rate, and procedure volume by type
- Calculate week-over-week change in utilization rate for each provider
Done when All provider utilization metrics for last week are logged and compared to the prior week.
-
3
Slack - deliver weekly utilization digest to leadership
slack.com
WebRun opens Slack to deliver weekly utilization digest to leadership. - Post a Monday utilization digest to the leadership Slack channel
- List each provider's utilization rate, no-show rate, and procedure volume for last week
- Flag any provider with utilization below your target threshold or no-show rate above your alert level
Done when Practice leadership has a Monday utilization digest in Slack with provider-level metrics and threshold flags.
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 share individual provider performance data outside the practice?
No. The utilization report is posted only to your internal leadership Slack channel and stored in your own Google Sheets. No provider performance data leaves your organization.
What counts as a utilized slot versus a no-show?
WebRun uses the appointment status recorded in eClinicalWorks: Completed counts as utilized, No-Show and Late Cancel count as wasted slots. You can adjust which statuses fall into each bucket to match your practice's definitions.
Can it track utilization across multiple clinic locations?
Yes. WebRun can filter eClinicalWorks data by location and produce a separate summary section per site in Google Sheets, giving multi-site practices a side-by-side comparison each week.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.