Vet new influencer prospects with Social Blade
When a creator is added to your Airtable prospect base, pull Social Blade growth and earnings, score them, write a verdict back, and ping the owner in Slack.
Build me an agent workflow that vets new influencer prospects the moment they land in my Airtable base, so my team has a verdict and a short reasoning note before anyone reaches out.
Trigger: poll Airtable for new_record on my "Influencer Prospects" table. Each row has a Platform column (one of youtube, tiktok, instagram, twitter, twitch, or facebook), a Handle column (the creator's handle or channel ID), and an Owner column (the team member responsible). The trigger fires once per newly added row.
When the trigger fires, the agent should:
1. Call the matching Social Blade Get Profile Statistics operation for the platform on that row, passing history=extended so we get 30-day and 12-month trajectories. Use Get YouTube Channel Statistics, Get TikTok Profile Statistics, Get Instagram Profile Statistics, Get Twitter Profile Statistics, Get Twitch Channel Statistics, or Get Facebook Page Statistics depending on the Platform value. Always check status.success and handle 404 (channel not found), 401 (bad creds), and 402 (out of credits) gracefully by writing back a verdict of "review" with an explanation.
2. Score the creator against these authenticity heuristics, then decide on a verdict (proceed / review / reject):
- Social Blade grade (A+ through F). C or below leans toward review or reject.
- Monthly subscriber growth percentage vs the healthy 5 to 15 percent band. Below 1 percent for an established creator leans review; far above 15 percent without a clear reason is a yellow flag.
- Any single-month spike in the 12-month history that looks like a purchased-followers signal (for example, one month adding several multiples of every other month). Treat this as a strong reject signal.
- Estimated monthly earnings sanity-checked against follower count and platform norms. Earnings far below what the size implies is a yellow flag.
- Average daily growth trend (rising, flat, declining). Sustained decline is a yellow flag.
3. Call Airtable Update Record on the same row and write back: Grade, Subscribers (or Followers), Monthly Growth %, Estimated Earnings, Verdict (proceed / review / reject), and Reasoning (one sentence explaining the verdict in plain English, citing the specific signal that drove it).
4. Call Slack Send a Message to post a brief summary into #influencer-prospects (configurable). Format:
"<owner Slack handle> new prospect vetted: <handle> on <platform> – <verdict>. <one-line reasoning>. <Airtable link to the row>." Tag the Owner from the Airtable row so they get a notification.
Keep the reasoning specific ("flat growth and a 480% one-month spike in Feb suggests purchased followers"), not generic. If Social Blade returns no data for a handle, write verdict = review and reasoning = "Social Blade has no profile for this handle, double-check the platform and handle spelling."
Additional information
What does this prompt do?
- Watches your Airtable Influencer Prospects base and kicks off the moment a new row is added.
- Pulls 30-day and 12-month growth, grade, and estimated earnings from Social Blade for the right platform.
- Scores the creator against healthy-growth and authenticity heuristics and flags suspicious spikes.
- Writes grade, subscribers, monthly growth, earnings, a proceed or review or reject verdict, and a one-sentence reasoning note back to the row.
- Posts a short summary in Slack and tags the prospect owner so they know it is ready to action.
What do I need to use this?
- An Airtable base with an Influencer Prospects table that includes platform and handle or channel ID columns.
- A Social Blade Business API account with available credits.
- A Slack workspace and a channel where the prospect team gets pinged.
How can I customize it?
- Tighten or loosen the healthy growth band (the default is 5 to 15 percent monthly).
- Change which Slack channel gets the summary and whether owners are tagged by handle or by email lookup.
- Adjust the verdict rules, for example auto-reject anyone below a Social Blade grade of C or with a suspicious single-month spike.
Frequently asked questions
Which platforms does this work for?
Do I need a paid Social Blade plan?
What does the verdict actually mean?
Can I use a different Airtable table name?
Will the owner get pinged for every single new row?
Related templates
Stop chasing influencer red flags by hand.
Connect Airtable, Social Blade, and Slack once, and every new prospect gets a verdict and a reasoning note before your team reaches out.