I built an automated weekly report from team WhatsApp conversations.
Because the best technical solutions meet people where they are before asking them to change.
The media team had zero accountability mechanisms.
The team was exhausted, feeling like they were accomplishing heroic feats… while management asked every week (in an exasperated tone): "Where's the work?"
The team's answers came back weak and contradictory; nobody knew what was accomplished, what stalled, what was learned, or what was planned for next week.
Evidence of accomplishment was scattered across WhatsApp group chats, mixed in with side conversations, questions, photos, and sarcastic stickers (sound familiar?).
The Conventional Fix
- Ask the team for a weekly progress report
- Move work to a dedicated task management app (even if daily interaction stays on WhatsApp 😉)
But reality was simpler… and harsher:
- Weekly reports don't find a slot in an exhausted, overloaded team's time; they either come out weak or get forgotten entirely
- The organizational culture resists written periodic reports as pointless formalities
- Their use of WhatsApp isn't just tech resistance; it's a forced reality because most well-known apps were blocked in Syria, while WhatsApp was available on everyone's devices by default
Reframing the Question
So my question shifted from:
"How do I get them to change their tools?"
to:
"How do I build an accountability system on top of WhatsApp itself that creates an incentive to adopt and improve it later?"
We agreed on one dead-simple rule:
At the end of each workday, each person writes a short message in the group starting with "My daily report", in whatever format suits them:
What did I accomplish today? Any challenges?
My Interim Role
Every Friday evening I exported the group chat from WhatsApp and fed it into a small Python script I wrote, which automatically extracted all "daily reports" with their dates and authors.
That alone was useful… but the fun part started here:
I uploaded this table to Notion, which then:
- Analyzed the daily reports for the past week
- Populated a weekly report template (one page with a summary and quantitative/qualitative KPIs)
- Stored it in a dedicated weekly reports database
Then I screenshotted the weekly report and sent it back to the group.
The Result
Clarity + motivation + accountability.
At the end of each month, I ran another SOP via Notion AI:
- Reads the previous weekly reports
- Analyzes attached screenshots of Instagram and Facebook analytics
- Produces a comprehensive (and genuinely enjoyable) two-page monthly report, celebrating achievements and proposing solutions for recurring challenges
"That's barely automation…"
I know what you're thinking:
"Every step has a manual step before it."
True… this is just a phase in workflow evolution designed to demonstrate value without a major investment in change.
Then once the value is clear, we raise the investment:
Want full automation without complex tools? Let's move the work group to Telegram! The decision will be easier then… and we'll be able to automate the entire process 100%.
The Lesson
Tools come third… principles first, practices second.
Side note:
I also tried feeding raw WhatsApp chat text directly into AI to generate the weekly report, but quality and accuracy were lower because the content included the noise mentioned earlier and was sometimes extremely long. Verifying AI output wouldn't be practical that way either.