Skip to content

Weekly KPI summary with number checks

Every Monday an agent writes the short management summary on supplier and delivery performance. It only sees data through read only tools, a control chart sets the traffic light, code checks every number and a person approves before it goes out.

OperationsWorks with n8n · LangGraph+1Community example
Build your promptSee requirements

What it does

  • Pulls last week's KPIs through a fixed set of read only tools
  • Sets red, yellow or green from control chart rules, not model opinion
  • Writes a summary under 180 words in a fixed format
  • Checks every number in the draft against the source data
  • Routes a failed check to the analyst instead of management

Your approval boundaries

Creates drafts

These actions always wait for your yes:

  • Approving the email to management
  • Any escalation to a supplier

You decide what happens next.

More about this workflow

This setup is for operators and managers who keep the busywork moving. It takes a repeat chore off your plate and hands back something you can check quickly.

First, it pulls last week's KPIs through a fixed set of read only tools. Next, it sets red, yellow or green from control chart rules, not model opinion. Then it writes a summary under 180 words in a fixed format. After that, it checks every number in the draft against the source data. Finally, it routes a failed check to the analyst instead of management. It works with your database, email and automation platform, each on its own login with limited access.

You get the prep work done and waiting for you. The agent stops and asks for your yes before approving the email to management and any escalation to a supplier, and says plainly if a step cannot be undone.

“the model only writes, and a person approves”
Mahsa93-lab Mahsa93-lab on GitHub · Oct 8, 2026
Before you startDatabase · Email accessScoped permissionsn8n or LangGraph
Explore required tools and model recommendations

Tools and access

  • Supabase

    Handles the database part of this job. Grant a role limited to one table.

    API required: Yes. Needs a Supabase project and an API key. Give the agent a role limited to one table.

    Sign up: Supabase

  • Gmail

    Handles the email part of this job. Grant read-only plus compose (drafts) scopes.

    API required: Yes. Needs a Google Cloud project with an OAuth app and the Gmail API turned on. The agent signs in through OAuth with only the scopes you pick.

    Sign up: Google Workspace

  • n8n

    Handles the automation platform part of this job. Grant create workflows, left inactive until reviewed.

    API required: Yes. Needs an n8n API key from settings. New workflows should stay inactive until you review them.

    Sign up: n8n

Official links only. Not sponsored, no affiliate links.

Model recommendations

Best pick

GPT-6.1 Sol

Cheap cached input suits jobs that rerun the same instructions each week.

$2 per million input tokens, $10 per million output tokens, for prompts up to 272K tokens. Longer prompts cost $4 in and $15 out.

OpenAI docs as of October 11, 2026

Cheaper backup

Gemini 3.5 Flash-Lite

Low cost for simple data pulls and matching.

$0.30 per million input tokens, $2.50 per million output tokens.

Google docs as of October 11, 2026

Our own picks. Not sponsored, no affiliate links.

Build your prompt

Add your details, then copy the prompt into your tool.

1Your details

Fill these in and the prompt updates as you type.

table or export

e.g. on time delivery, complaint rate

2Your prompt

4 of 4 still empty
Fill these in before you run it: [KPI SOURCE: table or export] [KPIS TO TRACK: e.g. on time delivery, complaint rate] [REPORT LANGUAGE AND LENGTH] [WHO APPROVES] You are the Weekly KPI summary with number checks agent. Every Monday an agent writes the short management summary on supplier and delivery performance. It only sees data through read only tools, a control chart sets the traffic light, code checks every number and a person approves before it goes out. Use only the details filled in above. If any [BRACKETED] item is still blank or unclear, stop and ask for it first. Do not guess. What you do on your own: - Pulls last week's KPIs through a fixed set of read only tools - Sets red, yellow or green from control chart rules, not model opinion - Writes a summary under 180 words in a fixed format - Checks every number in the draft against the source data - Routes a failed check to the analyst instead of management What you must never do without a yes from a person: - Approving the email to management - Any escalation to a supplier Rules: - Before any step on the list above, stop and ask. Say in plain words what you want to do, who it affects, and whether it can be undone. - If something cannot be undone, say so first, in one short line. - Write drafts, not final actions. A person sends, pays, posts, or deletes. - Keep a short log of every action you took and every source you read. - If you are unsure, ask instead of guessing.
View run instructionsPaste into: n8n, LangGraph, Make

Your answers stay in this browser only.

Run your workflow

Connect your tools with only the access this setup needs, then follow these steps.

Steps

Do these in order. Test on old data before it touches live work.

  1. 1Connect Supabase with its own login, not yours. Grant a role limited to one table.
  2. 2Connect Gmail with its own login, not yours. Grant read-only plus compose (drafts) scopes.
  3. 3Connect n8n with its own login, not yours. Grant create workflows, left inactive until reviewed.
  4. 4Paste the prompt where your harness takes instructions. See the note under the Copy button.
  5. 5Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
  6. 6Read its log after the first real run. Only widen access once a week of runs looks clean.

Safeguards and trust score

The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.

Access24 / 30

Writes drafts and notes inside your tools, nothing leaves on its own.

Human approval30 / 30

Waits for a yes on: approving the email to management, any escalation to a supplier.

Undo and logs17 / 20

Leaves drafts you can throw away, with a record of what it made.

Scope16 / 20

Runs on its own login across 3 tools. Fewer connections means a smaller blast radius.

How to raise it

  • Scope: Cut it down from 3 connected tools to the 2 it needs most, each with its own limited login instead of your full account +2

Do all of these to reach 89, up from 87.

Want help getting there? Get an AI Trust Audit from Pixeldesigns

Reviewed by Trustcase (example setup). How scoring works

Embed badge

Show this trust score on your site or README. It links back here.

Trustcase trust score badge
Markdown
[![Trustcase trust score for Weekly KPI summary with number checks](https://trustcase.dev/badge/weekly-kpi-summary-with-number-checks.svg)](https://trustcase.dev/use-cases/weekly-kpi-summary-with-number-checks)
HTML
<a href="https://trustcase.dev/use-cases/weekly-kpi-summary-with-number-checks"><img src="https://trustcase.dev/badge/weekly-kpi-summary-with-number-checks.svg" alt="Trustcase trust score for Weekly KPI summary with number checks" height="20"></a>

More operations workflows

  • Founder morning stats and follow up brief

    A scheduled agent with your tools connected sends a morning brief: yesterday's numbers, what happened in the product and today's action items. It remembers what you said you would do and follows up.

  • Invoice inbox

    Reads bills that land in email and gets them ready to pay.

  • Weekly ops report

    Writes the Monday numbers summary so you do not build it by hand.

  • Vendor quote compare

    Lines up quotes from several vendors side by side.