Automated Auto Detailing Weekly Revenue Report
Every Monday morning, WebRun opens Urable, pulls all completed jobs and payments from the prior week, summarises revenue by service category, compares it to the previous week, logs the data to a Google Sheet for trend tracking, and posts a concise weekly revenue report to your Slack owner channel.
How do I automatically generate a weekly revenue report for my auto detailing shop?
Every Monday morning, WebRun pulls last week's completed jobs and payments from Urable, breaks them down by service category, and logs the data to a Google Sheet for trend tracking. It then posts a concise revenue summary to your Slack owner channel with a week-on-week comparison, so you start Monday knowing exactly how the business performed.
- Owner sees last week's full revenue breakdown before Monday's first appointment
- Data is logged to Google Sheets automatically for month-on-month trend analysis
- Week-on-week comparison highlights growth or dips that need attention
Built for auto detailing shop owners · ceramic coating studio owners · detailing business managers · mobile detailing operators
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.urable.comin a real browser with your saved login - no setup, no API keys. -
1
Urable - pull last week's completed jobs and revenue
urable.com
WebRun opens Urable to pull last week's completed jobs and revenue. - Open Urable and navigate to the reports or completed jobs section
- Filter completed jobs for the prior 7 days (Monday to Sunday)
- Capture total jobs completed, total revenue collected, revenue by service category (wash, full detail, ceramic coating, paint correction), and average job value
- Note the number of new customers vs. returning customers served
- Compare total revenue and job count to the previous week's figures if available
Done when Last week's revenue, job count, and service breakdown are compiled and ready for reporting.
-
2
Google Sheets - log weekly data for trend tracking
google.com
WebRun opens Google Sheets to log weekly data for trend tracking. - Open the weekly revenue tracking spreadsheet in Google Sheets
- Append a new row with the week's date range, total revenue, job count, breakdown by service type, and new vs. returning customer split
- Update any running totals or charts in the sheet
Done when Last week's data is logged in the Google Sheet and trend data is current.
-
3
Slack - post weekly revenue report to owner
slack.com
WebRun opens Slack to post weekly revenue report to owner. - Post the weekly revenue report to the owner or management channel in Slack
- Format it with total revenue, job count, top service categories, week-on-week change, and a link to the full Google Sheet
- Add a one-line highlight for any standout metric (best week of the month, highest average job value, etc.)
Done when Owner has last week's full revenue summary in Slack before the working week begins.
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 anything to customers?
No. This is a purely internal report posted to your owner Slack channel. No customer receives any message, and no external system is updated.
Can it compare this week's revenue to the same week last year?
Yes. Once a full year of data is logged in the Google Sheet, WebRun can read the same week's row from last year and include a year-on-year comparison in the Slack report.
What if some jobs in Urable are not yet marked as paid?
It reports on completed and paid jobs only, so unpaid or pending invoices are excluded from the revenue total. This keeps the report accurate and cash-based rather than accrual.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.