使用 Dumpling AI + GPT-4o 将 YouTube 转录转换为新闻稿草稿
中级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 8 个节点。主要使用 Gmail, HttpRequest, GoogleSheets, ManualTrigger, SplitInBatches 等节点。 使用Dumpling AI + GPT-4o将YouTube转录转换为新闻稿草稿
前置要求
- •Google 账号和 Gmail API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "zjl4xwZIDr6Ks1Zv",
"meta": {
"instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
"templateCredsSetupCompleted": true
},
"name": "使用 Dumpling AI + GPT-4o 将 YouTube 转录转换为新闻稿草稿",
"tags": [],
"nodes": [
{
"id": "1088af3c-161d-40ff-b69e-32cf609f214f",
"name": "手动触发器：启动工作流",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-80,
-20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5a8863d7-d13b-471e-900f-acdfa320fa42",
"name": "从 Google Sheets 读取 YouTube 链接",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-20
],
"parameters": {
"options": {
"returnFirstMatch": true
},
"filtersUI": {
"values": [
{
"lookupColumn": "blog post"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/182LztuSnqcPeYLtUOIG4LjDs2Nj7sDYS-sjMY90O3PM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/182LztuSnqcPeYLtUOIG4LjDs2Nj7sDYS-sjMY90O3PM/edit?usp=drivesdk",
"cachedResultName": "Youtube"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GaJqJHuS5mQxap7q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "81804ea4-ad1c-4c57-ad40-28645967da32",
"name": "循环：处理每个 YouTube 链接",
"type": "n8n-nodes-base.splitInBatches",
"position": [
360,
-20
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "5ec6ef71-4ca0-4ebc-b878-084337cafc3f",
"name": "Dumpling AI：获取 YouTube 转录",
"type": "n8n-nodes-base.httpRequest",
"position": [
580,
-20
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/get-youtube-transcript",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "videoUrl",
"value": "={{ $json.link }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "Dumpling AI-n8n"
}
},
"typeVersion": 4.2
},
{
"id": "facdab3c-bbca-4acb-862a-5179708d90e8",
"name": "GPT-4o：根据转录撰写新闻稿草稿",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
800,
-20
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "chatgpt-4o-latest",
"cachedResultName": "CHATGPT-4O-LATEST"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "\"Here is a transcript from a YouTube video. Please write a clear and engaging newsletter based on this transcript. Summarize the key ideas, insights, and tips shared in the video. Start with a short and catchy introduction that grabs attention. Structure the body of the newsletter with short, readable paragraphs that highlight the most valuable points. End with a simple call to action related to the video topic. Keep the tone friendly and professional, and make sure the content flows naturally for email readers. Do not include time stamps or speaker labels from the transcript. Focus on clarity and value.\"\n\nLet me know if you'd like the prompt tailored to a specific audience or niche."
},
{
"content": "=Transcript: {{ $json.transcript }}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "dd8NvMC6rvx8RITo",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.8
},
{
"id": "07b75a54-ceef-4ff7-8187-5fa49ecc84e4",
"name": "将新闻稿草稿记录到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1176,
55
],
"parameters": {
"columns": {
"value": {
"link": "={{ $('Read YouTube Links from Google Sheets').item.json.link }}",
"blog post": "={{ $json.message.content }}"
},
"schema": [
{
"id": "link",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "blog post",
"type": "string",
"display": true,
"required": false,
"displayName": "blog post",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"link"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/182LztuSnqcPeYLtUOIG4LjDs2Nj7sDYS-sjMY90O3PM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/182LztuSnqcPeYLtUOIG4LjDs2Nj7sDYS-sjMY90O3PM/edit?usp=drivesdk",
"cachedResultName": "Youtube"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GaJqJHuS5mQxap7q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "b7062444-db63-4e20-ae47-adea20a49289",
"name": "草稿准备就绪时发送邮件通知",
"type": "n8n-nodes-base.gmail",
"position": [
580,
-220
],
"webhookId": "e1f729ca-f0ef-4b1e-9399-7cd7993baff3",
"parameters": {
"sendTo": "example@gmail.com",
"message": "=Hello, \nThe newsletter based on the latest YouTube transcript has just been created successfully. You can now review, edit, or schedule it for distribution. Please check the draft and let me know if anything needs to be adjusted before it goes live.",
"options": {},
"subject": "Newsletter Draft Created from YouTube Transcript",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "j70r3RTMED1pgN3R",
"name": "Gmail account 2"
}
},
"typeVersion": 2.1
},
{
"id": "2e8320d4-655b-4dc1-afb7-47ff88c3cb19",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-560,
-340
],
"parameters": {
"width": 560,
"height": 580,
"content": "### 📨 YouTube → 新闻稿自动化"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "7910aaf8-f177-4b3a-af80-56c03d9a987b",
"connections": {
" Manual Trigger: Start Workflow": {
"main": [
[
{
"node": "Read YouTube Links from Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Loop: Process Each YouTube Link": {
"main": [
[
{
"node": " Send Email Notification When Draft is Ready",
"type": "main",
"index": 0
}
],
[
{
"node": " Dumpling AI: Get YouTube Transcript",
"type": "main",
"index": 0
}
]
]
},
" Dumpling AI: Get YouTube Transcript": {
"main": [
[
{
"node": "GPT-4o: Write Newsletter Draft from Transcript",
"type": "main",
"index": 0
}
]
]
},
"Log Newsletter Draft to Google Sheets": {
"main": [
[
{
"node": "Loop: Process Each YouTube Link",
"type": "main",
"index": 0
}
]
]
},
"Read YouTube Links from Google Sheets": {
"main": [
[
{
"node": "Loop: Process Each YouTube Link",
"type": "main",
"index": 0
}
]
]
},
"GPT-4o: Write Newsletter Draft from Transcript": {
"main": [
[
{
"node": "Log Newsletter Draft to Google Sheets",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Dumpling AI和GPT-4o生成YouTube视频创意
通过视频分析使用Dumpling AI和GPT-4o生成YouTube内容创意
Code
Wait
Gmail
+8
13 节点Yang
内容创作
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
Split Out
Form Trigger
Google Drive
+8
14 节点Yang
内容创作
基于 YouTube 视频的自主博客发布
使用 ChatGPT、Sheets、Apify、Pexels 和 WordPress 从 YouTube 视频自主发布博客
If
Set
Code
+18
80 节点Oriol Seguí
内容创作
使用GPT 5 Nano和Google Sheets的网站SEO常见问题生成器
使用GPT 5 Nano和Google Sheets的网站SEO常见问题生成器
Set
Xml
Code
+11
35 节点Oriol Seguí
内容创作
使用GPT-4o-mini的技术SEO审计与多格式报告（Sheets-Email）
使用GPT-4o-mini的技术SEO审计与多格式报告（Sheets/Email）
Set
Xml
Code
+14
45 节点Oriol Seguí
内容创作
使用Vizard AI和GPT-4.1将YouTube视频转换为社交媒体内容
使用Vizard AI和GPT-4.1将YouTube视频转换为社交媒体内容
Wait
Gmail
Limit
+9
14 节点Basil Irfan
内容创作
