Find and analyze viral TikTok product ads
Click a button on an Airtable product and get its top TikTok videos saved and broken down by Gemini: hook, tone, CTA and transcript
Version 1
What it does
A button on a product record in Airtable calls this workflow's webhook. It reads the product type, then uses an Apify TikTok scraper to pull this month's most liked US videos for that keyword. The results are sorted by views, the top ones are kept and upserted into a Viral Ads table with their stats, caption, hashtags and video link.
Each ad that has no analysis yet is downloaded, uploaded to Gemini and analyzed against a fixed checklist: format, hook and visual hook, style, tone, CTA, transcript and why it works. The analysis is written back to the ad's row, and a status field on the product shows progress. The next workflow in the system writes scripts from these ads.