Weekly Instagram performance digest in Slack

Every Monday at 9:00am in my local timezone, run a weekly Instagram performance digest and post it into a Slack channel I will choose. Trigger is a cron schedule.

Step 1. Pull the account-level roll-up for the last 7 days using Instagram Get Account Insights. I want reach, impressions, profile views, and follower growth for the trailing 7 days, plus the same 7-day window from the prior week so we can compute week-over-week deltas.

Step 2. Use Instagram List Media to enumerate every post, reel, and carousel I published in the last 7 days. For each one, call Instagram Get Media Insights to fetch per-post metrics: reach, likes, saves, shares, and plays (for reels). Also capture the media type, caption, permalink, and thumbnail URL so we can link back to the post in Slack.

Step 3. Have the agent synthesize the numbers into a written brief. The brief should include: (a) a headline paragraph with this-week vs last-week deltas on reach, impressions, profile views, and follower growth (with arrows and percentages); (b) the top 3 posts of the week ranked by engagement rate (saves + shares + comments + likes divided by reach), each with a one-sentence 'why it worked' analysis grounded in the actual numbers and caption; (c) the worst 1 to 2 posts with a candid one-sentence diagnosis of why they underperformed; (d) 2 to 3 concrete content bets to try next week, phrased as actual ideas ("try a carousel breaking down last week's launch") not platitudes.

Step 4. Deliver the brief to Slack using Slack Bot Send a Message. Format the message with Slack mrkdwn: use *bold* for section headers, bulleted lists for the top and worst posts, and inline links back to each highlighted post using the permalink from Instagram (<permalink|caption snippet>). If any highlighted post has a thumbnail, unfurl or reference it so the message is scannable at a glance. The recipient channel should be a workflow input the user picks at connect time.

Notes for the agent: Only Instagram Business or Creator accounts expose insights, so surface a clean error if the connected account is personal. If there were zero posts in the last 7 days, still send the digest with the account-level numbers, note the empty publishing week, and pull content bets from the prior 2 to 3 weeks instead. Keep the tone crisp and analytical, not hype. Never invent numbers; if a metric is missing from the API response for a given media type (e.g. no 'plays' on a static image), just omit it for that post.