
Reporting as a PM
If you're a product manager, reporting probably eats more of your week than it should. And I feel, with all the hullabaloo around AI, Agentic AI or whatever, at least repetitive motions of a PM's job need to be automated.
Here's a plan that has worked for me when trying to automate reporting:
Centralise before you automate Most reporting pain comes from data living in 5 places. Before touching any automation tool, get everything flowing into one place: Airtable, Google Sheets, whatever you already use. Make.com or n8n handle the connections well.
Live dashboard over static reports Swap the weekly PDF for a shared Looker Studio that updates automatically. Stakeholders stop pinging you for one-off updates because the answer is always live.
Let AI write the summary Paste your weekly metrics into any LLM and ask it to write a 3-line summary in plain English. Saves 20-30 mins per report cycle.
Alerts over manual checks Set threshold alerts on your key metrics. You only look when something moves. Stops the habit of checking dashboards just to confirm nothing changed.
None of this requires a big overhaul. Start with one report you run every week and apply it there first.