All templates
For appliance repair business owners, field service managers & repair shop operators

Get a clear weekly revenue picture for your repair business

Every Monday, WebRun opens Housecall Pro, totals last week's completed jobs and collected payments, logs the breakdown to a Google Sheets revenue tracker, and posts a concise weekly summary to your Slack channel so your team starts the week knowing exactly where revenue stands.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 7:00 AM WebRun
1 Housecall Pro total last week's jobs and payments
2 Google Sheets log revenue breakdown to tracker
3 Slack post weekly revenue summary to team
Run a sample
In short

How do I automatically generate a weekly revenue report for my appliance repair business?

WebRun opens Housecall Pro every Monday, totals the previous week's completed jobs and collected payments, logs a full breakdown to a Google Sheets revenue tracker, and posts a concise summary to Slack. Your team starts every week with a clear picture of revenue collected, outstanding, and jobs completed.

  • Your team starts every Monday with last week's revenue collected and outstanding in Slack
  • A running Google Sheets log makes month-end and quarter-end reporting straightforward
  • Revenue breakdowns by appliance type or technician surface where the business is strongest

Built for appliance repair business owners · field service managers · repair shop operators · operations teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.housecallpro.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Housecall Pro - total last week's jobs and payments
    housecallpro.com How to Automate Housecall Pro
    WebRun in Housecall Pro: total last week's jobs and payments
    WebRun opens Housecall Pro to total last week's jobs and payments.
    • Open Housecall Pro and filter completed jobs to the previous Monday through Sunday
    • Capture the total number of jobs completed, total invoiced, total collected, and any outstanding balances
    • Break down revenue by appliance type or service category where the data is available

    Done when Last week's job count, invoiced total, collected total, and outstanding balance are captured.

  3. 2
    Google Sheets - log revenue breakdown to tracker
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log revenue breakdown to tracker
    WebRun opens Google Sheets to log revenue breakdown to tracker.
    • Open the weekly revenue tracker Google Sheet
    • Append a new row for last week with the date range, job count, invoiced total, collected total, and outstanding balance
    • Update any running totals or charts in the Sheet with the new data

    Done when Last week's revenue figures are logged in Google Sheets with the full breakdown.

  4. 3
    Slack - post weekly revenue summary to team
    slack.com How to Automate Slack
    WebRun in Slack: post weekly revenue summary to team
    WebRun opens Slack to post weekly revenue summary to team.
    • Post a concise weekly revenue summary to the management or operations Slack channel
    • Include jobs completed, revenue collected, revenue outstanding, and a brief comparison to the previous week
    • Link to the Google Sheets tracker for anyone who wants the full breakdown

    Done when The team has last week's revenue summary in Slack with a link to the full Google Sheets report.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.housecallpro.com
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
Revenue summary · Slack
OutputWhat each run produces - A weekly revenue summary posted to Slack and logged to Google Sheets with job count, invoiced total, collected total, and outstanding balance.
Text
Setup & safety

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.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does this send anything to customers?

No. The weekly revenue report is entirely internal. It posts to your Slack channel and logs to Google Sheets. No customer-facing messages are sent at any point.

Can it break down revenue by technician or appliance type?

Yes, where Housecall Pro has the job category or technician assignment recorded. WebRun captures available breakdowns and includes them in both the Sheets log and the Slack summary.

How far back does it look for the weekly totals?

Each Monday run covers the previous Monday through Sunday, giving you a clean seven-day window. The Google Sheets log accumulates these weekly rows so you can compare trends over time.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.