All templates

Automated Rows Weekly Metric Scorecard

Every Friday, WebRun opens your Rows spreadsheet, reads this week's key metrics, compares each to last week's value, posts a scorecard to Telegram ordered by the biggest moves, and texts the owner one headline number through Twilio.

Runs on WebRun · Strict Lockdown policy
Every Friday at 4:00 PM WebRunorchestrates each step
1 Rows read key metrics
2 Telegram post the weekly scorecard
3 Twilio text the headline number
In short

How do I get a weekly scorecard from my Rows spreadsheet?

WebRun reads your Rows spreadsheet every Friday, compares this week's key metrics against last week's, and posts a scorecard to Telegram ordered by the biggest moves. It also texts the owner one headline number through Twilio, so the team gets the full picture and the owner gets the single number that matters most.

  • The team sees week-over-week movement at a glance
  • The owner gets one headline number without opening a spreadsheet
  • Missing data is never shown as a false zero

Built for Founders tracking weekly KPIs · operators using Rows for live dashboards · small teams without a BI tool

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

  2. 1
    Rows - read key metrics
    rows.com
    WebRun in Rows: read key metrics
    WebRun opens Rows to read key metrics.
    • Open the Rows spreadsheet and read this week's key metrics
    • Compare each metric to last week's value
    • Note which metrics moved the most, up or down

    Done when This week's metrics and their change from last week are captured.

  3. 2
    Telegram - post the weekly scorecard
    telegram.org
    WebRun in Telegram: post the weekly scorecard
    WebRun opens Telegram to post the weekly scorecard.
    • Post the weekly scorecard with each metric and its change
    • Order it so the biggest moves are at the top
    • Keep the format consistent so it is easy to scan week to week

    Done when The team channel has this week's scorecard.

  4. 3
    Twilio - text the headline number
    twilio.com
    WebRun in Twilio: text the headline number
    WebRun opens Twilio to text the headline number.
    • Text the owner the single headline number for the week
    • Keep it to one line: the metric and its value
    • Send it only after the full scorecard has posted to Telegram

    Done when The owner has been texted this week's headline number.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
rows.com
ScheduleRuns automatically on this cadence
Every Friday at 4:00 PM
DeliveryHow each run's result reaches you
Weekly scorecard · Telegram
OutputWhat each run produces - A weekly scorecard of key metrics with week-over-week change, plus a one-line headline text.
Report
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 it text the owner every single metric?

No. The full scorecard goes to Telegram. The text is just one headline number, kept short on purpose.

Where do the metrics come from?

Whatever is already live in your Rows spreadsheet, since Rows pulls in real data through its built-in connections. WebRun just reads what is there.

What if a metric is missing for the week?

It is left out of the comparison rather than shown as a false zero, so the scorecard never misrepresents a gap in the data.

Put this on autopilot.

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