TikTok 趋势分析器与 Apify + Gemini + Airtable
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 18 个节点。主要使用 Wait, Webhook, Airtable, HttpRequest, ScheduleTrigger 等节点。 使用 Apify + Gemini + Airtable 的 TikTok 趋势分析器
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Airtable API Key
- •可能需要目标 API 的认证凭证
- •OpenAI API Key
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "689fa22e68cd4198e4ae37f3cc44f498087edd235a867e22515be823bab694c7"
},
"nodes": [
{
"id": "400723bb-3c8e-4bb7-9d13-6fc4c3ab847e",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
1856,
624
],
"webhookId": "6654e70f-4bef-43c3-95e9-c50d55f31018",
"parameters": {
"unit": "minutes",
"amount": 4
},
"typeVersion": 1.1
},
{
"id": "fabb00ce-35c4-48e4-a6c1-bc86c985b8fc",
"name": "等待1",
"type": "n8n-nodes-base.wait",
"position": [
2304,
672
],
"webhookId": "0b2e1c5d-2df4-438d-a4b3-5c4c876c7191",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "af5d7e89-0378-4048-a9f4-5cdda53f5e97",
"name": "OpenAI聊天模型2",
"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": "启动 TikTok 趋势采集器 (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": {
"id": "DNfktOVziN76FiRs",
"name": "Query Auth account"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "9debcd77-79a8-42db-85ea-37cb1467ea7a",
"name": "获取 TikTok 数据集 (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": {
"id": "DNfktOVziN76FiRs",
"name": "Query Auth account"
}
},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "889ada0a-2d0d-4fe5-b70e-1e3e2821c495",
"name": "将热门 TikTok 保存到 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": {
"id": "FWiG3Zt5LOBVBLsx",
"name": "HomefrontAI"
}
},
"typeVersion": 2.1
},
{
"id": "60d5b712-4309-4d77-9b79-9673ceebc915",
"name": "接收待分析的 TikTok 视频",
"type": "n8n-nodes-base.webhook",
"position": [
1152,
1008
],
"webhookId": "da7d9d83-9e2b-4346-9666-85b642364f19",
"parameters": {
"path": "creative-ideation",
"options": {}
},
"typeVersion": 2
},
{
"id": "10847985-1332-4c37-816b-24e3c1db6e01",
"name": "通过 URL 查找 Airtable 记录",
"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": "分析 TikTok 视频 (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": "提取洞察信息 (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": "使用 AI 洞察更新 Airtable",
"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": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
48
],
"parameters": {
"width": 704,
"height": 640,
"content": "## 基于 Apify + Gemini + Airtable 的 TikTok 趋势分析器"
},
"typeVersion": 1
},
{
"id": "84be31a2-4fef-47df-a264-16ee9ed5a6af",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1552,
528
],
"parameters": {
"color": 5,
"height": 272,
"content": "确保您的 Apify API 密钥已存储在凭据管理器中。选择您的区域或修改采集参数。"
},
"typeVersion": 1
},
{
"id": "52b5ee81-6b61-4a6d-b36c-4c2a0fafb664",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2224,
400
],
"parameters": {
"color": 5,
"height": 256,
"content": "更新您的 Airtable 数据库和表格 ID；映射点赞数、观看量、字幕、用户名等字段"
},
"typeVersion": 1
},
{
"id": "d6ee9441-bfc8-4279-b66a-5ae16389c509",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1024,
544
],
"parameters": {
"color": 5,
"height": 224,
"content": "调整 TikTok 趋势采集频率的 cron 计划（默认：每周）"
},
"typeVersion": 1
},
{
"id": "5012380d-da8f-41fa-a30b-cd53938537e1",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2352,
928
],
"parameters": {
"color": 5,
"height": 256,
"content": "确认 AI 摘要、钩子、音频和字幕分析列的映射"
},
"typeVersion": 1
},
{
"id": "ae759972-c8aa-4728-a0e7-181d1df3b4f1",
"name": "每周趋势触发器",
"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": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1696,
928
],
"parameters": {
"color": 5,
"height": 256,
"content": "查看系统提示以优化 Gemini 分析传播因素的方式"
},
"typeVersion": 1
}
],
"pinData": {},
"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
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Decodo、Gemini AI和Google Sheets抓取、结构化并存储新闻数据
使用Decodo、Gemini AI和Google Sheets抓取、结构化并存储新闻数据
Set
Wait
Crypto
+9
18 节点Fahmi Fahreza
市场调研
基于AI的新闻监控（Linkup、Airtable和Slack通知）
基于AI的新闻监控（Linkup、Airtable和Slack通知）
Set
Wait
Slack
+7
16 节点Guillaume Duvernay
市场调研
使用Gemini AI和Decodo爬虫自动匹配简历与职位
使用Gemini AI和Decodo爬虫自动匹配简历与职位
Set
Gmail
Merge
+9
20 节点Fahmi Fahreza
人力资源
新抓取器_TechCrunch新闻-AI1
TechCrunch AI文章抓取与分类器，使用GPT-4.1-nano到Sheets和Telegram
Set
Code
Html
+12
18 节点Mujahid Kabae
市场调研
AI驱动的房地产市场雷达与痛点检测器
使用Apify、GPT-4o和Telegram提醒跟踪房地产市场痛点
Code
Airtable
Telegram
+5
15 节点Bheta Maranatha
市场调研
网站抓取
网站内容抓取与SEO关键词提取（GPT-4o-mini和Airtable）
Code
Wait
Merge
+7
16 节点Abhishek Patoliya
市场调研
