Social Media Report Agent: Weekly Reporting on Autopilot
Duygu Ulutürk
Every Monday, someone on a marketing team loses an hour to the same job: open each social platform, copy the numbers into a sheet, compare with last week, write a summary, post it in Slack.
I built an AI agent that does this instead, for a marketing team I worked with.
What it does every Monday at 9:00
Pulls last week's data from Instagram, LinkedIn and X
Compares it with the week before
Spots the biggest changes
Writes a 30-second summary in plain language
Builds the visual report
Posts it to the team's Slack channel
Design decision: read-only
The agent only reads data, it never posts. That boundary is what made the team comfortable connecting it to live accounts.
What I learned
The weekly report is not where the insight is. The follow-up question is ("why did LinkedIn drop?"), so the report is designed to start that conversation, not replace it.
The demo below runs on a fictional brand with demo data.
Like this project
Posted Oct 20, 2026
An AI agent that pulls weekly social media data, compares it with last week, writes a plain-language summary, and posts a visual report to Slack. Read-only.
