从播放列表中获取播客所有重要信息 100%免费✅
高级
这是一个Content Creation, AI Summarization领域的自动化工作流，包含 23 个节点。主要使用 Code, YouTube, Function, SplitOut, HttpRequest 等节点。 从播放列表中获取播客所有重要信息 100%免费✅
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (23)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "REDACTED",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "cdaf27d8-99d2-48c6-a888-0e88d6cd4277",
"name": "When clicking 'Execute workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-2580,
1000
],
"parameters": {},
"typeVersion": 1
},
{
"id": "26383450-32ec-441b-90e3-a96f27c80bc8",
"name": "YouTube Playlist",
"type": "n8n-nodes-base.youTube",
"position": [
-2240,
1000
],
"parameters": {
"part": [
"*",
"contentDetails",
"snippet",
"id",
"status"
],
"options": {},
"resource": "playlistItem",
"operation": "getAll",
"returnAll": true,
"playlistId": "REDACTED"
},
"credentials": {
"youTubeOAuth2Api": {
"id": "REDACTED",
"name": "REDACTED"
}
},
"typeVersion": 1
},
{
"id": "7972886c-7df7-4997-8f70-724393049e43",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2360,
680
],
"parameters": {
"color": 4,
"width": 940,
"height": 540,
"content": "## step 1"
},
"typeVersion": 1
},
{
"id": "b7bb0a36-2a5c-4b89-8838-1c2dabc95ace",
"name": "Google Sheets3",
"type": "n8n-nodes-base.googleSheets",
"position": [
800,
1000
],
"parameters": {
"columns": {
"value": {
"script": "={{ $('scirpt').item.json.script }}",
"summery": "={{ $json.output }}",
"row_number": "={{ $('Loop Over Items1').item.json.id }}",
"video titles": "={{ $('Loop Over Items1').item.json.title }}"
},
"schema": [
{
"id": "video titles",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "video titles",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "script",
"type": "string",
"display": true,
"required": false,
"displayName": "script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "summery",
"type": "string",
"display": true,
"required": false,
"displayName": "summery",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "REDACTED",
"cachedResultUrl": "REDACTED",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "REDACTED"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "REDACTED",
"name": "REDACTED"
}
},
"typeVersion": 4.6
},
{
"id": "77e2b1f9-7826-434c-9ec0-020fae299de2",
"name": "AI Agent1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
200,
840
],
"parameters": {
"text": "=Summarize the following podcast script.\nThe summary must be clear, well-organized, and comprehensive.\n\nInclude all important information, data, and key points from the script.\n\nDivide the summary into sections according to the main topics, ideas, or parts discussed in the podcast.\n\nFor each section, list all main points, facts, examples, and arguments mentioned.\n\nDo not omit any significant information or insight.\n\nThe summary should be detailed enough to give a full understanding of the podcast, but avoid unnecessary repetition or filler.\n\nUse headings and bullet points for clarity.\n\nThe result should be useful for someone who has not listened to the podcast but wants to understand all its important content and insights. podcast: {{ $json.firstTenSentences }}",
"options": {},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "96afae6c-b9aa-4511-8189-ec86ad1c6736",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
640,
680
],
"parameters": {
"color": 4,
"width": 440,
"height": 540,
"content": "## step 5 : 📊 **Google Sheets3**\n\n## Updates a Google Sheet with video titles, scripts, summaries, and row numbers. "
},
"typeVersion": 1
},
{
"id": "4dffe6f7-35f0-4532-8572-538c3cd72a1c",
"name": "Loop Over Items1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1100,
1000
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "2ab97a51-3cfc-44c9-bdb0-d10018d59f38",
"name": "Groq Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGroq",
"position": [
160,
1040
],
"parameters": {
"model": "llama-3.1-8b-instant",
"options": {}
},
"credentials": {
"groqApi": {
"id": "REDACTED",
"name": "REDACTED"
}
},
"typeVersion": 1
},
{
"id": "21697e90-111c-4588-96cb-b73cd24ad93a",
"name": "scirpt",
"type": "n8n-nodes-base.code",
"position": [
-420,
1000
],
"parameters": {
"jsCode": "// Combine all \"text\" fields from the content array into one string\nlet script = '';\n\n// Loop through all input items\nfor (const item of items) {\n if (item.json.content && Array.isArray(item.json.content)) {\n for (const segment of item.json.content) {\n if (segment.text) {\n script += segment.text + ' ';\n }\n }\n }\n}\n\nscript = script.trim();\n\nreturn [\n {\n json: {\n script\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "b58ffdc1-991c-4be4-812c-547bb355b3d7",
"name": "supadata",
"type": "n8n-nodes-base.httpRequest",
"position": [
-720,
1000
],
"parameters": {
"url": "=https://api.supadata.ai/v1/transcript?url=https://youtu.be/{{ $json.videoId}}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "x-api-key",
"value": "REDACTED"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "9f5f991e-ef3b-4f79-869b-7c8104b8b14b",
"name": "titles/URL",
"type": "n8n-nodes-base.function",
"position": [
-1940,
1000
],
"parameters": {
"functionCode": "// Extract video URLs, titles, and add an id starting from 2\nreturn items.map((item, index) => {\n const videoId = item.json.snippet.resourceId.videoId;\n const title = item.json.snippet.title;\n return {\n json: {\n id: index + 2,\n url: `https://www.youtube.com/watch?v=${videoId}`,\n title: title\n }\n };\n});\n"
},
"typeVersion": 1
},
{
"id": "e3ab10da-11a0-459d-9afd-17003da31d2d",
"name": "video ID",
"type": "n8n-nodes-base.code",
"position": [
-1640,
1000
],
"parameters": {
"jsCode": "return items.map((item, index) => {\n // Get the URL and title from the input\n const url = item.json.url;\n const title = item.json.title || null;\n // Extract the video ID from the URL\n let videoId = null;\n if (url && url.includes('v=')) {\n videoId = url.split('v=')[1].split('&')[0];\n }\n // id starts from 1; change to index+2 if you want to start from 2\n return {\n json: {\n id: index + 2,\n videoId,\n title\n }\n };\n});\n"
},
"typeVersion": 2
},
{
"id": "41a59817-9083-4a88-ab3e-b5aa8ed77d85",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
-140,
1000
],
"parameters": {
"jsCode": "// Get the script text\nconst script = items[0].json.script || \"\";\n\n// Split into sentences using a regular expression\nconst sentences = script.match(/[^\\.!\\?]+[\\.!\\?]+/g) || [];\n\n// Get the first 10 sentences (or fewer if less than 10)\nconst firstTen = sentences.slice(0, 5).join(' ').trim();\n\nreturn [\n {\n json: {\n firstTenSentences: firstTen\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "54fb0421-9357-40eb-8c0e-2b8f62445f8e",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
-1300,
1000
],
"parameters": {
"options": {},
"fieldToSplitOut": "id, videoId, title"
},
"typeVersion": 1
},
{
"id": "ad64708a-c09e-4aff-8e55-baf807d10d60",
"name": "YouTube Playlist Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2320,
760
],
"parameters": {
"color": 5,
"width": 260,
"height": 420,
"content": "📺 **YouTube Playlist**\n\nFetches all videos from a specific YouTube playlist.\n\n**How to change:** Change the `playlistId` to use a different playlist. Adjust `part` to fetch different details. Change credentials for another YouTube account."
},
"typeVersion": 1
},
{
"id": "f0d47980-eec9-4b98-af59-cc17a722d8dc",
"name": "titles/URL Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2020,
760
],
"parameters": {
"color": 5,
"width": 260,
"height": 420,
"content": "🔗 **titles/URL (Function Node)**\n\nExtracts video URLs and titles from the playlist data and assigns a row ID.\n"
},
"typeVersion": 1
},
{
"id": "0db1c271-61fc-4626-9059-ed0fc47cbfb9",
"name": "video ID Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1720,
760
],
"parameters": {
"color": 5,
"width": 260,
"height": 420,
"content": "🆔 **video ID (Code Node)**\n\nExtracts the video ID from each YouTube URL.\n"
},
"typeVersion": 1
},
{
"id": "1473ffb7-7359-4f69-bee7-9b0e8cda7144",
"name": "supadata Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
740
],
"parameters": {
"color": 5,
"width": 260,
"height": 440,
"content": "📝 **supadata (HTTP Request Node)**\n\nCalls the Supadata API to get the transcript for each video.\n\n**How to change:** Update the API URL or key if the service changes. Modify request headers or parameters for other APIs."
},
"typeVersion": 1
},
{
"id": "30f4dd38-5f1f-4ec9-886b-8cf1f9cc1e63",
"name": "scirpt Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
740
],
"parameters": {
"color": 5,
"height": 440,
"content": "📜 **scirpt (Code Node)**\n\nCombines the transcript segments into a single script string.\n\n**How to change:** Change logic to format or preprocess the script differently (e.g., filter out certain lines)."
},
"typeVersion": 1
},
{
"id": "276763d4-1f30-4736-b40d-21ed003caa40",
"name": "Code1 Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
740
],
"parameters": {
"color": 5,
"height": 440,
"content": "✂️ **Code1 (Code Node)**\n\nExtracts the first few sentences from the script for summarization.\n\n**How to change:** Adjust the number of sentences extracted. Change the splitting logic for different transcript formats."
},
"typeVersion": 1
},
{
"id": "d1a7650a-b728-4add-9508-4fa64519061f",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1360,
680
],
"parameters": {
"color": 4,
"width": 440,
"height": 540,
"content": "## step 2"
},
"typeVersion": 1
},
{
"id": "0aa6aed7-b67e-40a1-89d9-b6d321f31448",
"name": "Sticky Note12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-860,
680
],
"parameters": {
"color": 4,
"width": 940,
"height": 540,
"content": "## step 3"
},
"typeVersion": 1
},
{
"id": "e4c4417f-e94f-40f1-84a0-b9615401fb4c",
"name": "Sticky Note13",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
680
],
"parameters": {
"color": 4,
"width": 480,
"height": 540,
"content": "## step 4 : 🤖 **Groq Chat Model (LLM Node)**\n\nchange the prompt if you want or change the ai model"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"41a59817-9083-4a88-ab3e-b5aa8ed77d85": {
"main": [
[
{
"node": "77e2b1f9-7826-434c-9ec0-020fae299de2",
"type": "main",
"index": 0
}
]
]
},
"21697e90-111c-4588-96cb-b73cd24ad93a": {
"main": [
[
{
"node": "41a59817-9083-4a88-ab3e-b5aa8ed77d85",
"type": "main",
"index": 0
}
]
]
},
"b58ffdc1-991c-4be4-812c-547bb355b3d7": {
"main": [
[
{
"node": "21697e90-111c-4588-96cb-b73cd24ad93a",
"type": "main",
"index": 0
}
]
]
},
"e3ab10da-11a0-459d-9afd-17003da31d2d": {
"main": [
[
{
"node": "54fb0421-9357-40eb-8c0e-2b8f62445f8e",
"type": "main",
"index": 0
}
]
]
},
"77e2b1f9-7826-434c-9ec0-020fae299de2": {
"main": [
[
{
"node": "b7bb0a36-2a5c-4b89-8838-1c2dabc95ace",
"type": "main",
"index": 0
}
]
]
},
"54fb0421-9357-40eb-8c0e-2b8f62445f8e": {
"main": [
[
{
"node": "4dffe6f7-35f0-4532-8572-538c3cd72a1c",
"type": "main",
"index": 0
}
]
]
},
"9f5f991e-ef3b-4f79-869b-7c8104b8b14b": {
"main": [
[
{
"node": "e3ab10da-11a0-459d-9afd-17003da31d2d",
"type": "main",
"index": 0
}
]
]
},
"b7bb0a36-2a5c-4b89-8838-1c2dabc95ace": {
"main": [
[
{
"node": "4dffe6f7-35f0-4532-8572-538c3cd72a1c",
"type": "main",
"index": 0
}
]
]
},
"2ab97a51-3cfc-44c9-bdb0-d10018d59f38": {
"ai_languageModel": [
[
{
"node": "77e2b1f9-7826-434c-9ec0-020fae299de2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"4dffe6f7-35f0-4532-8572-538c3cd72a1c": {
"main": [
[],
[
{
"node": "b58ffdc1-991c-4be4-812c-547bb355b3d7",
"type": "main",
"index": 0
}
]
]
},
"26383450-32ec-441b-90e3-a96f27c80bc8": {
"main": [
[
{
"node": "9f5f991e-ef3b-4f79-869b-7c8104b8b14b",
"type": "main",
"index": 0
}
]
]
},
"cdaf27d8-99d2-48c6-a888-0e88d6cd4277": {
"main": [
[
{
"node": "26383450-32ec-441b-90e3-a96f27c80bc8",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
FalAI_SeeDanceV1.0_英文模板
使用GPT-4o、Fal.AI Seedance和音频从文本提示生成电影级视频
If
Code
Wait
+
If
Code
Wait
38 节点Jaruphat J.
内容创作
Facebook页面评论管理机器人：回复、删除、封禁和通知
AI驱动的Facebook评论管理：自动回复、删除、封禁和通知
If
Set
Code
+
If
Set
Code
59 节点SpaGreen Creative
社交媒体
实时 - 使用Gemini和Creatomate自动化病毒式AI视频制作与发布
使用Gemini和Creatomate自动化AI视频创作与多平台发布
Set
Code
Wait
+
Set
Code
Wait
47 节点Intuz
内容创作
使用 Gmail、Groq AI 和 Google Sheets 自动化邮件过滤与 AI
使用 Gmail、Groq AI 和 Google Sheets 自动化邮件过滤与 AI 摘要
If
Code
Gmail Trigger
+
If
Code
Gmail Trigger
14 节点ARRE
工单管理
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+
If
Ftp
Set
113 节点I versus AI
其他
AI驱动博客自动化
AI驱动博客自动化：使用GPT-4生成并发布SEO文章至WordPress和Twitter
If
Set
Code
+
If
Set
Code
144 节点Jay Emp0
内容创作
工作流信息
难度等级
高级
节点数量23
分类2
节点类型11
作者
ARRE
@arreAutomation Architect | I transform complexity into simplicity Building intelligent n8n workflows that do your heavy lifting in minutes, not hours. My mission: Eliminate repetitive tasks, streamline your operations, and give you back the most valuable resource – your time. Let’s make work feel lighter together.
外部链接
在 n8n.io 查看 →
分享此工作流