Weekly metrics report agent: Weekly Report Number Check (free sample)

What you end up with

A Monday report where every number matches the table and every gap is said out loud.

What you get

• This week, last week, change, percent change and a 4-week average for every column, done in code
• Named gaps for blank or unreadable cells and missing weeks, never a silent zero
• Five report checks: numbers not in the table, wrong up or down, causes stated as fact, unmentioned gaps, placeholders
• Rounding allowed: $3,395.40 can read $3,395
• Your yes at your own terminal, refused in agent sessions, and a gate that says NO-GO if the report changed
• AGENTS.md, CLAUDE.md, a Grok Bot standing order, a Hermes skill and 22 tests

Who it is for

Owners and small teams who keep their weekly numbers in a sheet and want an agent to write the Monday summary without it inventing a figure or a reason.

Works with

Solid chips: the agent is named in this listing's own tools list. Dashed chip: One Python script, templates, a made-up candle shop's six weeks and agent rules for each harness. Tested on Linux.

Tools needed

Cost to run: Free. Python is free.
Time to result: About five minutes

How it works

1. Run the example

   Unpack the file and, inside example/, run python3 ../report_check.py table sheet.csv table.json.

   Expected: Revenue down 8.7% and one named gap: last week's site visits.

2. Add your numbers

   Copy templates/, put one row per week in sheet.csv with the Monday as week_start, and your name in settings.json.

   Expected: A table and any gaps, named.

3. Let the agent write

   Give it AGENTS.md. It writes drafts/report.md from table.json only and checks it.

   Expected: REPORT PASS, nothing sent.

4. Approve and send yourself

   Run python3 report_check.py approve settings.json drafts/report.md table.json, type send, then send it yourself.

   Expected: gate says GO until the report changes.

Sample prompt from the pack

Follow AGENTS.md. Run report_check.py table on sheet.csv, write drafts/report.md in five to eight lines using only numbers from table.json, name every gap, give any reason only as a possibility, and run report_check.py check until it passes.
Show me the report, then stop. Never approve, send or post it.

Free preview of the file

# Weekly Report Number Check

**A weekly report is only worth reading if every number in it is right. This free sample does the week-over-week math in code from the sheet you already keep, then holds any report that quotes a number the table doesn't have, says up when it went down, or states a guess as the reason. Your agent writes; you approve and send.**

Version 1.0, 2026-11-04. By PaperChaseWebb Inc. Free sample of Get a weekly metrics report written by an agent ($39). Works with Grok Bot, Claude Code, Codex and Hermes, or by hand. Python 3.8 or newer, no installs. Reads a CSV export from Excel, Google Sheets or Numbers.

## What you get out of it

- This week, last week, change, percent change and a 4-week average for every column, done in code. No percent when last week was zero, no zero where a cell was blank.
- Named gaps: blank or unreadable cells, and whole weeks missing from the sheet, listed instead of skipped.
- Five checks on the report: a number not in the table, up or down said wrong, a cause stated as fact, a gap the report never mentions, and leftover placeholders.
- Rounding that is allowed, not flagged: $3,395.40 can read $3,395.
- An owner yes, recorded at your own terminal, tied to the report as it reads. Change one word and the gate says NO-GO.

## Who it is for

Owners and small teams who keep their weekly numbers in a sheet and want an agent to write the Monday summary, without it inventing a figure or a reason.

## Set up (5 minutes)

1. Copy `extrac

Worth knowing

• The sample works from a sheet you keep by hand. The Stripe and analytics collectors, refunds and currencies, time zones, the scheduled job and Slack delivery are in the full agent.
• On 2026-11-04: 22 tests passed on Python 3.8, 3.9, 3.11, 3.12 and 3.13 on Linux, run from the files unpacked out of the sample. Agent rules guide; they were not loaded inside each harness for this release.

Details

Version 1.0 · Updated Nov 4, 2026 · Markdown version of this page
License: Personal and commercial use. Download terms

Related

Agent use case pack$39

Get a weekly metrics report written by an agent from Stripe, analytics and a sheet

by PaperChaseWebb

Build a scheduled job that pulls revenue, traffic and your own sheet numbers, computes week over week changes in code, has an agent write a short report, checks every number against the table and sends it only after your yes.

Works withClaude CodeCodexGrok BotHermesPlain .md and Node files. The agent version in section 11 is written for any agent that can read files and run commands in a folder; it was not run inside each tool

Solo business · Advanced · 1 hr 30 min setup

Bot templateFree

Gmail inbox triage bot: Inbox Sort and Draft Check (free sample)

by PaperChaseWebb

From the Gmail inbox triage bot: sort an inbox export into Needs reply, Needs review, Receipts, Newsletters and FYI, keep private senders away from any model, and stop every reply draft that adds a price, a day or a link the thread never gave. Your agent drafts; your yes is recorded at your own terminal and the gate stops any draft changed after it.

Works withClaude CodeCodexGrok BotHermesOne Python script, templates, a made-up design studio inbox of nine threads and agent rules for each harness. Tested on Linux

Solo business · Beginner · 5 min setup

Agent use case packFree

Turn a spreadsheet into a web app: Sheet Readiness Check (free sample)

by PaperChaseWebb

From the spreadsheet to web app playbook: find what in your sheet will break an app before anyone builds one. A key column with a blank or a repeat, dates that read two ways, one status spelled three ways, words in a money column, two things in one cell and formula errors, each with its row number. Then check the columns-to-fields worksheet; your yes is recorded at your own terminal and the gate stops any worksheet changed after it.

Works withClaude CodeCodexGrok BotHermesOne Python script, templates, a made-up window cleaning company's job sheet and agent rules for each harness. Tested on Linux

Vibe coding · Beginner · 5 min setup