创建智能关键词匹配的可搜索YouTube教育者目录
中级
这是一个Internal Wiki领域的自动化工作流，包含 13 个节点。主要使用 Set, Code, Webhook, DataTable, ManualTrigger 等节点。 创建智能关键词匹配的可搜索YouTube教育者目录
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc"
},
"nodes": [
{
"id": "a547a1f6-8c4d-41dc-8fb0-61f94b882533",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
576,
416
],
"webhookId": "1799531d-7245-422a-b069-c76ca29bdda2",
"parameters": {
"path": "1799531d-7245-422a-b069-c76ca29bdda2",
"options": {},
"httpMethod": "POST",
"responseMode": "lastNode"
},
"typeVersion": 2.1
},
{
"id": "562d6892-cdfa-4670-9f61-333f090587ef",
"name": "获取行",
"type": "n8n-nodes-base.dataTable",
"position": [
1024,
416
],
"parameters": {
"filters": {
"conditions": [
{
"keyName": "Description",
"keyValue": "={{ $json[\"topic\"] }}",
"condition": "like"
}
]
},
"matchType": "allConditions",
"operation": "get",
"dataTableId": {
"__rl": true,
"mode": "list",
"value": "SsbDaSjBiIsUNxQA",
"cachedResultUrl": "/projects/NkfS7q6flnrTbJ9e/datatables/SsbDaSjBiIsUNxQA",
"cachedResultName": "n8n_Educator_Videos"
}
},
"typeVersion": 1
},
{
"id": "e0078b00-477e-4df5-99f2-b24428903309",
"name": "响应 Webhook",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1392,
416
],
"parameters": {
"options": {}
},
"typeVersion": 1.4
},
{
"id": "7ff4e2fc-78ea-414b-a957-910590055016",
"name": "设置消息",
"type": "n8n-nodes-base.set",
"position": [
1232,
416
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f9cd1364-e892-4289-949f-ecb0893eade4",
"name": "Message",
"type": "string",
"value": "={{ $json[\"data\"] .map(v => `🎥 *${v[\"Video Title\"]}* 👤 ${v[\"Educator\"]} 🧩 Difficulty: ${v[\"Difficulty\"]} 🔗 ${v[\"YouTube Link\"]} 📝 ${v[\"Description\"]}` ) .join(\"\\n\\n\") }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b5289988-ae88-4875-a8cb-cc6608a969b2",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
576,
720
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6b95ed0f-35f7-486a-a6ed-9087b3e5dc50",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1008,
720
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "def3f50d-5702-4dbb-89be-1b09f0893748",
"name": "主要概览",
"type": "n8n-nodes-base.stickyNote",
"position": [
32,
240
],
"parameters": {
"color": 4,
"width": 400,
"height": 700,
"content": "## 🎓 n8n 学习中心 - YouTube 教育者搜索"
},
"typeVersion": 1
},
{
"id": "214bad22-5d24-41b9-8667-343fa9276289",
"name": "插入行",
"type": "n8n-nodes-base.dataTable",
"position": [
1264,
736
],
"parameters": {
"columns": {
"value": {
"Educator": "={{ $json.Educator }}",
"Difficulty": "={{ $json.Difficulty }}",
"Description": "={{ $json.Description }}",
"YouTubeLink": "={{ $json['YouTube Link'] }}",
"video_title": "={{ $json['Video Title'] }}"
},
"schema": [
{
"id": "Educator",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Educator",
"defaultMatch": false
},
{
"id": "video_title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "video_title",
"defaultMatch": false
},
{
"id": "Difficulty",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Difficulty",
"defaultMatch": false
},
{
"id": "YouTubeLink",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "YouTubeLink",
"defaultMatch": false
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Description",
"defaultMatch": false
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"dataTableId": {
"__rl": true,
"mode": "list",
"value": "SsbDaSjBiIsUNxQA",
"cachedResultUrl": "/projects/NkfS7q6flnrTbJ9e/datatables/SsbDaSjBiIsUNxQA",
"cachedResultName": "n8n_Educator_Videos"
}
},
"typeVersion": 1
},
{
"id": "a37f689d-27e9-4692-bd9e-7482b5d44704",
"name": "第一部分",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
256
],
"parameters": {
"width": 256,
"height": 144,
"content": "## 搜索 API"
},
"typeVersion": 1
},
{
"id": "c97717c5-fadd-4293-b8dd-d61473f320d7",
"name": "第二部分",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
272
],
"parameters": {
"width": 256,
"height": 128,
"content": "## 格式化响应"
},
"typeVersion": 1
},
{
"id": "8275cf1a-fa9d-4f2f-9920-2fdb7df994eb",
"name": "第三部分",
"type": "n8n-nodes-base.stickyNote",
"position": [
1408,
736
],
"parameters": {
"width": 256,
"height": 176,
"content": "## 数据库初始化"
},
"typeVersion": 1
},
{
"id": "236def7b-93a6-41ed-9150-86f516860706",
"name": "加载视频数据库",
"type": "n8n-nodes-base.code",
"position": [
800,
720
],
"parameters": {
"jsCode": "// Define your YouTube videos data here\nconst videos = [\n {\n Educator: \"Nate Herk\",\n \"Video Title\": \"Eleven Labs Voice Agent\",\n Difficulty: \"Intermediate\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=Je4EAscnKK0\",\n Description: \"Build a voice-powered AI agent in n8n using ElevenLabs.\"\n },\n {\n Educator: \"Jack Roberts\",\n \"Video Title\": \"The Most Profitable AI Skill in 2026 (RAG Masterclass)\",\n Difficulty: \"Advanced\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=dxeCH2duhMo\",\n Description: \"Learn how to build advanced RAG workflows inside n8n.\"\n },\n {\n Educator: \"Nate Herk\",\n \"Video Title\": \"Run ALL Your AI Locally in Minutes (LLMs, RAG, and more)\",\n Difficulty: \"Advanced\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=V_0dNE-H2gw\",\n Description: \"Tutorial on local AI setup with n8n, covering LLMs and RAG.\"\n },\n {\n Educator: \"Cole Medin\",\n \"Video Title\": \"n8n + Crawl4AI - Scrape ANY Website in Minutes with NO Code\",\n Difficulty: \"Intermediate\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=c5dw_jsGNBk\",\n Description: \"Use Crawl4AI with n8n to scrape any website easily.\"\n },\n {\n Educator: \"Nick Saraev\",\n \"Video Title\": \"The 9 Best Ways to Scrape Any Website in N8N\",\n Difficulty: \"Intermediate\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=y-eEbmNeFZo\",\n Description: \"Discover top scraping strategies for n8n workflows.\"\n },\n {\n Educator: \"Nick Saraev\",\n \"Video Title\": \"Every N8N JavaScript Function Explained (106 + 7 Extras)\",\n Difficulty: \"Advanced\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=Ksr_H30Oris\",\n Description: \"Full breakdown of n8n's JavaScript function capabilities.\"\n },\n {\n Educator: \"Sabrina Romanov\",\n \"Video Title\": \"This n8n AI Agent Avatar will AUTOMATE your Social Media\",\n Difficulty: \"Beginner\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=8sPYxqU1SoQ\",\n Description: \"Create an AI avatar automation system for social media with n8n.\"\n },\n {\n Educator: \"Sabrina Romanov\",\n \"Video Title\": \"n8n AI Avatar System for TikTok, Reels, and Shorts\",\n Difficulty: \"Intermediate\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=0T3FjaxDISI\",\n Description: \"Build a full video automation workflow for TikTok and Reels using n8n.\"\n },\n {\n Educator: \"n8n Team (Max Tkacz)\",\n \"Video Title\": \"Making n8n AI Agents Reliable (Human-in-the-Loop Demo)\",\n Difficulty: \"Advanced\",\n \"YouTube Link\": \"https://www.youtube.com/watch?v=NG9bFFNNmQg\",\n Description: \"Demonstration of human-in-the-loop reliability features for n8n AI agents.\"\n },\n {\n Educator: \"David Olusola\",\n \"Video Title\": \"Automate Lead Import from Google Sheets to Instantly Using N8N Data Table\",\n Difficulty: \"Intermediate\",\n \"YouTube Link\": \"https://youtu.be/c8iv1u_jxDY\",\n Description: \"Learn how to automate lead generation workflows using n8n Data Tables, Google Sheets, and Instantly for email outreach.\"\n }\n];\n\n// Convert each video to an individual item so n8n loops them automatically\nreturn videos.map(v => ({ json: v }));"
},
"typeVersion": 2
},
{
"id": "080ca0fd-af0a-4770-b692-6b31bef7fe86",
"name": "处理搜索词",
"type": "n8n-nodes-base.code",
"position": [
800,
416
],
"parameters": {
"jsCode": "let topic = $json.topic || \"\";\ntopic = topic.trim().toLowerCase();\n\n// Optional simple keyword logic\nif (topic.includes(\"talk\") || topic.includes(\"audio\") || topic.includes(\"voice\")) {\n topic = \"voice\";\n} else if (topic.includes(\"lead\")) {\n topic = \"lead gen\";\n} else if (topic.includes(\"scrape\") || topic.includes(\"data\")) {\n topic = \"scraping\";\n}\n\nreturn [{ topic }];\n"
},
"typeVersion": 2
}
],
"pinData": {},
"connections": {
"Webhook": {
"main": [
[
{
"node": "Process Search Term",
"type": "main",
"index": 0
}
]
]
},
"Get row(s)": {
"main": [
[
{
"node": "Set Message",
"type": "main",
"index": 0
}
]
]
},
"Insert row": {
"main": [
[
{
"node": "Load Video Database",
"type": "main",
"index": 0
}
]
]
},
"Set Message": {
"main": [
[
{
"node": "Respond to Webhook",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Insert row",
"type": "main",
"index": 0
}
]
]
},
"Load Video Database": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Process Search Term": {
"main": [
[
{
"node": "Get row(s)",
"type": "main",
"index": 0
}
]
]
},
"When clicking 'Execute workflow'": {
"main": [
[
{
"node": "Load Video Database",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 内部知识库
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
LinkedIn潜在客户生成与CRM自动化套件
使用Apify提取LinkedIn个人资料并为Google Sheets CRM自动生成潜在客户数据
If
Set
Code
+7
18 节点David Olusola
潜在客户开发
使用Google套件、PDF和邮件自动化商业保险提交
通过Google套件、PDF和邮件自动化商业保险提交流程
If
Set
Code
+10
37 节点David Olusola
文档提取
[模板] - 仪表板聊天
AI模型使用仪表板：追踪LLM工作流的令牌指标和成本
N8n
Set
Code
+12
30 节点Hugo
AI驱动YouTube产品评论自动分析
基于Apify和GPT的AI驱动YouTube产品评论自动分析
Set
Code
Gmail
+10
25 节点Oriol Seguí
市场调研
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
灵活新闻聚合器 - 多源集成、AI分析和可设置频道
多源新闻策展系统，集成Mistral AI分析、摘要和自定义频道
If
Set
Xml
+32
120 节点Hybroht
内容创作
工作流信息
难度等级
中级
节点数量13
分类1
节点类型8
作者
David Olusola
@dae221I design enterprise-grade automation systems that eliminate bottlenecks, cut manual work by 70%+, and unlock millions in lost revenue opportunities. My clients — typically achieve 5–10x ROI within the first 90 days. Currently partnering with select high-growth companies ready to scale faster with AI automation. david@daexai.com
外部链接
在 n8n.io 查看 →
分享此工作流