Weekly client report generator
The reporting job most agencies do by hand every week, done once and then never again. Connect your data sources, edit the template to match your brand, and let it run. What it does: • Pulls metrics from Google Analytics, Google Sheets or any CSV you drop in a folder • Renders a branded HTML report — your logo, your colours, your section order • Exports to PDF and emails each client their own report, from your own address • Compares against the previous period automatically, so every number has context • Skips clients with no new data instead of sending an empty report Perfect for: • Agencies sending the same shaped report to five or fifty clients • Freelancers who want to look organised without buying reporting software • Anyone rebuilding the same slide deck every Monday morning
What you need
Python 3.10 or newer. An SMTP account for sending (any provider — the guide uses a generic setup). Google connectors need a service-account JSON, which the guide walks through; skip them entirely if you only use CSVs.