Automated QGenda Open Block Time Digest
Every Monday, WebRun opens QGenda, checks every surgeon's assigned block time for the next two weeks, calculates the hours still open against the release deadline, logs the full breakdown to a Google Sheet, and posts a Slack digest ranking the largest open blocks first.
How do I find open OR block time before it goes unused?
WebRun reviews every surgeon's block time in QGenda each Monday, compares booked case hours against the total allotted time, and logs the open hours and release deadline for every block to a Google Sheet. It then posts a ranked Slack digest of the biggest open blocks, so unused time gets released back to scheduling before the deadline passes.
- Unused block hours get surfaced weeks before the release deadline instead of after
- Scheduling offices open Slack to a ranked list instead of building one by hand
- Every block's open hours are tracked in one Sheet instead of scattered notes
Built for OR scheduling offices · surgical services directors · perioperative leadership · hospital operations 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.qgenda.comin a real browser with your saved login - no setup, no API keys. -
1
QGenda - check block time for the next two weeks
qgenda.com
WebRun opens QGenda to check block time for the next two weeks. - Open QGenda and pull block assignments for every surgeon for the next two weeks
- Compare booked case time against each block's total allotted hours
- Note each block's release deadline under your hospital's block release policy
Done when Every block for the next two weeks has a booked versus open hour count.
-
2
Google Sheets - log open hours by surgeon and service
google.com
WebRun opens Google Sheets to log open hours by surgeon and service. - Open the Block Utilization tracker sheet
- Append a row per block with surgeon, service, open hours, and release deadline
- Sort the sheet by open hours, largest first
Done when The tracker sheet reflects this week's full open block picture, ranked by size.
-
3
Slack - post the ranked open block digest
slack.com
WebRun opens Slack to post the ranked open block digest. - Post a Monday digest to the OR scheduling Slack channel
- List the five largest open blocks with their release deadline
- Link to the full Google Sheet for the scheduling office
Done when The scheduling office has this week's open block digest in Slack.
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 release the block time on its own?
No. It only calculates and reports what's open. Releasing a block back to open scheduling is still a decision your OR scheduling office makes.
How does it calculate open time?
It compares each block's total allotted hours in QGenda against the case time actually booked into it, then checks that block's release deadline under your hospital's policy.
Can it flag blocks close to their release deadline?
Yes. The Sheet and the Slack digest both surface each block's release deadline so nothing passes the deadline unnoticed.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.