All templates

Build Your Weekly KPI Roll-Up

Every Monday, WebRun reads last week's numbers from your tracking spreadsheet, updates the KPI dashboard in Notion with the latest values and trends, and posts a one-page summary to Slack so your leadership team sees the week's picture instantly.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every Monday at 7:00 AM WebRunorchestrates each step
1 Google Sheets read last week's raw metrics
2 Notion update the KPI dashboard
3 Slack share the weekly summary
In short

How can I automatically build a weekly KPI roll-up from multiple tools?

WebRun builds your weekly KPI roll-up every Monday so leadership starts the week with a clear picture. It reads last week's numbers from your tracking spreadsheet, updates the KPI dashboard in Notion with the latest values and trends, and posts a one-page summary to Slack — no manual pulling or copy-pasting required.

  • Weekly KPI summary delivered to Slack before Monday morning meetings
  • Notion dashboard updated with trends, not just raw numbers
  • No manual number-pulling from multiple tools

Built for operations leaders · department heads · startup founders · business analysts

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

  2. 1
    Google Sheets — read last week's raw metrics
    google.com
    WebRun in Google Sheets: read last week's raw metrics
    WebRun opens Google Sheets to read last week's raw metrics.
    • Open the metrics master sheet and filter to the previous week's rows
    • Extract the key KPIs: revenue, open tasks, tickets resolved, headcount utilisation, and any custom metrics you track
    • Calculate week-over-week change for each metric

    Done when All KPIs for last week are captured with their prior-week comparison.

  3. 2
    Notion — update the KPI dashboard
    notion.so
    WebRun in Notion: update the KPI dashboard
    WebRun opens Notion to update the KPI dashboard.
    • Open the KPI Dashboard page in Notion
    • Update each metric block with the new value and the percentage change
    • Add a brief narrative note in the Weekly Commentary section if any metric moved by more than 10%

    Done when The Notion KPI dashboard reflects last week's numbers with trends highlighted.

  4. 3
    Slack — share the weekly summary
    slack.com
    WebRun in Slack: share the weekly summary
    WebRun opens Slack to share the weekly summary.
    • Post a one-page summary to #leadership with this week's headline numbers and any significant movements
    • Include a link to the full Notion dashboard for detail

    Done when Leadership has the weekly KPI summary in Slack with a link to the full dashboard.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
docs.google.com/spreadsheets
ScheduleRuns automatically on this cadence
Every Monday at 7:00 AM
DeliveryHow each run's result reaches you
KPI summary · Slack
OutputWhat each run produces — A weekly KPI summary with all headline metrics, week-over-week changes, and a link to the full Notion dashboard.
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 if a metric is missing from the sheet this week?

WebRun flags it in the summary as 'data not yet available' so you know to investigate, rather than silently posting a zero.

Can it pull from more than one spreadsheet?

Yes — give WebRun the list of sheets and which column holds which KPI, and it will consolidate them all into one dashboard.

Does it overwrite my Notion dashboard?

It updates only the metric values and adds a weekly commentary note. Your page layout, context, and historical entries are never deleted.

Keep going

Related templates

Triage Your Shared Inbox & Draft Replies
WebRun reads every new message in your shared inbox, labels it by type, and drafts a reply for your team to review before anything is sent.
Gmail›Google Sheets›Slack
Copy Form Responses to Your Tracker
Every time someone submits a form, WebRun captures the response, adds a structured row to your tracker, and notifies the right person.
Google Sheets›Airtable›Slack
Prep a Meeting Brief Before Every Call
Before each meeting, WebRun pulls together the attendees, agenda, past notes, and open tasks so you walk in ready.
Google Calendar›Notion›Slack

Put this on autopilot.

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

Deploy this workflow Talk to us