提取YouTube字幕
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 23 个节点。主要使用 Code, Webhook, HttpRequest, GoogleSheets, RespondToWebhook 等节点。 使用AI和Google Sheets将YouTube转录转换为内容资产
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (23)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "bpbWpCDROyuqmTJj",
"meta": {
"instanceId": "7a73e968af152b9877d4c64b00e93bdf2a57741f130f9226cd4d7217ba6e5e6c"
},
"name": "提取 YouTube 字幕",
"tags": [],
"nodes": [
{
"id": "2b6e3f2c-8a81-4ca7-9536-5b1fef89dbeb",
"name": "主模板说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1648,
176
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "dff57349-a6f9-42f6-9b91-7683ccc86bf4",
"name": "Sheets 工作流说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-240,
384
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "8f3a3ba3-0499-408c-adb4-3e65178f6cfd",
"name": "Webhook 工作流说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-256,
800
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "71064376-c585-4019-a358-0a3e89011d0c",
"name": "提取 YouTube 视频 ID (Sheets)",
"type": "n8n-nodes-base.code",
"position": [
-672,
528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7b0fee45-7064-4f3e-8a23-0b021dd907c7",
"name": "获取视频字幕数据 (Sheets)",
"type": "n8n-nodes-base.httpRequest",
"position": [
-432,
528
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "d1cfb1d0-fbc3-4357-ae5e-7fdb91909e1e",
"name": "解析字幕文本 (Sheets)",
"type": "n8n-nodes-base.code",
"position": [
-208,
528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6bae5223-0367-41ad-8a06-f88d42606b82",
"name": "保存字幕到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
816,
528
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "240fdcab-65da-48c6-988d-969d0322846a",
"name": "监控 Google 表格中的 URL",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-880,
528
],
"parameters": {},
"typeVersion": 1
},
{
"id": "035884cc-8ab0-4174-bc29-e3354ef895ae",
"name": "OpenRouter 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
224,
672
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6223a1c3-31f8-4f55-9f30-cd4c6925d8f8",
"name": "返回字幕响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1088,
960
],
"parameters": {},
"typeVersion": 1.4
},
{
"id": "0f5f2a63-50c5-4257-9e97-9e9250bd2332",
"name": "Webhook 触发器（直接输入）",
"type": "n8n-nodes-base.webhook",
"position": [
-736,
960
],
"webhookId": "extract-youtube-transcript",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "abacc217-f0fb-45b3-af24-5812625a5a4d",
"name": "保存新脚本到表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
560,
528
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "fb2d24e2-6d2d-4786-be5e-c92ec8f0466a",
"name": "OpenRouter 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
160,
1120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1d183cb3-ed3e-413f-b0d2-f7caf9d032dd",
"name": "重写字幕 (webhook)",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
96,
960
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "12f903f6-e92c-4dfa-a10a-991b4366817f",
"name": "重写字幕 (sheets)",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-16,
528
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "f8a7ff53-30d3-4afa-93e7-583e1e1ae417",
"name": "提取 YouTube 视频 ID (Sheets)2",
"type": "n8n-nodes-base.code",
"position": [
-528,
960
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f06b39ad-2aed-4567-9f8f-370127ef5e69",
"name": "获取视频字幕数据 (Webhook)",
"type": "n8n-nodes-base.httpRequest",
"position": [
-320,
960
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "93c34915-a57c-4f6f-a2a0-d2ff7647412c",
"name": "解析字幕文本 (Webhook)",
"type": "n8n-nodes-base.code",
"position": [
-96,
960
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d33a8e70-d12c-4d8e-82de-dbc6d04e786f",
"name": "将 AI 输出解析为标题 (sheets)",
"type": "n8n-nodes-base.code",
"position": [
320,
528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8df66fcb-6b0d-4975-894d-cef0cccf0900",
"name": "将 AI 输出解析为标题 (webhook)",
"type": "n8n-nodes-base.code",
"position": [
432,
960
],
"parameters": {},
"typeVersion": 2
},
{
"id": "95a02c21-16f0-4874-a97e-f5e9188ae9b3",
"name": "保存新脚本到表格 (webhook)",
"type": "n8n-nodes-base.googleSheets",
"position": [
672,
960
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "b2d1f29e-4050-41c7-81ff-4e4c53805c60",
"name": "保存字幕到表格 (webhook)",
"type": "n8n-nodes-base.googleSheets",
"position": [
928,
960
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5b68722d-fe36-4af8-aa2c-cefa8e16abbf",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
-48
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "254763ad-2be0-459a-94bf-7ebdcf824298",
"connections": {
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "Rewrite The Transcript (sheets)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenRouter Chat Model1": {
"ai_languageModel": [
[
{
"node": "Rewrite The Transcript (webhook)",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Save New Script to Sheet": {
"main": [
[
{
"node": "Save Transcript to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Monitor Google Sheet for URLs": {
"main": [
[
{
"node": "Extract YouTube Video ID (Sheets)",
"type": "main",
"index": 0
}
]
]
},
"Parse Transcript Text (Sheets)": {
"main": [
[
{
"node": "Rewrite The Transcript (sheets)",
"type": "main",
"index": 0
}
]
]
},
"Webhook Trigger (Direct Input)": {
"main": [
[
{
"node": "Extract YouTube Video ID (Sheets)2",
"type": "main",
"index": 0
}
]
]
},
"Parse Transcript Text (Webhook)": {
"main": [
[
{
"node": "Rewrite The Transcript (webhook)",
"type": "main",
"index": 0
}
]
]
},
"Rewrite The Transcript (sheets)": {
"main": [
[
{
"node": "Parse AI Output Into Headings(sheets)",
"type": "main",
"index": 0
}
]
]
},
"Rewrite The Transcript (webhook)": {
"main": [
[
{
"node": "Parse AI Output Into Headings (webhook)",
"type": "main",
"index": 0
}
]
]
},
"Extract YouTube Video ID (Sheets)": {
"main": [
[
{
"node": "Fetch Video Transcript Data (Sheets)",
"type": "main",
"index": 0
}
]
]
},
"Save New Script to Sheet(webhook)": {
"main": [
[
{
"node": "Save Transcript to Sheet(webhook)",
"type": "main",
"index": 0
}
]
]
},
"Save Transcript to Sheet(webhook)": {
"main": [
[
{
"node": "Return Transcript Response",
"type": "main",
"index": 0
}
]
]
},
"Extract YouTube Video ID (Sheets)2": {
"main": [
[
{
"node": "Fetch Video Transcript Data (Webhook)",
"type": "main",
"index": 0
}
]
]
},
"Fetch Video Transcript Data (Sheets)": {
"main": [
[
{
"node": "Parse Transcript Text (Sheets)",
"type": "main",
"index": 0
}
]
]
},
"Fetch Video Transcript Data (Webhook)": {
"main": [
[
{
"node": "Parse Transcript Text (Webhook)",
"type": "main",
"index": 0
}
]
]
},
"Parse AI Output Into Headings(sheets)": {
"main": [
[
{
"node": "Save New Script to Sheet",
"type": "main",
"index": 0
}
]
]
},
"Parse AI Output Into Headings (webhook)": {
"main": [
[
{
"node": "Save New Script to Sheet(webhook)",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
来自多个招聘网站的求职自动化
使用 5 个招聘平台和 AI 简历生成器自动化求职与申请
If
Set
Code
+14
34 节点Gerald Denor
个人效率
性能报告生成器
基于AI的模拟求职面试：包含语音、评估和Gmail报告
Code
Gmail
Webhook
+4
9 节点Gerald Denor
AI 聊天机器人
自动化潜在客户呼叫：VAPI、Google Sheets记录与日历预约
自动化潜在客户呼叫：VAPI、Google Sheets记录与日历预约
Set
Code
Webhook
+7
13 节点Meak
内容创作
AI驱动的自动化求职与申请工作流
AI驱动的自动化求职与申请
If
Set
Code
+10
21 节点Gerald Denor
人力资源
使用SearchAPI和OpenAi将YouTube视频转换为LinkedIn帖子
使用SearchAPI和OpenAi将YouTube视频转换为LinkedIn帖子
If
Set
Webhook
+4
10 节点Gerald Denor
内容创作
基于AI的潜在客户资格评定与个性化触达（使用Relevance AI）
基于AI的潜在客户资格评定与个性化触达：使用Relevance AI
Set
Code
Gmail
+11
34 节点Diptamoy Barman
内容创作
工作流信息
难度等级
高级
节点数量23
分类2
节点类型9
作者
Gerald Denor
@dominixaiGerald Akhidenor is an AI Automation Lead Creative with 5 years of experience in AI automation consultancy. He specializes in n8n and API integrations, driving innovative automation solutions. As founder of DominixAI, Gerald combines creative vision and technical expertise to streamline processes and boost efficiency through cutting-edge AI technologies. Website: https://dominixai.com JobMonkey: https://trafficabc.com/jobmonkey-application-generator/
外部链接
在 n8n.io 查看 →
分享此工作流