All templates

Automated Chargebee MRR Movement Digest

Every Monday morning, WebRun opens Chargebee, pulls the week's subscription changes, calculates new MRR, expansion, contraction, and churned MRR, logs the movements in a Google Sheet, and posts a concise digest to your Slack billing channel so leadership has the full picture before standup.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Chargebee pull subscription changes and MRR data
2 Google Sheets log MRR movements in tracker
3 Slack post weekly digest to billing channel
In short

How do I get an automatic weekly MRR movement report from Chargebee?

Every Monday, WebRun pulls the past week's subscription changes from Chargebee, categorizes them into new, expansion, contraction, and churned MRR, logs the movements in a Google Sheet, and posts a clean digest to Slack. Your leadership team has the full revenue picture before the morning standup.

  • Leadership gets a clear MRR breakdown every Monday before standup
  • Expansion and churn movements are tracked automatically each week
  • A running Google Sheet log makes board-level reporting easy

Built for SaaS founders · finance teams · revenue operations · subscription businesses

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

  2. 1
    Chargebee - pull subscription changes and MRR data
    chargebee.com
    WebRun in Chargebee: pull subscription changes and MRR data
    WebRun opens Chargebee to pull subscription changes and MRR data.
    • Open Chargebee and pull all subscription events from the past 7 days
    • Categorize each event as new MRR, expansion, contraction, or churn
    • Calculate net MRR change and cumulative MRR for the period
    • Note the top 3 gains and top 3 losses by MRR impact

    Done when All MRR movements for the past week are categorized and totaled.

  3. 2
    Google Sheets - log MRR movements in tracker
    google.com
    WebRun in Google Sheets: log MRR movements in tracker
    WebRun opens Google Sheets to log MRR movements in tracker.
    • Open the MRR tracker sheet and append a row for this week's summary
    • Record new MRR, expansion MRR, contraction MRR, churned MRR, and net movement
    • Update the running totals column so the trend is visible over time

    Done when This week's MRR data is logged in the tracker sheet with running totals.

  4. 3
    Slack - post weekly digest to billing channel
    slack.com
    WebRun in Slack: post weekly digest to billing channel
    WebRun opens Slack to post weekly digest to billing channel.
    • Post the weekly MRR digest to the billing or leadership Slack channel
    • Lead with net MRR movement, then break down each category with amounts
    • Call out the biggest single expansion and the biggest single churn
    • Include a link to the Google Sheet for the full breakdown

    Done when The MRR digest is live in Slack before the Monday standup.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.chargebee.com/login
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
MRR digest · Slack
OutputWhat each run produces - A Slack MRR digest with new, expansion, contraction, and churn breakdown, plus a running Google Sheet log.
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

What MRR categories does it track?

It tracks four standard categories from Chargebee: new MRR (brand-new subscriptions), expansion MRR (upgrades and add-ons), contraction MRR (downgrades), and churned MRR (cancellations), plus the net movement total.

Does it post to Slack automatically without approval?

Yes. The MRR digest is an internal summary posted directly to your Slack channel. No customer-facing action is taken, so human approval is not required.

Can I see historical trends over time?

Every week's data is appended to the Google Sheet with running totals, so you can track MRR trends over months and export for board reporting at any time.

Put this on autopilot.

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