All templates

Automated Weekly Catering Bookings Report

Every Monday morning, WebRun opens Total Party Planner, pulls all bookings and revenue from the previous week, logs the data to a Google Sheets dashboard, and posts a clean summary to your management Slack channel.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Total Party Planner pull last week's bookings and revenue
2 Google Sheets log data to the weekly dashboard
3 Slack post the weekly digest to management
In short

How do I automatically get a weekly catering bookings and revenue report?

WebRun opens Total Party Planner every Monday morning and pulls the previous week's confirmed bookings, total contract value, and deposit income. It logs the data to your Google Sheets dashboard and posts a concise weekly digest to your management Slack channel, so your team starts the week with a clear revenue picture.

  • Management starts every Monday with a clear weekly bookings and revenue summary
  • Google Sheets dashboard builds a running history for trend analysis
  • No manual data pulling or spreadsheet wrangling needed each week

Built for catering owners · catering managers · catering sales directors

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

  2. 1
    Total Party Planner - pull last week's bookings and revenue
    totalpartyplanner.com
    WebRun in Total Party Planner: pull last week's bookings and revenue
    WebRun opens Total Party Planner to pull last week's bookings and revenue.
    • Open Total Party Planner and filter confirmed bookings by the previous week's date range
    • Capture total events booked, total contract value, deposit income received, and events by category
    • Note any large new bookings or notable cancellations for the digest

    Done when Last week's booking totals and revenue figures are captured and ready for reporting.

  3. 2
    Google Sheets - log data to the weekly dashboard
    google.com
    WebRun in Google Sheets: log data to the weekly dashboard
    WebRun opens Google Sheets to log data to the weekly dashboard.
    • Open the weekly bookings dashboard in Google Sheets
    • Add a new row for the week with events booked, total contract value, deposits received, and category breakdown
    • Update any running charts or totals automatically

    Done when The Google Sheets dashboard is updated with last week's figures.

  4. 3
    Slack - post the weekly digest to management
    slack.com
    WebRun in Slack: post the weekly digest to management
    WebRun opens Slack to post the weekly digest to management.
    • Post a concise weekly digest to the management Slack channel
    • Include total events, total revenue, deposits received, and a comparison to the previous week
    • Link to the full Google Sheets dashboard for deeper analysis

    Done when The management team has this week's bookings digest in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.totalpartyplanner.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Weekly digest · Slack
OutputWhat each run produces - A Slack digest of last week's bookings and revenue with a Google Sheets dashboard updated for historical tracking.
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 report go to external parties or only to internal Slack?

It only posts to your internal Slack management channel. No booking or revenue data is shared outside your team.

Can it break bookings down by event type or sales rep?

Yes. You configure the groupings you want during setup, such as corporate versus wedding, or by sales rep, and WebRun includes those breakdowns in each week's digest.

What if Total Party Planner had no bookings last week?

It still posts a digest confirming zero new bookings so the management team always gets Monday's report, even in a quiet week.

Put this on autopilot.

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