Weekly competitor Instagram and TikTok digest in Slack

Build me an agent-based workflow that runs every Monday at 9am (my local time) and posts a competitor social media digest to my Slack channel #marketing-intel.

Inputs and sources:

1) Read my competitor list from Google Sheets. The sheet has one row per competitor with two columns: handle and platform. Platform is either "instagram" or "tiktok". Use the Get Values operation on Google Sheets to pull the list at the start of every run so adding or removing competitors is just a sheet edit. Make the spreadsheet ID, sheet/tab name, and range configurable; default the range to the full data range starting at row 2.

2) For each row, call the matching scraper API on RapidAPI through the generic "Call a Subscribed Hub API" action. I will subscribe to an Instagram scraper and a TikTok scraper of my choice on the RapidAPI Hub (e.g. instagram-scraper-api3, tiktok-scraper7). Make the per-platform host (X-RapidAPI-Host) and the user-posts endpoint path configurable so I can swap scrapers without rebuilding. Both X-RapidAPI-Key and X-RapidAPI-Host headers are required on every call. Pull the last 7 days of posts for each handle and capture: caption, post URL, view count, like count, comment count, hashtags, post type (Reel/carousel/static for Instagram; video for TikTok with sound name if available), and posted timestamp.

Agent reasoning over the collected posts:

- Rank the top 5 highest-engagement posts across all competitors. Default engagement signal: views when present, otherwise likes + 3×comments. Make the formula configurable in a single comment near the top.

- Identify 3 to 5 recurring content themes across the week (e.g. "behind-the-scenes founder content", "product demo with text overlay", "UGC stitches"). Cite which competitors leaned into each theme.

- Summarize the format mix per platform: for Instagram, the rough split of Reels vs carousels vs static; for TikTok, which sounds or trend formats showed up more than once.

- Call out any hashtags that appeared across multiple competitors (2 or more), with the count.

Output: Post a single structured message to Slack #marketing-intel using the Slack Bot "Send a Message" action. Use Block Kit or mrkdwn so it's scannable. Structure:

1) Header with the date range covered. 2) "Top 5 posts this week" with each post as a numbered line: competitor handle, platform, post link, engagement number, and a one-line description. 3) "Themes we saw" with 3 to 5 bullets. 4) "Format mix" with two short lines (Instagram and TikTok). 5) "Hashtags appearing across multiple competitors" with the tag and count. 6) At the very bottom, a small italic "Skipped" line listing any handles whose scraper call errored out, so I can see which ones to look at.

Resilience requirements: if a single handle's scraper call fails (timeout, 403/404/429, malformed response), skip that handle and add it to the skipped list at the bottom of the digest. Do not abort the whole digest because of one broken scraper. Apply exponential backoff on 429 (RapidAPI key limit or provider plan limit) before giving up on a handle.

Use the Slack Bot integration (not the user Slack integration) so the digest comes from a stable bot identity. Use the RapidAPI integration for the scraper calls. Use Google Sheets for reading the competitor list.

Configurables I want to be able to edit later without re-prompting the agent: spreadsheet ID, sheet/tab and range, Instagram scraper host + endpoint path, TikTok scraper host + endpoint path, lookback window (default 7 days), top-N (default 5), engagement formula, destination Slack channel, and the cron time.