See how well each locksmith technician is being utilized every week
Every Monday, WebRun opens Housecall Pro, reads the prior week's completed jobs for each technician, tallies their job count, total revenue, and hours booked, and logs a utilization report to a Google Sheet so you can identify over-burdened techs and idle capacity at a glance.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I track locksmith technician utilization automatically each week?
Every Monday, WebRun opens Housecall Pro, tallies the prior week's completed jobs, total revenue, and hours booked for each technician, and logs the results to a Google Sheet with utilization rates highlighted. Owners see at a glance which techs are at capacity and where idle time can be filled.
- Weekly technician utilization rates calculated and logged without manual effort
- Under-utilized and over-burdened techs identified at a glance each Monday
- Running history of technician performance tracked in one Google Sheet
Built for locksmith business owners · locksmith operations managers · field service team leads
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
pro.housecallpro.comin a real browser with your saved login - no setup, no API keys. -
1
Housecall Pro - read completed jobs by technician
housecallpro.com How to Automate Housecall Pro
WebRun opens Housecall Pro to read completed jobs by technician. - Open Housecall Pro and filter completed jobs for the prior Monday to Sunday
- Group jobs by assigned technician
- For each technician, tally total jobs completed, total invoiced revenue, and total scheduled hours
- Note any technician with zero completed jobs for the week
Done when Per-technician job count, revenue, and hours are compiled for the prior week.
-
2
Google Sheets - log utilization report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log utilization report. - Append a new row per technician to the utilization Google Sheet with the week date, job count, revenue, and hours
- Calculate utilization rate as hours booked divided by available hours
- Highlight any technician below 60% utilization or above 90% for easy identification
Done when Weekly technician utilization data is logged and highlighted in the Google Sheet.
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
How does it calculate available hours per technician?
WebRun uses the scheduled shift hours you configure for each technician. You can set a default working week (e.g. 40 hours) or per-technician values to get accurate utilization rates.
Can I see individual job details, not just totals?
The default report shows weekly totals per technician. If you need a job-by-job breakdown, WebRun can add a detail tab to the same Google Sheet alongside the summary.
Is revenue here the invoiced amount or the collected amount?
Revenue reflects the invoiced total for completed jobs in Housecall Pro for that week. Collected vs. outstanding is tracked separately in the overdue invoice workflow.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.