Weekly influencer campaign tracker in Slack

Build a weekly campaign-tracker workflow that refreshes HypeAuditor data for every influencer I'm currently working with and logs the snapshot. This should be a deterministic code workflow, not an agent.

Trigger: cron, every Monday at 8:00am in my local time zone.

Step 1. Read the active roster from Google Sheets. Use the Get Values action against a tab called "Active Creators" in a spreadsheet I will configure. Each row has two columns: handle and platform, where platform is either "instagram" or "tiktok". Treat the first row as headers.

Step 2. For each row, call HypeAuditor. If the platform is "instagram", call HypeAuditor's Get Instagram Report with that handle. If the platform is "tiktok", call Get TikTok Report. Pin v=2 on both calls. Handle the HypeAuditor states explicitly: on a 202 with retryTtl, sleep that many seconds and retry once; on report_state READY or READY_LOW_CONFIDENCE, treat the report as usable; on 403 (private or restricted) or 404 (not found), skip the creator and remember the skip with the reason so it can be reported at the end; on 429, back off and retry. Respect the 100-requests-per-minute account-wide rate limit and watch result.restTokens so a low-credit run logs a warning instead of silently failing partway.

Step 3. For every successful report, build a snapshot row and append it to a tab called "Weekly Snapshots" using Google Sheets Append Values. Columns, in order: date (ISO yyyy-mm-dd, the run date), handle, platform, follower count, engagement rate, audience authenticity, average likes, average comments.

Step 4. Compute week-over-week deltas in code. For each handle, read the prior snapshot for that handle from the Weekly Snapshots tab (the most recent row dated before today). If there is no prior row, mark the creator as "new this week" and skip the delta math for them. Otherwise compute percentage change for follower count, engagement rate, and audience authenticity, plus absolute change for average likes and average comments.

Step 5. Send a Slack summary to a channel I will configure (Send a Message). The message should contain: a one-line header with the run date and total creators refreshed; the top three risers by engagement-rate change week-over-week; the top three fallers by engagement-rate change week-over-week; an "Attention" section listing any creator whose audience authenticity dropped below 70 or whose engagement rate fell more than 25 percent week-over-week; and a short footer noting any skipped creators with their reason (private, not found, etc.). Format the message in Slack mrkdwn with bold section headers so it's scannable in the channel.

Inputs I should be prompted for at setup: the Google Sheets spreadsheet ID, the Active Creators tab name (default "Active Creators"), the Weekly Snapshots tab name (default "Weekly Snapshots"), the Slack channel name or ID, and the time zone for the cron.

Edge cases to handle defensively: an empty Active Creators sheet (post a Slack message saying the roster is empty and exit cleanly); a row with a missing handle or platform (skip and include in the skipped list); a HypeAuditor 402 Payment Required (post a Slack message that credits are out and exit); fewer than three creators with deltas (just list whatever risers/fallers exist instead of padding); ties in the delta ranking (break ties by follower count descending).