Monthly Influencer Roster Health Check (Modash + Slack)

Build me an agent workflow that runs a monthly health check on my active creator roster so I catch declining partners before I re-spend with them. Trigger: cron, scheduled to fire on the first business day of every month at 9am in my local timezone.

Source data: my active creator list lives in a Google Sheet. Use the Get Values operation to read the sheet (I will provide the spreadsheet ID and the tab range). Each row has three columns: the creator handle, the platform (Instagram, TikTok, or YouTube), and the date of our last collab. Skip the header row.

For each row, pull a fresh Modash profile report using the operation that matches the row's platform: Get Instagram Influencer Report for Instagram handles, Get TikTok Influencer Report for TikTok, and Get YouTube Influencer Report for YouTube. Hand the report's username/handle straight from the sheet. One profile report per creator per run, nothing else.

From each report, reason about creator health using these signals: engagement rate trend versus the creator's prior baseline, fake-follower or credibility score and any meaningful rise, audience country and age mix and whether it has drifted away from our target demo, and recent posting cadence (look for a posting gap since the last collab date on the sheet).

Group every creator into one of three tiers: healthy, watch, or drop. Give each creator a one-line reason that cites the specific signal driving the call (for example: "engagement down 35% versus 90-day baseline" or "fake-follower rate climbed from 8% to 19%" or "no posts in 47 days since our last collab").

Post the prioritized summary to Slack using the Send a Message operation on the Slack Bot integration. I will provide the channel. Format it with Slack mrkdwn. Lead with the drop tier, then the watch tier, then a short one-liner with the healthy count at the bottom. Each creator line should include their handle, platform, tier, and the one-line reason. If any rows could not be looked up (handle not found, private account), list them at the very bottom under a "could not check" section so I can fix the sheet.

Credit guardrail: exactly one profile report per creator per month. Do not call audience-overlap, search, or AI endpoints. If Modash returns a 429 or a 5xx, back off and retry the same creator before moving on.

Additional information

What does this prompt do?

Pulls your active creator list from a Google Sheet on the first business day of every month and runs a fresh health check on each Instagram, TikTok, and YouTube creator on Modash.
Looks at engagement trend, fake-follower share, audience country and age mix, and recent posting cadence to flag who is fading before you spend again.
Groups every creator into healthy, watch, and drop tiers with a one-line reason per name so your marketing lead can act on the riskiest creators first.
Posts the prioritized summary to your chosen Slack channel, leading with the drop and watch tiers.

What do I need to use this?

A Modash account with API access enabled on your plan.
A Google Sheet with your active creators, with one column for the creator handle, one for the platform (Instagram, TikTok, or YouTube), and one for the date of your last collab.
A Slack workspace and the channel you want the summary posted to.

How can I customize it?

Change the cadence (e.g. fortnightly, the first Monday of each month, or the week before quarterly planning).
Tune what counts as watch or drop: engagement drop threshold, fake-follower cutoff, posting-gap days, or how much audience drift from your target country and age mix is acceptable.
Point the summary at a different Slack channel, or split it into two messages so drops post first and watches post in a follow-up.

Frequently asked questions

What if my roster has more than fifty creators?

It still works. The workflow walks the sheet row by row and pulls one Modash report per creator. Bigger rosters just take a bit longer to run and use one credit per creator per month.

Does this cover Instagram, TikTok, and YouTube creators in the same list?

Yes. The platform column on each row tells the workflow which Modash report to pull, so a mixed roster is fine.

How many Modash credits will each monthly run use?

One profile report credit per creator on the sheet, plus the free dictionary calls. There are no audience-overlap or search calls, so a roster of forty creators costs roughly forty credits each month.

Can I keep using my existing tracking sheet?

Yes. Any Google Sheet with handle, platform, and last collab date columns will work. You point the workflow at the spreadsheet and tab, and you can keep your other columns for notes, rates, or campaign history.

What happens if a creator changed their handle since our last collab?

Modash returns a not-found error for that row, the workflow skips it, and the Slack summary calls out which rows could not be looked up so you can fix the sheet entry before the next run.