Automated Pest Control Weekly Revenue Report
Every Monday morning, WebRun opens GorillaDesk, pulls the previous week's completed services and revenue by route and technician, logs the data to a running Google Sheets tracker, and posts your management team a clean Slack summary so everyone starts the week knowing exactly how last week performed.
How do I automatically get a weekly revenue report by route for my pest control business?
WebRun opens GorillaDesk every Monday, pulls the previous week's completed services and revenue grouped by route and technician, appends the data to a Google Sheets tracker, and posts your management team a Slack summary with route totals, week-over-week comparisons, and a link to the full data. Management sees route performance before the work week begins.
- Management sees last week's route revenue in Slack before Monday's work begins
- A running Google Sheets log captures week-over-week trends automatically
- Under-performing routes are flagged before the new week gets underway
Built for pest control business owners · pest control operations managers · multi-route pest control companies · field service management 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
app.gorilladesk.comin a real browser with your saved login - no setup, no API keys. -
1
GorillaDesk - pull last week's revenue and service data by route
gorilladesk.com
WebRun opens GorillaDesk to pull last week's revenue and service data by route. - Open GorillaDesk and navigate to the Reports section
- Filter completed services to the previous Monday through Sunday
- Group results by route and technician
- Capture total jobs completed, total revenue, average ticket value, and any invoices still outstanding per route
Done when Last week's revenue and service counts are captured at the route and technician level.
-
2
Google Sheets - log weekly revenue data to tracker
google.com
WebRun opens Google Sheets to log weekly revenue data to tracker. - Append the week's data as a new row in the weekly revenue tracker spreadsheet
- Include columns for week ending date, route, technician, jobs completed, total revenue, and average ticket
- Highlight any route that missed its weekly revenue target
Done when Last week's route data is logged in Google Sheets and the tracker is up to date.
-
3
Slack - post weekly revenue report to management
slack.com
WebRun opens Slack to post weekly revenue report to management. - Post a weekly revenue summary to the management Slack channel
- List each route with jobs completed, total revenue, and comparison to the prior week
- Call out the top-performing route and any route that fell short of target
- Include a link to the full Google Sheets tracker for deeper review
Done when Management has last week's route revenue summary in Slack with a link to the full data.
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 send anything to customers?
No. This is a purely internal management report. The Slack message and Google Sheets log are visible only to your team.
Can it show me which technician generated the most revenue?
Yes. The report groups data by both route and individual technician, so you can see each person's contribution to last week's total.
How far back does the Google Sheets log go?
It appends a new row each Monday, building a running history from the day you first run it. You can use Google Sheets to chart trends over any date range you choose.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.