A visual walkthrough of how the agent works — from raw data to a board-ready report. No chatbot. No button pressing.
In Post #2, I explained the difference between a chatbot and an agent. Here I want to show you exactly what that difference looks like — not in theory, but in practice.
A chatbot waits. You have to open it, type a question, and interpret the answer yourself. An agent runs on its own. It pulls data, processes it, computes KPIs, writes a report, and delivers it — without anyone sitting in front of a screen.
"The question isn't whether AI can help with finance. It's whether you're buying a tool that makes one person faster — or building a system that makes a whole process disappear."
Below is the exact pipeline this agent runs. Every step. In order. Automatically.
Each card is color-coded: green = healthy, amber = watch, red = action needed.
May 2026 closed on a strong note. Revenue reached $285,000 — up 9.6% month-over-month — while gross margin expanded to 66.0%, reflecting disciplined cost management on the COGS side. The business is operating profitably with net income of $40,000, and cash reserves stand at $1.24M with no active burn rate to speak of.
The clearest improvement this month is operating leverage: at 2.4x, the business is growing revenue faster than it is growing costs. That is the dynamic you want to see at this stage. Operating expenses actually declined by $7,000 compared to April despite the revenue increase — that is not an accident, and it should be explicitly recognized in the board discussion.
Two risks warrant attention heading into June. First, days sales outstanding came in at 7 days — healthy in isolation, but the accounts receivable balance has tightened alongside it. If payment terms shift with any key customers, this metric can deteriorate quickly and will need to be watched weekly, not monthly. Second, the revenue growth rate of 9.6% is strong but was partially driven by a single large contract close. Organic baseline growth without that contribution is closer to 4%, which is below the trajectory needed to hit Q3 targets.
Recommendation: initiate a pipeline review for June with specific focus on whether the contract funnel supports sustained growth above 7% MoM. The margin and cost structure are healthy — the variable is entirely on the top line.
Connects to any system that exports CSV or has an API. Google Sheets works perfectly for getting started.
Google Sheets → CSV → Python
Google Gemini API for generating the narrative report. Free tier is sufficient for weekly reports.
gemini-2.0-flash
A GitHub Action triggers the agent every Monday morning. Free. No server needed. Runs in the cloud.
cron: '0 7 * * 1'
The report is emailed via Gmail SMTP or posted to a Slack channel. About 10 lines of code.
Gmail SMTP / Slack webhook
The full source code for this agent is on GitHub. Clone it, plug in your numbers, and run it — the README walks you through every step.
Post #3 covers the first agent I actually deployed — what it cost, what it replaced, and what it still can't do.
No spam. One post per week. Unsubscribe any time.