Close the month with a clear membership health report
On the first of every month, WebRun opens Rock Gym Pro, pulls the full membership dataset for the prior month, calculates new members, cancellations, net growth, active membership count, and monthly recurring revenue, logs the results in a Google Sheet for historical tracking, and posts a membership health summary to the management team's Slack channel.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically generate a monthly membership report for my climbing gym?
On the first of every month, WebRun pulls the previous month's membership data from Rock Gym Pro, calculates new joins, cancellations, net growth, total active members, and monthly recurring revenue by tier, logs everything in a Google Sheet for historical tracking, and posts a concise health summary to the management team's Slack channel before the workday begins.
- Management start the first of every month with a complete membership health picture in Slack
- A running Google Sheets history built automatically, with no manual data entry
- Tier-level breakdown shows which membership plans are growing and which need attention
Built for climbing gym owners · gym managers · finance teams · operations leads
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.rockgympro.comin a real browser with your saved login - no setup, no API keys. -
1
Rock Gym Pro - pull monthly membership metrics
rockgympro.com How to Automate Rock Gym Pro
WebRun opens Rock Gym Pro to pull monthly membership metrics. - Open Rock Gym Pro and navigate to the Reporting and Analytics section
- Pull membership data for the previous calendar month
- Calculate new members joined, cancellations, net membership growth, total active members, and monthly recurring revenue by tier
- Note the top membership tier by volume and any tier with a net loss for the month
Done when All key membership metrics for the previous month are compiled and ready to log.
-
2
Google Sheets - log metrics to historical tracker
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log metrics to historical tracker. - Open the gym's monthly membership tracker in Google Sheets
- Append a new row for the previous month with all calculated metrics
- The sheet provides a running month-over-month history without any manual data entry
Done when The previous month's metrics are logged as a new row in the Google Sheets tracker.
-
3
Slack - post monthly membership health summary
slack.com How to Automate Slack
WebRun opens Slack to post monthly membership health summary. - Post a membership health summary to the management team's Slack channel
- Include new joins, cancellations, net growth, total active members, and MRR for the previous month
- Add a month-over-month comparison for each metric and a link to the Google Sheets tracker
Done when Management have the previous month's membership health report in Slack with a link to the full historical sheet.
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 it post the report automatically on the first of the month?
Yes. WebRun runs automatically on the first of every month at 8 AM and posts the report to Slack. No manual trigger is needed and no staff action is required to generate the report.
Where does the historical membership data get stored?
Each month's metrics are appended as a new row in a Google Sheet you designate, building a running month-over-month history that management can review at any time.
What if the gym has multiple membership tiers?
WebRun pulls data by tier from Rock Gym Pro, so the report breaks down new joins, cancellations, and revenue for each tier, making it easy to see which plans are growing and which are shrinking.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.