Automated EVS Cleaning Audit Score Reports
Every Monday morning, WebRun opens FacilityRF's Inspect Now history, pulls the past week's completed audits, logs the average score by unit and housekeeper with week over week change to Google Sheets, and posts a summary to your EVS leadership channel in Microsoft Teams.
How do I get a weekly report of EVS cleaning audit scores?
Every Monday, WebRun pulls the past week's completed audits from FacilityRF's Inspect Now history, calculates an average score by unit and by housekeeper, and logs the results with week over week change to Google Sheets. It posts a summary to your EVS leadership Teams channel, highlighting the facility average and any unit whose score dropped.
- Leadership sees a facility wide score every Monday without pulling a manual report
- Units or housekeepers with a sharp score drop are flagged automatically
- Every week's scores are logged for a clean, ongoing trend record
Built for EVS directors · environmental services managers · quality assurance coordinators · hospital operations leadership
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
facilityrf.comin a real browser with your saved login - no setup, no API keys. -
1
FacilityRF - pull last week's audit scores
facilityrf.com
WebRun opens FacilityRF to pull last week's audit scores. - Open FacilityRF's Inspect Now history and pull every completed audit from the past week
- Group scores by unit and by housekeeper, and calculate each average
- Compare this week's averages against the prior week for each unit
Done when Every completed audit from the past week is scored and grouped by unit and housekeeper.
-
2
Google Sheets - log scores by unit and housekeeper
google.com
WebRun opens Google Sheets to log scores by unit and housekeeper. - Open the Cleaning Audit Score Log
- Append this week's average score by unit and by housekeeper, with the change from last week
- Highlight any unit or housekeeper whose average dropped more than 5 points
Done when The log has this week's scores recorded with week over week change.
-
3
Microsoft Teams - post the weekly score summary
microsoft.com
WebRun opens Microsoft Teams to post the weekly score summary. - Post a summary to the EVS leadership channel with the facility average, the top scoring unit, and any unit that dropped
- Link to the full Google Sheets log for anyone who wants the detail
Done when EVS leadership has this week's audit score summary in Teams.
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 score individual housekeepers or just units?
Both. FacilityRF's audit data is grouped into an average by unit and a separate average by housekeeper, so leadership can see facility wide trends and individual performance in the same report.
How far back does each week's report look?
Each Monday's report covers exactly the prior 7 days of completed audits, compared against the 7 days before that, so the week over week change is always an apples to apples comparison.
What happens if a unit's score drops sharply?
Any unit or housekeeper whose average drops more than 5 points from the prior week is highlighted in the Sheets log and called out by name in the Teams summary, so leadership can follow up right away.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.