All templates
For IT admins, open source community managers & DevOps teams

Get a weekly Rocket.Chat workspace scorecard

Every Monday, WebRun opens the Rocket.Chat admin area, pulls last week's active user count and message volume per channel, logs the numbers into Google Sheets next to prior weeks, and emails the workspace admin a summary so workspace health is visible without digging through the admin panel.

  • No credit card
  • Under $0.01 per run
  • Cancel anytime
14,115 templates Safe automation No code
Every Monday at 9:00 AM WebRun
1 Rocket.Chat pull weekly usage data
2 Google Sheets log the weekly totals
3 Gmail email the scorecard
Run a sample
In short

How do I track Rocket.Chat workspace activity weekly?

WebRun opens the Rocket.Chat admin area every Monday, pulls last week's active user count and per-channel message totals, and logs them into a running Google Sheet. It then emails the workspace admin a short scorecard highlighting the busiest and quietest channels, so workspace health stays visible without digging through admin reports.

  • Workspace health is visible every Monday without checking admin panels
  • Usage trends build automatically week over week
  • Admins get one email instead of pulling reports manually

Built for IT admins · open source community managers · DevOps teams · workspace owners

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

  2. 1
    Rocket.Chat - pull weekly usage data
    rocket.chat
    WebRun in Rocket.Chat: pull weekly usage data
    WebRun opens Rocket.Chat to pull weekly usage data.
    • Open the Rocket.Chat admin area
    • Pull last week's active user count and per-channel message totals
    • Note the busiest and quietest channels

    Done when This week's usage data is captured from the admin area.

  3. 2
    Google Sheets - log the weekly totals
    google.com How to Automate Google Sheets
    WebRun in Google Sheets: log the weekly totals
    WebRun opens Google Sheets to log the weekly totals.
    • Open the workspace tracker sheet
    • Add this week's totals as a new row
    • Calculate the change from the week before

    Done when The tracker has this week's usage logged.

  4. 3
    Gmail - email the scorecard
    gmail.com How to Automate Gmail
    WebRun in Gmail: email the scorecard
    WebRun opens Gmail to email the scorecard.
    • Email the workspace admin this week's totals and the change
    • Call out the busiest and quietest channels
    • Keep it to one short summary email

    Done when The admin has this week's scorecard in their inbox.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.rocket.chat
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Weekly scorecard · Gmail
OutputWhat each run produces - A running weekly log of Rocket.Chat active users and channel message volume.
Sheet
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 WebRun change any Rocket.Chat settings?

No. It only reads usage numbers from the admin area. Changing workspace or channel settings stays a manual admin task.

What counts as workspace activity?

Weekly active users and the number of messages sent per channel, the same numbers already visible in the Rocket.Chat admin area.

Can I compare trends over several weeks?

Yes. Every Monday adds a new row to the same Google Sheet, so the history builds automatically for you to review.

Put this on autopilot.

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