Keep staffing in line with patient census
Every night, WebRun opens ShiftWizard, compares scheduled nurse-to-patient staffing against each unit's census-based target for the next shift, logs the variance by unit to Google Sheets, and drafts a summary email through Gmail for the director of nursing to review before the next shift begins.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track staffing versus patient census automatically?
Every night, WebRun opens ShiftWizard, compares scheduled nurse staffing against each unit's census-based target for the next shift, and calculates the variance. It logs the results by unit to Google Sheets and drafts a summary email for the director of nursing to review, so understaffed units surface before the next shift starts, not partway through it.
- Understaffed units surface before the shift starts, not partway through it
- A running Google Sheet history shows variance patterns across shifts and days
- Leadership gets a drafted summary ready to send, not a raw data dump
Built for directors of nursing · house supervisors · nurse staffing offices · hospital operations 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.healthstream.comin a real browser with your saved login - no setup, no API keys. -
1
ShiftWizard - compare scheduled staffing to census target
healthstream.com How to Automate ShiftWizard
WebRun opens ShiftWizard to compare scheduled staffing to census target. - Open ShiftWizard and pull the scheduled staffing count for the next shift on every unit
- Compare it against each unit's census-based staffing target
- Calculate the variance, over or under target, for each unit
Done when Every unit's next shift has a calculated staffing variance against its census target.
-
2
Google Sheets - log the variance by unit
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log the variance by unit. - Open the staffing-to-census tracker sheet
- Log each unit's target, scheduled count, and variance for the shift
- Keep a running history so patterns across shifts and days are visible
Done when This shift's variance is logged for every unit, with history preserved.
-
3
Gmail - draft the leadership summary
gmail.com How to Automate Gmail
WebRun opens Gmail to draft the leadership summary. - Draft a summary email for the director of nursing listing every unit's variance, most understaffed first
- Include a link to the full Google Sheet tracker
- Leave the email in Drafts for the director of nursing to review and send
Done when A draft summary email is ready for the director of nursing, not yet sent.
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 move nurses between units to fix the variance?
No. WebRun only reports the gap between scheduled staffing and the census target. Reassigning staff or calling in help is always a decision made by the house supervisor or nurse manager.
Will the summary email send itself?
No. The email is drafted in Gmail and left for the director of nursing to review and send. WebRun never emails leadership without that approval.
How is the census target set?
It comes from whatever census-based staffing matrix or ratio your facility already uses in ShiftWizard. WebRun reads that target, it does not set or override it.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.