📊 TikTok trend analyzer with Apify + Gemini + Airtable
⚡ 1,090 views · 📊 Market Research & Insights
💡 Pro Tip — Since TikTok doesn’t have a public API, getting data usually means fragile HTTP scraping. ScraperNode is a community node that gives you clean JSON for TikTok profiles, videos, and comments — drop it into your workflow and skip the parsing.
Description
TikTok Trend Analyzer with Apify + Gemini + Airtable
Automatically scrape trending TikTok videos, analyze their virality using Gemini AI, and store insights directly into Airtable for creative research or content planning.
Who’s it for?
Marketing analysts, creators, and creative agencies looking to understand why videos go viral and how to replicate successful hooks and formats.
How it works
- A scheduled trigger runs the Apify TikTok Trends Scraper weekly.
- The scraper collects trending video metadata.
- Data is stored in Airtable (views, likes, captions, sounds, etc.).
- When a specific video is submitted via webhook, the workflow fetches it from Airtable.
- Gemini AI analyzes the video and extracts structured insights: summary, visual hook, audio, and subtitle analysis.
- The workflow updates the Airtable record with these AI insights.
How to set up
Connect Apify and Airtable credentials, link Gemini or OpenAI keys, and adjust the schedule frequency. Add your Airtable base and table IDs. You can trigger analysis manually via the webhook endpoint.
🔗 Nodes Used
Airtable, HTTP Request, Webhook, Schedule Trigger, OpenAI Chat Model, Information Extractor
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File