Safety packs from one row of a sheet

The contractor fits out bank branches for tier-one UK banks, among other work. Every site gets its own RAMS pack. The details for each site were already in a project sheet, and the teams copied them into the pack by hand.

Every pack is marked DRAFT, not for issue, until the contractor names a competent person to approve it, and that approval step is not built yet.

In November 2025 I went through the documents the teams produce and ranked twelve things to automate. RAMS packs, site posters and weekly reports made the first group, high impact and low complexity, and RAMS came first, with the data already in the sheet. Operations manuals and legal documents were near the end of the list.

A tick on a row of the sheet sends one webhook. The generator assembles the pack from a library of the contractor’s own approved content: 12 risk assessments, 12 method statements and about 20 policy and compliance sections. It adds the site’s details, a contents page, and the nearest A&E, fire station and police station. Word and PDF come from the same section model, so the two match. A repeated webhook is dropped, and each job writes a document record and an audit log row.

The first version used a language model to draft the method statements. In July 2026 I replaced it with the contractor’s own approved wording, because the packs carry the banks’ site details. No model call is now in the path that makes a pack.

The contractor generated two packs themselves from the demo, on 31 July and 4 August 2026, from rows they entered for two of their sites: 63 pages each, DRAFT throughout.

Checking those packs against the contractor’s own, I found the hospital lookup had named a minor injuries unit for one site, where their own pack for that site named a major A&E. On 6 August I changed the lookup so that a unit known to have no A&E is never named, even when the map marks it as one.

Next for the same contractor, agreed but not yet built: an intranet hub and a filing service in their own Microsoft tenant.