All templates

Automated Opsgenie On Call Load Scorecard

Every Monday, WebRun opens Opsgenie, compiles the past week's alert count, average response time, and which teammates covered each on call shift, logs the numbers as a new row in Google Sheets so the trend builds over time, and emails the ops lead a short summary highlighting anyone whose on call load was well above the team average.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Opsgenie compile the week's alert and on call data
2 Google Sheets log it to a sheet
3 Gmail email the ops lead a summary
In short

How do I track my team's weekly on call load in Opsgenie?

WebRun compiles your team's Opsgenie alert count, response time, and on call coverage every Monday, logging the numbers to a Google Sheets tracker so the trend builds over time. It emails the ops lead a summary highlighting anyone whose on call load was well above average, so an uneven rotation gets noticed before it causes burnout.

  • Uneven on call load gets flagged before it causes burnout
  • Alert response times are tracked automatically week over week
  • The ops lead gets a summary without pulling reports by hand

Built for SRE teams · ops leads · platform teams · engineering managers

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

  2. 1
    Opsgenie - compile the week's alert and on call data
    • Open Opsgenie and pull the past week's alert count and average response time
    • Record who covered each on call shift
    • Note anyone whose alert load was well above the team average

    Done when The week's alert count, response time, and on call coverage are captured.

  3. 2
    Google Sheets - log it to a sheet
    google.com
    WebRun in Google Sheets: log it to a sheet
    WebRun opens Google Sheets to log it to a sheet.
    • Log this week's alert count, response time, and coverage as a new row
    • Flag anyone whose alert load was well above average
    • Keep prior weeks in place so the trend is visible

    Done when This week's numbers are logged as a new row in the sheet.

  4. 3
    Gmail - email the ops lead a summary
    gmail.com
    WebRun in Gmail: email the ops lead a summary
    WebRun opens Gmail to email the ops lead a summary.
    • Draft a short internal summary email to the ops lead
    • Highlight anyone whose on call load was well above the team average
    • Send it to the ops lead only

    Done when The ops lead has this week's on call summary email.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.opsgenie.com/login
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
On call scorecard · Gmail
OutputWhat each run produces - A weekly on call scorecard with alert counts, response times, and coverage, logged to Sheets and emailed to the ops lead.
Scorecard
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 on call schedule?

No. WebRun only reports what already happened. Changing a schedule or rotation is always your ops lead's decision in Opsgenie.

Who sees the summary email?

Only the ops lead, by email. It's an internal load report, not shared with the whole team by default.

Why track who covered which shift?

So an uneven on call load becomes visible early, before it turns into burnout for whoever's been carrying more than their share.

Put this on autopilot.

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