See exactly where your pool service revenue is coming from each week
Every Monday, WebRun opens Jobber, pulls all invoiced and completed jobs from the prior week, calculates revenue by route and technician, logs the breakdown to a Google Sheet for trend tracking, and posts a concise revenue summary to Slack so your team starts the week with a clear financial picture.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically get a weekly pool service revenue report broken down by route?
Every Monday, WebRun opens Jobber and pulls last week's completed job revenue broken down by route and technician. It logs the results to Google Sheets with week-over-week comparison and posts a concise summary to Slack, so management starts every week knowing which routes performed and which need attention.
- Management sees route-level revenue every Monday morning without pulling a single report manually
- Google Sheets log enables month-over-month and year-over-year trend analysis
- Underperforming routes flagged in Slack before issues compound over multiple weeks
Built for pool service company owners · pool route managers · pool service operations managers · multi-technician pool businesses
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.getjobber.comin a real browser with your saved login - no setup, no API keys. -
1
Jobber - pull last week's completed job revenue
getjobber.com How to Automate Jobber
WebRun opens Jobber to pull last week's completed job revenue. - Open Jobber and filter invoiced and completed jobs from the prior calendar week
- Collect revenue, job type, route or service area, and assigned technician for each completed job
- Separate recurring service revenue from one-time repair and equipment revenue
- Identify any routes with significantly lower revenue than the prior week
Done when Last week's completed job revenue has been collected with route and technician breakdown.
-
2
Google Sheets - log revenue breakdown by route
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log revenue breakdown by route. - Open the weekly revenue tracking sheet
- Append a new section for the current week with revenue by route, by technician, and by job type
- Calculate week-over-week change for each route
- Update the running totals for month-to-date and year-to-date columns
Done when Last week's revenue breakdown has been logged in Google Sheets with week-over-week comparison.
-
3
Slack - post weekly revenue summary
slack.com How to Automate Slack
WebRun opens Slack to post weekly revenue summary. - Post a concise revenue summary to the management channel
- Lead with total revenue for the week and highlight the top and bottom performing routes
- Note any significant week-over-week changes and flag routes below target
Done when Management has last week's revenue summary in Slack at the start of the new week.
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 this send any information externally?
No. The report posts only to your internal Slack channel and logs to your own Google Sheet. No revenue data leaves your internal tools.
Can I see recurring service revenue separately from repair jobs?
Yes. The report separates recurring maintenance revenue from one-time repair and equipment jobs so you can track each type independently.
How far back does the report look?
Each Monday it pulls the prior calendar week. The Google Sheet retains every week's data, so you can review trends over any time period by scrolling back through the log.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.