Weekly TikTok & Instagram creator discovery to Airtable

Build me an agent workflow that runs once a week (Monday at 7am in my timezone) and produces a ranked shortlist of TikTok and Instagram creators worth partnering with in a target niche. The output should be new rows in an Airtable table, not a firehose.

Inputs the workflow should accept at setup time: a list of niche or topic keywords, the Airtable base ID and creators table name, which platforms to include (TikTok, Instagram, or both), and three thresholds: minimum follower count, minimum recent average engagement rate, and minimum on-topic content density (what fraction of their recent posts mention the niche).

Each run, the agent should do this:

1. Pull the existing creator handles from the Airtable creators table using Airtable's List Records so we can dedupe later. Read enough fields to know handle and platform.

2. For each niche keyword, call XPOZ's Search TikTok Posts by Keywords and Search Instagram Posts by Keywords to gather the highest-engagement posts from roughly the last 14 days. Sort by engagement and keep the top N posts per platform (default 50).

3. Build the candidate creator set from the authors of those top posts. For TikTok candidates, fetch their recent videos with XPOZ's Get TikTok Posts by User so we can compute an average engagement rate and check on-topic content density. For Instagram, supplement the candidate set with XPOZ's Get Instagram Users by Keywords to surface relevant creators whose recent posts may not have ranked but whose bios match the niche, and pull each Instagram candidate's recent posts the same way.

4. For each candidate, compute three signals: (a) follower count band, (b) recent average engagement rate over their last 10 to 20 posts, and (c) on-topic content density (the fraction of those recent posts that mention the niche keywords). Drop any candidate that falls below any of the configured thresholds, and drop any handle already in the Airtable creators table from step 1.

5. Score the survivors on a 0 to 100 fit scale that weights all three signals (default weighting: 30% audience size band, 40% engagement rate, 30% on-topic density). Rank descending.

6. Write the qualified, ranked creators to Airtable using Create Records (batched in groups of 10). For each creator, populate: handle, platform (TikTok or Instagram), follower count, average engagement rate, top post URL, a short 2 to 3 sentence content summary describing what they post about, and the fit score. Include the run date so I can track when each was discovered.

Keep the list tight. Default to writing a maximum of 25 new creators per run, even if more pass the thresholds, so the shortlist stays reviewable. If zero new creators qualify in a given week, just log that and write nothing rather than writing junk.

Trigger: weekly cron, Monday 7am local time. Integrations: XPOZ (primary, for all social search and creator data) and Airtable (for dedupe lookup and writing the shortlist rows).

Additional information

What does this prompt do?

Every week, scans TikTok and Instagram for the top posts in the niche you care about.
Pulls the creators behind those posts and scores each one on audience size, recent engagement, and how on-topic their content is.
Skips anyone already in your base or anyone who falls below your thresholds, so the list stays tight.
Adds a clean row to Airtable for every qualified creator with handle, platform, follower count, average engagement, top post link, a short content summary, and a fit score.

What do I need to use this?

An XPOZ account with an API key (free tier is fine to start).
An Airtable workspace with a creators table you want the shortlist written into.
Your target niche or topic keywords, plus the thresholds you want to use for follower count and engagement rate.

How can I customize it?

Swap the niche keywords, or run separate copies for each brand or vertical you cover.
Change the day and time the shortlist runs, or move from weekly to daily if you scout faster.
Tighten or loosen the follower band, engagement rate floor, and on-topic content density thresholds to match your campaign goals.
Limit the search to TikTok only or Instagram only, or add a maximum number of creators per run.

Frequently asked questions

Will this work for any niche or audience?

Yes. You tell the workflow your topic keywords (for example, hydration, indie skincare, college football) and it searches TikTok and Instagram for the highest-engagement posts on that topic before pulling the creators behind them.

How does it avoid duplicates in my Airtable?

Before writing anything, the workflow reads the existing rows in your creators table and skips any handle that is already there. You only ever see new candidates.

What if I only want TikTok creators, or only Instagram?

You can run it on a single platform. When you set the workflow up, just tell it which platforms to include, and it will skip the other one.

How are creators ranked?

Each candidate gets a fit score based on three things: their follower count band, their recent average engagement rate, and how much of their content is actually on your topic. Higher score means a stronger partnership fit.

Can I review creators before they hit Airtable?

Yes. A common tweak is to write new candidates into a review view first, mark them approved or rejected, and only promote approved rows into your main partnerships list.