Creator Outreach | eCommerce Automation

We designed a complete creator relationship management system starting with automated discovery across TikTok and Instagram platforms. Custom scrapers identify creators matching specific criteria — follower count ranges, engagement rates, niche categories, posting frequency, and content style — pulling their profiles into an Airtable-based CRM designed specifically for the creator program with custom fields for relationship stage, content performance, and lifetime value tracking. The outreach automation layer generates personalized messages using OpenAI, incorporating creator-specific details like recent viral videos, content themes, and audience demographics to ensure messages feel genuine rather than templated, resulting in significantly higher response rates. Automated follow-up sequences maintain engagement with prospects who haven't responded, with intelligent timing based on creator activity patterns and optimal sending windows. When creators express interest, an onboarding workflow guides them through affiliate agreement acceptance via DocuSign, product catalog selection based on their content niche, sample shipment coordination, and content brief delivery with brand guidelines and campaign requirements. The performance tracking system aggregates sales data from TikTok Shop with creator activity metrics, calculating true ROI per creator relationship including commission costs, product seeding expenses, and creative production support costs. Commission calculation runs automatically based on attributable sales with configurable tier structures, generating payout reports that integrate with the brand's payment systems for timely monthly disbursement. The Retool dashboard provides the creator team with a complete view of their pipeline — from outreach prospects to active affiliates to historical performance trends — with filtering by performance tier, content category, and engagement metrics.

TikTok API, Airtable, Make.com, OpenAI, Retool, Custom scraping