Automated Tree Service Weekly Revenue Report
Every Monday, WebRun opens SingleOps, totals last week's completed jobs and invoiced revenue, logs the figures to a Google Sheets dashboard, and posts a clear revenue and jobs summary to your management Slack channel so leadership starts the week with full visibility.
How do I get a weekly revenue and jobs report for my tree service business automatically?
WebRun opens SingleOps every Monday morning, totals last week's completed jobs and invoiced revenue by service type, logs the figures to a Google Sheets dashboard, and posts a clear summary to your management Slack channel. Leadership starts every week with full visibility into revenue, collections, and outstanding balances.
- Leadership sees last week's revenue, job count, and service mix before Monday standup
- Year-to-date revenue dashboard updates automatically each week in Google Sheets
- Revenue dips are flagged the Monday after they happen, not weeks later
Built for tree service owners · arborist business managers · tree care operations teams · landscaping company 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
app.singleops.comin a real browser with your saved login - no setup, no API keys. -
1
SingleOps - pull last week's jobs and revenue figures
singleops.com
WebRun opens SingleOps to pull last week's jobs and revenue figures. - Open SingleOps and filter completed jobs from the previous 7 days
- Capture total jobs completed, total invoiced revenue, total collected revenue, and outstanding balance
- Break down revenue by service type: removals, pruning, plant health care, stump grinding, and emergency work
- Note any large jobs or unusual variances compared to the previous week
Done when Last week's job count, invoiced revenue, collected revenue, and service mix are captured.
-
2
Google Sheets - log weekly totals to the dashboard
google.com
WebRun opens Google Sheets to log weekly totals to the dashboard. - Append this week's totals to the weekly revenue dashboard sheet with the date range
- Update running year-to-date totals and service mix percentages
- Flag any week where revenue is more than 20% below the prior 4-week average
Done when Weekly figures are logged and year-to-date totals are updated in Google Sheets.
-
3
Slack - post revenue summary to management channel
slack.com
WebRun opens Slack to post revenue summary to management channel. - Post a Monday revenue summary to the management channel with last week's job count, invoiced revenue, and collected revenue
- Include a breakdown by service type and note any significant variances
- Link to the Google Sheets dashboard for the full detail
Done when Management has last week's revenue summary in Slack before the Monday standup.
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 include jobs that were invoiced but not yet paid?
Yes. The report shows both invoiced revenue and collected revenue separately so you can see the outstanding balance at a glance.
Can it break down revenue by crew or service type?
Yes. The summary includes a service type breakdown by default. Crew-level reporting can be added if your SingleOps data includes crew assignments per job.
How far back does the report look?
It covers the previous 7 days by default. You can adjust the window to match your billing cycle or reporting period.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.