Ofsted Signal Pipeline

In November 2025 Ofsted began publishing per-category inspection grades — including “Inclusion”, precisely what Cognassist sells into. Overnight the government started publishing a free, per-provider buying-intent signal, forever. But it ships as PDFs on a paginated site with no API: to use it you'd have to spot each new report, work out which legal entity it's about, pull three grades out of a PDF, match it to the CRM, qualify the provider, write a usable note, and judge whether it warrants a call — daily, across ~400 providers. A part-time job nobody had, and the signal decays to history in about six weeks.

Built a fully unattended pipeline that runs once a day on one machine and writes live to Capsule CRM with no human in the loop. The design bet: split the work by kind — deterministic Python for anything where a wrong answer corrupts data (identity resolution, grade extraction, CRM matching, all writes), an LLM agent for the reading and judgement (qualification, note-writing, signal-flagging). The agent orchestrates the scripts; it never re-implements them. Every column of the single 43-field dataset doubles as an idempotency key, so any stage re-runs safely. ~4,100 lines of Python, four dependencies, one CSV — no database.

Every morning it posts plain-English inspection summaries and outreach tasks straight into the CRM, and republishes one bookmarkable digest page. To date: 414 reports processed, UKPRNs resolved for 98.5%, 249 summary notes and 38 tasks written to Capsule. The commercial core is 38 named providers each carrying a public government document that says they're weak on exactly what Cognassist solves — already in the CRM, graded, with a task on someone's list.