all hands presentations on autopilot

it’s endlessly fascinating what you can build with AI tooling nowadays, and just how much it forces you to rethink roles, responsibilities and tasks more broadly.

like most companies, we hold a monthly all hands/town hall meeting, where we all gather and talk through the current state of the business. metrics, wins, challenges, highlights, low-lights etc.

i found it increasingly crazy that our team would spend a few hours every month pulling data, refining the framing and putting it into a deck for the session. reinventing the wheel on a monthly basis, literally.

i’ve long thought that reporting-on-autopilot could surely be possible with AI. all the data and context exists, albeit across 4-5 various places and platforms.

so i built it. it’s a simple set of python scripts that pull data from a few sources (github, posthog, hubspot, slack and some custom metrics spreadsheets) and then uses some skills, a few templates, and importantly an LLM to turn this all into a simple set of outputs: a presentation (just an html file) and a document.

all of this happens in a few minutes and in my experience, does a really good job at scaffolding out 80-90% of what we’d put together anyway. it’s really cool and powerful, but also a glimpse into the future, i think.

the big takeaway, or the big idea on my mind right now is that, for so much knowledge work, the task is just coordination: shuffling data, numbers and information between systems, and distilling this into “context” that can be delivered to other people inside an organisation.

the big promise of AI is just to supercharge all of this coordination work.