Automated Portable Sanitation Weekly Revenue Report
Every Monday, WebRun opens ServiceCore, pulls the prior week's revenue collected, route completion rate, units serviced, and outstanding invoices, logs the numbers to a Google Sheet for trend tracking, and posts a concise weekly summary to your Slack management channel.
How do I automatically get a weekly revenue and route report for my sanitation business?
Every Monday, WebRun pulls the prior week's revenue collected, route completion rate, units serviced, and outstanding balances from ServiceCore, logs the metrics to a Google Sheet for trend tracking, and posts a concise summary to your Slack management channel so leadership starts the week with clear numbers.
- Management starts every Monday with prior week revenue and route metrics in Slack
- Weekly data is logged automatically to Google Sheets for trend tracking over time
- Outstanding balances are surfaced each week so collections stay a priority
Built for portable sanitation owners · sanitation operations managers · porta-potty rental management teams · field service finance leaders
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.servicecore.comin a real browser with your saved login - no setup, no API keys. -
1
ServiceCore - pull prior week revenue and route completion data
servicecore.com
WebRun opens ServiceCore to pull prior week revenue and route completion data. - Open ServiceCore and navigate to the reports or dashboard section
- Pull revenue collected, invoices issued, and outstanding balances for the prior week
- Pull route completion rate, total stops completed, missed stops, and units serviced for the prior week
- Note the top revenue customer and the most active route for the week
Done when Prior week revenue and route completion metrics are captured from ServiceCore.
-
2
Google Sheets - log weekly metrics to tracking sheet
google.com
WebRun opens Google Sheets to log weekly metrics to tracking sheet. - Open the weekly metrics tracking sheet in Google Sheets
- Append a new row with the date and all captured metrics for the prior week
- Include revenue collected, invoices issued, outstanding balances, completion rate, and missed stops
Done when Prior week metrics are logged to the Google Sheet with a date stamp.
-
3
Slack - post weekly revenue and route summary
slack.com
WebRun opens Slack to post weekly revenue and route summary. - Post a concise weekly revenue and route summary to the Slack management channel
- Include revenue collected, route completion rate, units serviced, and outstanding balance total
- Highlight any significant week-over-week changes or flagged metrics
Done when Management team has the weekly summary in Slack with key metrics at a glance.
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 any reports outside of Slack and Sheets?
No. The weekly summary posts only to your internal Slack management channel and logs to a private Google Sheet. No data is sent externally or to customers.
What metrics does the report include?
It covers revenue collected, invoices issued, outstanding balance total, route completion rate, total stops serviced, missed stops, and the top revenue customer for the week.
Can I use the Google Sheet to track trends over multiple weeks?
Yes. Each Monday's run appends a new dated row to the same sheet, so the data builds automatically into a running history you can chart and review at any time.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.