DEVOPS

Monthly DORA leadership brief with AI narrative to Notion

On the first of each month, pulls the prior month's per-team DORA aggregates from BigQuery, has an LLM write a plain-English trend narrative.

CategoryDevOps
EngineSim + Paperclip
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonthly schedule (1st of month)
  • ActionQuery prior-month DORA aggregates from BigQueryGoogle BigQueryBigQuery
  • ActionDraft trend narrative with LLMOpenAI
  • LogicAssemble narrative + tables into Notion blocks
  • OutputPublish brief as Notion pageNotionNotion

What it does

Generates the monthly delivery-performance brief leadership actually reads. It collects the previous month's deploy frequency and lead-time aggregates per team from BigQuery, asks an LLM to interpret the trends and call out movers and risks in clear prose, and publishes the result as a structured Notion page.

When to use it

Use this when raw DORA tables aren't landing with non-engineering stakeholders and you need a recurring narrative summary with context, not just charts. Pairs well with the daily scorecard workflow that feeds the BigQuery table.

How it works

  1. 1A monthly schedule trigger fires on the first of the month.
  2. 2Query the prior month's per-team DORA aggregates and month-over-month deltas from BigQuery.
  3. 3Action sends the structured metrics to an LLM to draft a trend narrative with highlights and concerns.
  4. 4Logic step assembles the narrative plus metric tables into a Notion block structure.
  5. 5Output creates the Notion page in the leadership workspace.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect NotionPages, databases, comments.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    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.