All templates

Automated Qlik KPI Scorecard

Every Monday, WebRun opens your core Qlik app, pulls last week's KPI values against target and the prior week, logs each one to Airtable for history, and emails the team a short summary that leads with anything off target.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Qlik pull key app metrics
2 Airtable log historical values
3 Gmail email the summary
In short

How do I get a weekly email summary of my Qlik KPIs?

WebRun pulls key KPI values from your core Qlik app every Monday, logs each one with its target and week-over-week change to Airtable, and emails the team a short summary that leads with anything off target. It turns a Qlik app nobody opens between meetings into a standing weekly record.

  • The team gets a KPI summary every Monday without opening Qlik
  • Off-target KPIs lead the email instead of getting buried
  • Historical values accumulate automatically for trend charting

Built for business intelligence teams · data analysts · operations managers · leadership teams

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

  2. 1
    Qlik - pull key app metrics
    qlik.com
    WebRun in Qlik: pull key app metrics
    WebRun opens Qlik to pull key app metrics.
    • Open the core Qlik app and pull last week's KPI values
    • Compare each KPI to its target and the prior week
    • Note any KPI that's off target

    Done when Every tracked KPI has last week's value pulled and compared.

  3. 2
    Airtable - log historical values
    airtable.com
    WebRun in Airtable: log historical values
    WebRun opens Airtable to log historical values.
    • Log a row for each KPI with its value, target, and week-over-week change
    • Keep history so trends are easy to chart later

    Done when The tracker has this week's row for every KPI.

  4. 3
    Gmail - email the summary
    gmail.com
    WebRun in Gmail: email the summary
    WebRun uses Gmail to email the summary.
    • Email the team a short summary of the week's KPIs
    • Lead with anything off target

    Done when The team 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
qlik.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
KPI scorecard · Gmail
OutputWhat each run produces - A weekly scorecard of KPI values against target, logged to Airtable and emailed to the team.
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

Will it change the Qlik app or a chart on its own?

No. WebRun only reads and reports the KPI values. Editing the app, a chart, or the underlying data model is left to a human.

How does it decide a KPI is off target?

It compares each KPI's value against the target you've set for it, so the summary reflects your own goals, not a generic benchmark.

Where does the historical data live?

Every week's values are logged to Airtable, so you can chart trends over time without re-pulling data from Qlik.

Put this on autopilot.

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