YTB 异常值查找器
高级
这是一个自动化工作流，包含 16 个节点。主要使用 If, Set, Code, Wait, Airtable 等节点。 在您的细分领域中发现隐藏的YouTube趋势/异常视频（Apify + Airtable）
前置要求
- •Airtable API Key
- •可能需要目标 API 的认证凭证
使用的节点 (16)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "",
"meta": {
"instanceId": "",
"templateCredsSetupCompleted": true
},
"name": "YTB Outlier Finder",
"tags": [],
"nodes": [
{
"id": "Wait-0",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
0,
-460
],
"webhookId": "",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "If-1",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
-160,
-640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.data.status }}",
"rightValue": "SUCCEEDED"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "Check-IF-Finished-2",
"name": "Check IF Finished",
"type": "n8n-nodes-base.httpRequest",
"position": [
-440,
-640
],
"parameters": {
"url": "https://api.apify.com/v2/acts/streamers~youtube-scraper/runs/last?token=[YOUR_API_TOKEN]",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "Get-Videos-Data-3",
"name": "Get Videos Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
160,
-660
],
"parameters": {
"url": "https://api.apify.com/v2/acts/streamers~youtube-scraper/runs/last/dataset/items?token=[YOUR_API_TOKEN]",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "Create-Videos-Dataset-4",
"name": "Create Videos Dataset",
"type": "n8n-nodes-base.httpRequest",
"position": [
-700,
-640
],
"parameters": {
"url": "https://api.apify.com/v2/acts/streamers~youtube-scraper/runs?token=[YOUR_API_TOKEN]",
"method": "POST",
"options": {},
"jsonBody": "={\n \"dateFilter\": \"week\",\n \"downloadSubtitles\": true,\n \"hasCC\": false,\n \"hasLocation\": false,\n \"hasSubtitles\": false,\n \"is360\": false,\n \"is3D\": false,\n \"is4K\": false,\n \"isBought\": false,\n \"isHD\": false,\n \"isHDR\": false,\n \"isLive\": false,\n \"isVR180\": false,\n \"lengthFilter\": \"between420\",\n \"maxResultStreams\": 0,\n \"maxResults\": 3,\n \"maxResultsShorts\": 0,\n \"preferAutoGeneratedSubtitles\": false,\n \"saveSubsToKVS\": false,\n \"searchQueries\": [\n \"{{ $json.keyword1 }}\",\n \"{{ $json.keyword2 }}\",\n \"{{ $json.keyword3 }}\"\n ],\n \"sortingOrder\": \"relevance\",\n \"subtitlesLanguage\": \"en\"\n} ",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "Loop-Over-Items-5",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
400,
-660
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "Mistral-Cloud-Chat-Model-6",
"name": "Mistral Cloud Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatMistralCloud",
"position": [
980,
-300
],
"parameters": {
"options": {}
},
"credentials": {
"mistralCloudApi": {
"id": "",
"name": "Mistral Cloud account"
}
},
"typeVersion": 1
},
{
"id": "No-Operation-do-nothing-7",
"name": "No Operation, do nothing",
"type": "n8n-nodes-base.noOp",
"position": [
900,
-680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "Airtable-8",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
1460,
-320
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://airtable.com/[YOUR_DB]",
"cachedResultName": "YTB Trend Finder"
},
"table": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://airtable.com/[YOUR_DB]",
"cachedResultName": "Listing"
},
"columns": {
"value": {
"Link": "={{ $('Loop Over Items').item.json.url }}",
"Title": "={{ $('Loop Over Items').item.json.title }}",
"Duration": "={{ $('Loop Over Items').item.json.duration }}",
"Structure": "={{ $json.text }}",
"SubsCount": "={{ $('Loop Over Items').item.json.numberOfSubscribers }}",
"Thumbnail": "={{ [{ \"url\": $('Loop Over Items').item.json.thumbnailUrl }] }}",
"ViewsCount": "={{ $('Loop Over Items').item.json.viewCount }}",
"ChannelName": "={{ $('Loop Over Items').item.json.channelName }}",
"CommentsCount": "={{ $('Loop Over Items').item.json.commentsCount }}"
},
"schema": [
{
"id": "Link",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ChannelName",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ChannelName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Thumbnail",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Thumbnail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ViewsCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "ViewsCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "SubsCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "SubsCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CommentsCount",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "CommentsCount",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Duration",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Duration",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Structure",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Structure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "VSC Ratio",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "VSC Ratio",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "Schedule-Trigger-9",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1220,
-640
],
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtDay": [
1
]
}
]
}
},
"typeVersion": 1.2
},
{
"id": "Sticky-Note2-10",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1300,
-900
],
"parameters": {
"color": 7,
"width": 780,
"height": 440,
"content": "## SETUP\n\n**Scheduled Trigger :** Select the Frequency you want. If you change it, update the data accordingly in the \"Create Videos Dataset\" HTTP Request Node in Body ➡️ JSON ➡️ dateFilter.\n\n\n**Setup Keywords :** Enter Keyword Related to the niche you want. If you change the number of keywords, update the data accordingly in the \"Create Videos Dataset\" HTTP Request Node in Body ➡️ JSON ➡️ searchQueries.\n\n**Create Videos Dataset :** Refer to the Apify Documentation for more https://docs.apify.com/api/v2/getting-started\n\n**APIs :** For all HTTP Request node in the URL field, replace [YOUR_API_TOKEN] with your API Token. "
},
"typeVersion": 1
},
{
"id": "Text-Cleaning-11",
"name": "Text Cleaning",
"type": "n8n-nodes-base.code",
"position": [
700,
-500
],
"parameters": {
"jsCode": "// Assume input is a single string like SRT format\nconst input = $input.first().json.subtitles[0].srt; // or wherever your caption string is\n\n// Step-by-step cleanup\nconst cleaned = input\n // Remove caption numbers (lines with only digits)\n .replace(/^\\d+\\s*$/gm, \"\")\n // Remove timing lines\n .replace(/^\\d{2}:\\d{2}:\\d{1,2},\\d{1,3} --> \\d{2}:\\d{2}:\\d{1,2},\\d{1,3}\\s*$/gm, \"\")\n // Remove leftover newlines\n .replace(/\\n{2,}/g, \"\\n\")\n // Trim and flatten everything to single paragraph\n .replace(/\\n/g, \" \")\n .trim();\n\nreturn [{ cleanedText: cleaned }];"
},
"typeVersion": 2
},
{
"id": "Text-Synthesis--12",
"name": "Text Synthesis ",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
960,
-500
],
"parameters": {
"text": "={{ $json.cleanedText }}",
"messages": {
"messageValues": [
{
"type": "HumanMessagePromptTemplate",
"message": "=You are a summarization assistant. Given a transcript of a YouTube video, your task is to summarize the content using only information found in the transcript, do not invent, infer, or add anything beyond what is said. Structure your output as follows: \n\n1. Intro how the video begins or introduces the topic. Don't do any modification on this part. \n\n2. Structure of the Video A breakdown of the video’s flow using bullet points: \nMajor Points: The main topics or arguments discussed. \nSubpoints: Supporting details, examples, or smaller elements related to each major point. Use indentation or clear labeling to distinguish between major points and their related subpoints. \n"
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.5
},
{
"id": "Setup-Keywords-13",
"name": "Setup Keywords",
"type": "n8n-nodes-base.set",
"position": [
-960,
-640
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "",
"name": "keyword1",
"type": "string",
"value": "Healthy food"
},
{
"id": "",
"name": "keyword2",
"type": "string",
"value": "Meal prep healthy"
},
{
"id": "",
"name": "keyword3",
"type": "string",
"value": "High Protein Snack"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "Sticky-Note-14",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1300,
-1140
],
"parameters": {
"color": 7,
"width": 780,
"height": 220,
"content": "## How this is Working ?\n**1 -** Every Week retrieve Keywords you want to track\n**2 -** Thanks to Apify, scrap video from Youtube Search related to these Keywords filtered by relevance\n**3 -** Wait until the Dataset is completed\n**4 -** Get the Information contained in the Dataset\n**5 -** For each Video, clean and summarize the script\n**6 -** Upload everything in your Airtable Database\n\n**Youtube Video Tutorial : https://youtu.be/pH2hVaij3FY**\n**Need Help with Your Workflows ? https://tally.so/r/wayeqB**"
},
"typeVersion": 1
},
{
"id": "Sticky-Note1-15",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1360,
-700
],
"parameters": {
"color": 7,
"width": 320,
"height": 620,
"content": "## Airtable DB Fields\n**1 -** Video Link (ID)\n**2 -** Video Title\n**3 -** Channel Name\n**4 -** Thumbnail ⬇️\nTo Upload an Image on Airtable Attachement Field you need an Array of the URL in this format : {{ [{ \"url\": $json.thumbnail}] }}\n**5 -** Views Count\n**6 -** Subs Count\n**7 -** Comments Count\n**8 -** Duration\n**9 -** Structure\n**10 -** VSC Ratio ⬇️\nFormula :(ViewsCount/SubsCount)*0.7 + (CommentsCount/ViewsCount)*0.3)\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "",
"connections": {
"If-1": {
"main": [
[
{
"node": "Get-Videos-Data-3",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait-0",
"type": "main",
"index": 0
}
]
]
},
"Wait-0": {
"main": [
[
{
"node": "Check-IF-Finished-2",
"type": "main",
"index": 0
}
]
]
},
"Airtable-8": {
"main": [
[
{
"node": "Loop-Over-Items-5",
"type": "main",
"index": 0
}
]
]
},
"Text-Cleaning-11": {
"main": [
[
{
"node": "Text-Synthesis--12",
"type": "main",
"index": 0
}
]
]
},
"Setup-Keywords-13": {
"main": [
[
{
"node": "Create-Videos-Dataset-4",
"type": "main",
"index": 0
}
]
]
},
"Get-Videos-Data-3": {
"main": [
[
{
"node": "Loop-Over-Items-5",
"type": "main",
"index": 0
}
]
]
},
"Loop-Over-Items-5": {
"main": [
[
{
"node": "No-Operation-do-nothing-7",
"type": "main",
"index": 0
}
],
[
{
"node": "Text-Cleaning-11",
"type": "main",
"index": 0
}
]
]
},
"Text-Synthesis--12": {
"main": [
[
{
"node": "Airtable-8",
"type": "main",
"index": 0
}
]
]
},
"Schedule-Trigger-9": {
"main": [
[
{
"node": "Setup-Keywords-13",
"type": "main",
"index": 0
}
]
]
},
"Check-IF-Finished-2": {
"main": [
[
{
"node": "If-1",
"type": "main",
"index": 0
}
]
]
},
"Create-Videos-Dataset-4": {
"main": [
[
{
"node": "Check-IF-Finished-2",
"type": "main",
"index": 0
}
]
]
},
"Mistral-Cloud-Chat-Model-6": {
"ai_languageModel": [
[
{
"node": "Text-Synthesis--12",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
病毒式标题/缩略图生成
自动化病毒式YouTube标题和缩略图创建（FLUX.1 + Apify）
If
Set
Code
+
If
Set
Code
41 节点Nasser
人工智能
使用 GPT-4 和 Airtable 自动记录和备份工作流
使用 GPT-4 和 Airtable 自动记录和备份工作流
If
N8n
Set
+
If
N8n
Set
38 节点Guillaume Duvernay
AI 摘要总结
生成YouTube视频元数据（时间戳、标签、描述等）
生成YouTube视频元数据（时间戳、标签、描述等）
If
Code
Wait
+
If
Code
Wait
22 节点Nasser
人工智能
使用Airtable、OpenAI和Unipile
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
If
Set
Code
+
If
Set
Code
143 节点Ruben AI
客户培育
使用AI和Apify将LinkedIn帖子互动转化为合格潜在客户
使用AI和Apify将LinkedIn帖子互动转化为合格潜在客户
If
Set
Code
+
If
Set
Code
26 节点Anna Bui
潜在客户开发
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
If
Set
Code
+
If
Set
Code
48 节点Daniel Lianes
内容创作
