Fahmi Fahreza This workflow corresponds to n8n.io template #9989 — we link there as the canonical source.
This workflow follows the Airtable → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "400723bb-3c8e-4bb7-9d13-6fc4c3ab847e",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
1856,
624
],
"parameters": {
"unit": "minutes",
"amount": 4
},
"typeVersion": 1.1
},
{
"id": "fabb00ce-35c4-48e4-a6c1-bc86c985b8fc",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"position": [
2304,
672
],
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "af5d7e89-0378-4048-a9f4-5cdda53f5e97",
"name": "OpenAI Chat Model2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2160,
1232
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"typeVersion": 1.2
},
{
"id": "6cfdd775-ab4b-4abc-8552-c5047d9c16bd",
"name": "Start TikTok Trends Scraper (Apify)",
"type": "n8n-nodes-base.httpRequest",
"position": [
1632,
624
],
"parameters": {
"url": "https://api.apify.com/v2/acts/fetchly~tiktok-trends-api/runs",
"method": "POST",
"options": {},
"jsonBody": "={\n \"country\": \"United States\",\n \"downloadCoverImage\": false,\n \"downloadVideo\": false,\n \"generatePermalinks\": false,\n \"numberOfVideos\": 100,\n \"proxyType\": \"RESIDENTIAL\",\n \"useApifyProxy\": true\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth"
},
"credentials": {
"httpQueryAuth": {
"name": "<your credential>"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "9debcd77-79a8-42db-85ea-37cb1467ea7a",
"name": "Fetch TikTok Dataset (Apify)",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
2080,
624
],
"parameters": {
"url": "https://api.apify.com/v2/acts/fetchly~tiktok-trends-api/runs/last/dataset/items",
"options": {},
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth"
},
"credentials": {
"httpQueryAuth": {
"name": "<your credential>"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "889ada0a-2d0d-4fe5-b70e-1e3e2821c495",
"name": "Save Trending TikToks to Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
2304,
480
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appwEOGxCbXgEGwjT",
"cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT",
"cachedResultName": "Creative Ideation"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblOtG5ciGFSxE5My",
"cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT/tblOtG5ciGFSxE5My",
"cachedResultName": "TikTok V2"
},
"columns": {
"value": {
"Likes": "={{ $json.likes }}",
"Views": "={{ $json.views }}",
"Shares": "={{ $json.shares }}",
"Caption": "={{ $json.title }}",
"Comments": "={{ $json.comments }}",
"Username": "={{ $json.author }}",
"Tiktok URL": "={{ $json.url }}",
"Sound Title": "={{ $json.music.title }}",
"Trending Position": "={{ $json.trending_position }}",
"Downloaded Video URL": "={{ $json.permalink }}"
},
"schema": [
{
"id": "Tiktok URL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Tiktok URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Good Video",
"type": "boolean",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Good Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Downloaded Video URL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Downloaded Video URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Added",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Date Added",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Likes",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Trending Position",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Trending Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comments",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Comments",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shares",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Shares",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Views",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Views",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Username",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sound Title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Sound Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send to AI",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Send to AI",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AI Summary",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "AI Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Visual Hook Analysis",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Visual Hook Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Audio Script Analysis",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Audio Script Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subtitle Analysist",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Subtitle Analysist",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "60d5b712-4309-4d77-9b79-9673ceebc915",
"name": "Receive TikTok Video for Analysis",
"type": "n8n-nodes-base.webhook",
"position": [
1152,
1008
],
"parameters": {
"path": "creative-ideation",
"options": {}
},
"typeVersion": 2
},
{
"id": "10847985-1332-4c37-816b-24e3c1db6e01",
"name": "Find Airtable Record by URL",
"type": "n8n-nodes-base.airtable",
"position": [
1504,
1008
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appwEOGxCbXgEGwjT",
"cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT",
"cachedResultName": "Creative Ideation"
},
"limit": 1,
"table": {
"__rl": true,
"mode": "list",
"value": "tblOtG5ciGFSxE5My",
"cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT/tblOtG5ciGFSxE5My",
"cachedResultName": "TikTok V2"
},
"options": {},
"operation": "search",
"returnAll": false,
"filterByFormula": "={Tiktok URL} = \"{{ $json.query.media }}\""
},
"typeVersion": 2.1
},
{
"id": "d6f04810-a301-415a-a5e2-352224090568",
"name": "Analyze TikTok Video (Gemini 2.5)",
"type": "@n8n/n8n-nodes-langchain.googleGemini",
"position": [
1776,
1008
],
"parameters": {
"text": "=You are an expert AI analyst specialized in evaluating why TikTok videos go viral. Your job is to synthesize the data and produce a **deep, objective analysis**.\n\n---\n\n### **Your Goal**\n\nAnalyze the inputs holistically and answer:\n\n* Why did this video go viral?\n* What were the core drivers of performance?\n* How strong was the hook, storytelling, and trend alignment?\n* What patterns can be reused in future videos?\n\n---\n\n### **Constraints**\n\n* **Do not guess.** Derive all insights strictly from provided input data.\n* **Be objective.** Avoid vague, flattering, or promotional language.\n* **Justify every insight.** Support conclusions with clear links to input signals.\n",
"modelId": {
"__rl": true,
"mode": "list",
"value": "models/gemini-2.5-flash",
"cachedResultName": "models/gemini-2.5-flash"
},
"options": {},
"resource": "video",
"operation": "analyze",
"videoUrls": "={{ $json['Tiktok URL'] }}"
},
"typeVersion": 1
},
{
"id": "071fe056-dd5b-47c0-b82c-efa0d54da284",
"name": "Extract Insights (LLM)",
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"position": [
2080,
1008
],
"parameters": {
"text": "={{ $json.content.parts[0].text }}",
"options": {},
"attributes": {
"attributes": [
{
"name": "ai_summary",
"required": true,
"description": "A concise, high-level summary of the content (main message, purpose, or context). Should explain the core idea in plain language so a non-expert can quickly understand."
},
{
"name": "visual_hook_analysis",
"required": true,
"description": "Analysis of the visual elements used as hooks (e.g., camera angles, expressions, colors, on-screen text, or visuals designed to capture attention in the first few seconds). Focus on effectiveness and engagement."
},
{
"name": "audio_analysis",
"required": true,
"description": "Evaluation of the audio aspects (tone, music, pacing, clarity, voice delivery, sound effects). Explain how these elements support engagement, mood, and message delivery."
},
{
"name": "subtitle_analysis",
"required": true,
"description": "Review of the subtitles/captions (accuracy, timing, readability, formatting, and whether they enhance comprehension and viewer retention)."
}
]
}
},
"typeVersion": 1.2
},
{
"id": "a62a3cb5-79a4-44c6-812d-2eaeb4105b60",
"name": "Update Airtable with AI Insights",
"type": "n8n-nodes-base.airtable",
"position": [
2432,
1008
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appwEOGxCbXgEGwjT",
"cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT",
"cachedResultName": "Creative Ideation"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblOtG5ciGFSxE5My",
"cachedResultUrl": "https://airtable.com/appwEOGxCbXgEGwjT/tblOtG5ciGFSxE5My",
"cachedResultName": "TikTok V2"
},
"columns": {
"value": {
"id": "={{ $('Find Airtable Record by URL').item.json.id }}",
"AI Summary": "={{ $json.output.ai_summary }}",
"Audio Analysis": "={{ $json.output.audio_analysis }}",
"Subtitle Analysis": "={{ $json.output.subtitle_analysis }}",
"Visual Hook Analysis": "={{ $json.output.visual_hook_analysis }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Tiktok URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Tiktok URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Good Video",
"type": "boolean",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Good Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Added",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Date Added",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Caption",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Likes",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Trending Position",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Trending Position",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comments",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Comments",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Shares",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Shares",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Views",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Views",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Username",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sound Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Sound Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send to AI",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Send to AI",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AI Summary",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "AI Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Visual Hook Analysis",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Visual Hook Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Audio Analysis",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Audio Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subtitle Analysis",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Subtitle Analysis",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"typeVersion": 2.1
},
{
"id": "7912c2ed-a29e-4e7a-8843-11bc97032f63",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
48
],
"parameters": {
"width": 704,
"height": 640,
"content": "## TikTok Trend Analyzer with Apify + Gemini + Airtable\n\nAutomatically scrape trending TikTok videos, analyze their virality using Gemini AI, and store insights directly into Airtable for creative research or content planning.\n\n## Who\u2019s it for?\nMarketing analysts, creators, and creative agencies looking to understand why videos go viral and how to replicate successful hooks and formats.\n\n## How it works\n1. A scheduled trigger runs the Apify TikTok Trends Scraper weekly.\n2. The scraper collects trending video metadata.\n3. Data is stored in Airtable (views, likes, captions, sounds, etc.).\n4. When a specific video is submitted via webhook, the workflow fetches it from Airtable.\n5. Gemini AI analyzes the video and extracts structured insights: summary, visual hook, audio, and subtitle analysis.\n6. The workflow updates the Airtable record with these AI insights.\n\n## How to set up\nConnect 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.\n"
},
"typeVersion": 1
},
{
"id": "84be31a2-4fef-47df-a264-16ee9ed5a6af",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1552,
528
],
"parameters": {
"color": 5,
"height": 272,
"content": "Ensure your Apify API key is stored in the Credential Manager. Choose your region or modify scrape parameters.\n"
},
"typeVersion": 1
},
{
"id": "52b5ee81-6b61-4a6d-b36c-4c2a0fafb664",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2224,
400
],
"parameters": {
"color": 5,
"height": 256,
"content": "Update your Airtable base and table IDs; map fields for Likes, Views, Caption, Username, etc."
},
"typeVersion": 1
},
{
"id": "d6ee9441-bfc8-4279-b66a-5ae16389c509",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1024,
544
],
"parameters": {
"color": 5,
"height": 224,
"content": "Adjust the cron schedule for how often you want to scrape TikTok trends (default: weekly)."
},
"typeVersion": 1
},
{
"id": "5012380d-da8f-41fa-a30b-cd53938537e1",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2352,
928
],
"parameters": {
"color": 5,
"height": 256,
"content": "Confirm mapping of AI Summary, Hook, Audio, and Subtitle Analysis columns."
},
"typeVersion": 1
},
{
"id": "ae759972-c8aa-4728-a0e7-181d1df3b4f1",
"name": "Weekly Trend Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1088,
624
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 0 * * 1"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "f665c606-b97b-4e76-9ee3-6c57514a63b9",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1696,
928
],
"parameters": {
"color": 5,
"height": 256,
"content": "Review the system prompt to refine how Gemini analyzes virality factors."
},
"typeVersion": 1
}
],
"connections": {
"Wait": {
"main": [
[
{
"node": "Fetch TikTok Dataset (Apify)",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Fetch TikTok Dataset (Apify)",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "Extract Insights (LLM)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Weekly Trend Trigger": {
"main": [
[
{
"node": "Start TikTok Trends Scraper (Apify)",
"type": "main",
"index": 0
}
]
]
},
"Extract Insights (LLM)": {
"main": [
[
{
"node": "Update Airtable with AI Insights",
"type": "main",
"index": 0
}
]
]
},
"Find Airtable Record by URL": {
"main": [
[
{
"node": "Analyze TikTok Video (Gemini 2.5)",
"type": "main",
"index": 0
}
]
]
},
"Fetch TikTok Dataset (Apify)": {
"main": [
[
{
"node": "Save Trending TikToks to Airtable",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Analyze TikTok Video (Gemini 2.5)": {
"main": [
[
{
"node": "Extract Insights (LLM)",
"type": "main",
"index": 0
}
]
]
},
"Receive TikTok Video for Analysis": {
"main": [
[
{
"node": "Find Airtable Record by URL",
"type": "main",
"index": 0
}
]
]
},
"Start TikTok Trends Scraper (Apify)": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApihttpQueryAuth
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automatically scrape trending TikTok videos, analyze their virality using Gemini AI, and store insights directly into Airtable for creative research or content planning.
Source: https://n8n.io/workflows/9989/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
The Ultimate Scraper for n8n uses Selenium and AI to retrieve any information displayed on a webpage. You can also use session cookies to log in to the targeted webpage for more advanced scraping need
OpenAI Chat, HTTP Request, Information Extractor +1
This template automates the extraction of structured data from Thai government letters received via LINE or uploaded to Google Drive. It uses Mistral AI for OCR and OpenAI for information extraction,
HTTP Request, Google Drive Trigger, Google Drive +4
🤝🖊️🤖 This workflow automates the process of retrieving meeting transcripts from Fireflies.ai, extracting and summarizing relevant content using Google Gemini, and sending or drafting well-formatted su
@Firefliesai/N8N Nodes Fireflies, Gmail Trigger, Gmail +3
I'll be honest, I built this because I was getting lazy in meetings and missing key details. I started with a simple VEXA integration for transcripts, then added AI to pull out summaries and tasks. Bu
Redis, Baserow, HTTP Request +3
Deduplicate Scraping Ai Grants For Eligibility Using Ai. Uses splitOut, httpRequest, lmChatOpenAi, informationExtractor. Scheduled trigger; 24 nodes.
HTTP Request, OpenAI Chat, Information Extractor +2