How to automate weekly reports with AI agents (and keep the numbers honest)

How to automate weekly reports with AI agents: read-only access, numbers computed in code, a written why, and approval only for what leaves the building.