Automated ICNet Hand Hygiene Audit Rollup
Every Monday, WebRun opens the Google Sheets hand hygiene observation log, calculates last week's compliance percentage by unit and shift, checks ICNet for each unit's current HAI rate for context, and posts the rollup to Microsoft Teams so falling compliance is visible before it shows up in next month's infection rates.
How do I get a weekly hand hygiene compliance rollup by unit?
WebRun opens the Google Sheets hand hygiene observation log every Monday, calculates last week's compliance percentage by unit and shift, and checks ICNet for each unit's current HAI rate for context. It posts the rollup to Microsoft Teams with any unit below target flagged, so falling compliance is visible before it shows up in next month's infection rates.
- Every unit's compliance percentage is calculated and posted before Monday's IP huddle
- Falling compliance is visible next to HAI rate context, not in two separate reports
- Below-target units are flagged automatically so review time goes to the units that need it
Built for infection preventionists · unit nurse managers · hand hygiene observers · hospital quality and safety teams
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.icnetsoftware.comin a real browser with your saved login - no setup, no API keys. -
1
Google Sheets - pull last week's hand hygiene observations
google.com
WebRun opens Google Sheets to pull last week's hand hygiene observations. - Open the Hand Hygiene Observation Log sheet
- Pull all observations logged in the past 7 days
- Calculate the compliance percentage, opportunities performed correctly divided by opportunities observed, by unit and by shift
- Flag any unit below your facility's compliance target
Done when Last week's hand hygiene compliance percentage is calculated for every unit and shift.
-
2
ICNet - check each unit's current HAI rate for context
icnetsoftware.com
WebRun opens ICNet to check each unit's current HAI rate for context. - Open ICNet's HAI surveillance dashboard
- Pull each unit's current HAI rate for the same period
- Note any unit with both a compliance drop and a rising HAI rate
Done when Each unit's current HAI rate is captured alongside its hand hygiene compliance percentage.
-
3
Microsoft Teams - post the weekly compliance rollup
microsoft.com
WebRun opens Microsoft Teams to post the weekly compliance rollup. - Post the weekly rollup to the Infection Prevention Teams channel, by unit and shift
- Flag units below target, and highlight any unit with both a compliance drop and a rising HAI rate
- Link to the full Google Sheets log for detail
Done when The IP team has last week's hand hygiene rollup in Teams with any at-risk unit flagged.
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 raw observation numbers come from?
From your existing hand hygiene observers, who log opportunities and compliance directly into the Google Sheets log. WebRun only calculates and rolls up what your observers have already recorded.
Does it prove hand hygiene caused a change in infection rate?
No. It only places each unit's compliance percentage next to its current HAI rate for context. Drawing a causal conclusion is a judgment for your IP team, not WebRun.
Can we change the compliance target it flags against?
Yes. Set your facility's target compliance percentage and any unit below it is flagged in the weekly Teams rollup.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.