Weekly TikTok and Instagram creator shortlist in 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).