Weekly Influencer Campaign Tracker (HypeAuditor + Google Sheets + 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).

Additional information

What does this prompt do?

Every Monday at 8am, reads your list of active creators from a Google Sheet tab and pulls a fresh HypeAuditor report for each one on Instagram or TikTok.
Appends a dated row per creator to a Weekly Snapshots tab with followers, engagement rate, audience authenticity, and average likes and comments.
Compares this week's numbers to last week's and flags the top three risers, the top three fallers, and any creator with audience authenticity under 70 or engagement down more than 25 percent.
Posts the whole rundown to a Slack channel of your choice so the team starts Monday already aligned on which partnerships are working.

What do I need to use this?

A HypeAuditor account on a plan that includes API access (each report costs 1 credit and is cached for a year).
A Google account with edit access to a sheet that has an Active Creators tab (handle plus platform) and a Weekly Snapshots tab.
A Slack workspace and the channel name where the weekly summary should land.

How can I customize it?

Change the schedule. Move the run to a different day or time, or swap weekly for biweekly if you want to spend fewer report credits.
Tune the alert thresholds. Drop the audience authenticity floor below 70 or change the engagement drop threshold to match how strict you want the warnings to be.
Swap the sources and destination. Point at a different sheet, rename the tabs, or send the summary to a different Slack channel or DM.

Frequently asked questions

Do I have to track Instagram and TikTok together, or can I do one platform?

Either works. Put just Instagram handles in the sheet and the workflow will only pull Instagram reports. Add a platform column and you can mix both, with each row going to the right report.

How much does this cost to run?

On HypeAuditor's side, one report credit per creator per run. A roster of 25 creators run weekly is about 100 credits a month. Reports are cached for a year, so re-pulls inside that window are free.

What if a creator's profile is private or their handle changed?

HypeAuditor refunds the credit when a report can't be built. The workflow notes the skip in the Slack summary so you know to update the handle in your sheet.

Can I change which numbers get logged or alerted on?

Yes. The snapshot columns and the alert rules are both editable. Add or remove fields like reach or follower growth, and adjust the thresholds for risers, fallers, and audience quality warnings.

Where do the week-over-week comparisons come from?

From the Weekly Snapshots tab itself. The workflow reads the prior week's row for each creator and compares it to the fresh numbers before posting the summary.