All templates
For vacation rental managers, short-term rental property managers & property management companies

Get a weekly occupancy and revenue report across all your properties

Every Monday, WebRun opens Hostaway, collects last week's occupancy rate, total revenue, average daily rate, and number of bookings for each property, posts a clean performance summary to your Slack channel, and appends the data to a rolling Google Sheets report for trend analysis.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 8:00 AM WebRun
1 Hostaway collect last week's occupancy and revenue data
2 Slack post weekly performance summary
3 Google Sheets append data to rolling revenue report
Run a sample
In short

How can I get an automatic weekly occupancy and revenue report for my vacation rentals?

Every Monday, WebRun opens Hostaway, collects last week's occupancy rate, total revenue, average daily rate, and booking count for each property, and posts a concise performance summary to Slack. Properties with notable occupancy drops are flagged. The full data is appended to a rolling Google Sheets report for trend tracking.

  • You see last week's occupancy and revenue for every property in Slack on Monday morning
  • Underperforming properties are flagged before the week gets away from you
  • A rolling Sheets report builds a historical benchmark for every property over time

Built for vacation rental managers · short-term rental property managers · property management companies · real estate investors with rental portfolios

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 dashboard.hostaway.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Hostaway - collect last week's occupancy and revenue data
    hostaway.com
    WebRun in Hostaway: collect last week's occupancy and revenue data
    WebRun opens Hostaway to collect last week's occupancy and revenue data.
    • Open Hostaway and navigate to the reporting section
    • Pull last week's occupancy rate, total revenue, average daily rate, and booking count for each property
    • Compare this week's figures to the prior week and flag any properties with significant occupancy drops

    Done when Last week's occupancy and revenue data is collected for every property.

  3. 2
    Slack - post weekly performance summary
    slack.com How to Automate Slack
    WebRun in Slack: post weekly performance summary
    WebRun opens Slack to post weekly performance summary.
    • Post a concise weekly performance summary to your operations Slack channel
    • List each property with its occupancy rate, revenue, and ADR for the week
    • Highlight any properties that dropped more than 10 points in occupancy week over week

    Done when The weekly occupancy and revenue summary is posted in Slack.

  4. 3
    Google Sheets - append data to rolling revenue report
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: append data to rolling revenue report
    WebRun opens Google Sheets to append data to rolling revenue report.
    • Append a row for each property with the week's occupancy rate, revenue, ADR, and booking count
    • Update the rolling chart data so weekly trends are visible across the full history

    Done when Last week's data is appended to the rolling Google Sheets revenue report.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
dashboard.hostaway.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Performance report · Slack
OutputWhat each run produces - A weekly occupancy and revenue summary posted to Slack, plus a rolling performance log in Google Sheets.
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

Which metrics does the report include?

Each weekly report includes occupancy rate, total revenue, average daily rate, and booking count per property, plus a week-over-week comparison for occupancy.

Does it cover all properties in one report or one report per property?

It covers all your properties in a single Slack summary, with each property listed as its own row. The Google Sheets log also keeps each property on its own row for easy filtering.

Can I get the report monthly instead of weekly?

Yes. Tell WebRun your preferred cadence at setup and it will adjust the schedule accordingly. Monthly, weekly, or even daily reporting are all supported.

Put this on autopilot.

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