DEVOPS

Monthly DORA Executive Report to Notion

On the first of each month, compiles every team's deploy frequency and lead-time trend from the BigQuery scorecard and publishes a formatted month-over-month executive report…

CategoryDevOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerFirst-of-month schedule
  • ActionQuery last two months of scorecard rowsGoogle BigQueryBigQuery
  • LogicCompute month-over-month deltas and trend class
  • LogicRender report body with summary table
  • OutputPublish dated report page to NotionNotionNotion

What it does

This builds a human-readable monthly DORA summary for leadership. It reads the accumulated warehouse scorecard, computes month-over-month deltas per team, and writes a clean narrative report into a Notion database.

When to use it

Use it when engineering leaders want a recurring, no-effort delivery-health briefing they can read in Notion — pairing the raw warehouse numbers with plain-language trend callouts and improvement flags.

How it works

  1. 1A first-of-month schedule triggers the run.
  2. 2An action queries the BigQuery `dora_team_scorecard` table for the last two months of per-team rows.
  3. 3A compute step calculates each team's deploy-frequency and lead-time change versus the prior month and classifies the direction as improving, flat, or regressing.
  4. 4A formatting step assembles a report body with a summary table and one bullet per team highlighting the biggest mover.
  5. 5The output step creates a dated page in the Notion DORA reports database with the rendered summary, ready to share with stakeholders.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  4. 4
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  5. 5
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.