使用Apify和DeepSeek AI批量分析YouTube频道内容至Google表格
高级
这是一个自动化工作流，包含 33 个节点。主要使用 If, Set, Code, Wait, Gmail 等节点。 使用Apify和DeepSeek AI批量分析YouTube频道内容至Google表格
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (33)
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "e4f10bef48753951b827b1628c136c25720855dd405c916d09e788211699198e",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b691c282-853a-4b97-af07-c410654538ad",
"name": "获取爬虫状态",
"type": "n8n-nodes-base.httpRequest",
"position": [
320,
560
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/streamers~youtube-scraper/runs/last?token={{ $('Parameters').item.json.Apify_API }}",
"method": "=GET",
"options": {}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "bb9ce463-e613-4aeb-a01e-5b865b475281",
"name": "启动YouTube爬虫",
"type": "n8n-nodes-base.httpRequest",
"position": [
-128,
640
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/streamers~youtube-scraper/runs?token={{ $('Parameters').item.json.Apify_API }}",
"method": "POST",
"options": {},
"jsonBody": "={\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 \"maxResultStreams\": 0,\n \"maxResults\": {{ $('Parameters').item.json.Total_number_video }},\n \"maxResultsShorts\": 0,\n \"preferAutoGeneratedSubtitles\": true,\n \"saveSubsToKVS\": true,\n \"startUrls\": [\n {\n \"url\": \"{{ $('Parameters').item.json.Youtuber_MainPage_URL }}\",\n \"method\": \"GET\"\n }\n ]\n}",
"sendBody": true,
"specifyBody": "json"
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "ecdf2cac-ffca-4fcd-b840-1cd7d0fd9c8f",
"name": "检查爬虫状态",
"type": "n8n-nodes-base.if",
"position": [
544,
640
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e0da6d3b-2eb2-44b3-8115-455361d77513",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.data.status }}",
"rightValue": "SUCCEEDED"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b6c12e18-f115-4a76-a1bb-2ce1a0bbab4e",
"name": "检索爬取的数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
768,
640
],
"parameters": {
"url": "=https://api.apify.com/v2/acts/streamers~youtube-scraper/runs/last/dataset/items?token={{ $('Parameters').item.json.Apify_API }}&format=json&status=SUCCEEDED",
"method": "=GET",
"options": {}
},
"retryOnFail": true,
"typeVersion": 4.2
},
{
"id": "5940ced6-dc18-495a-9996-2a3a79f23089",
"name": "内容分析代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
576,
1344
],
"parameters": {
"text": "=id:{{ $('Process_Each_Video').item.json.VideoID }}\ntitle:{{ $('Process_Each_Video').item.json['\\uFEFFTitle'] }}\nsubtitle:{{ $('Select_Subtitle_Language').item.json.srt }}\ndescription:{{ $('Process_Each_Video').item.json.Description }}",
"options": {
"systemMessage": "=# Role: Video Content Summarization Specialist\n\n## Profile\n- language: English\n- description: Specializes in analyzing YouTube video transcripts and delivering accurate, structured content summaries across multiple domains.\n- background: Years of experience in content analysis; familiar with the needs of education, research, and professional training contexts.\n- personality: Meticulous, logical, and user-oriented.\n- expertise: Video content analysis, information extraction, structured summary writing.\n- target_audience: Content creators, researchers, educators, and industry professionals.\n\n## Skills\n\n1. Core Summarization Skills\n - Content Analysis: Rapidly identify core themes and key information points in the video.\n - Logical Organization: Present key points in a structured manner ordered by importance.\n - Terminology Handling: Appropriately preserve essential technical terms and critical data.\n\n## Rules\n\n1. Summary Principles:\n - Accuracy: Base strictly on the original transcript; do not add subjective speculation.\n - Completeness: Cover all viewpoints and insights from the video; no word-count limit.\n - Coherence: Segment and express according to the content’s inherent logic.\n\n2. Constraints:\n - Do not include any timestamps.\n - Do not omit essential technical terms.\n - Do not include irrelevant content.\n\n## Workflows\n\n- Objective: Provide high-quality video content summaries for the specified audience.\n- Step 1: Read the transcript thoroughly and identify core themes and key viewpoints.\n- Step 2: Organize the key points in a logical sequence to ensure coherence.\n- Step 3: If no video transcript exists, output only `null` with no additional explanation.\n- Step 4: You must output using the following format:\n{\n \"VideoID\": \"the video's unique id\",\n \"Field\": \"the domain/category the video belongs to\",\n \"Output\": \"the analysis result\"\n}\n\n## Initialization\nAs a Video Content Summarization Specialist, you must adhere to the Rules above and execute the task according to the Workflows.\n"
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 2.1
},
{
"id": "75b5d321-80c6-4e7c-8290-34d99aea61f6",
"name": "输出解析器自动修复",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
640,
1536
],
"parameters": {
"options": {
"prompt": "Instructions:\n--------------\n{instructions}\n--------------\nCompletion:\n--------------\n{completion}\n--------------\n\nAbove, the Completion did not satisfy the constraints given in the Instructions.\nError:\n--------------\n{error}\n--------------\n\nPlease try again. Please only respond with an answer that satisfies the constraints laid out in the Instructions:"
}
},
"typeVersion": 1
},
{
"id": "2428bea8-507e-4c35-9f74-d0830f380398",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
736,
1664
],
"parameters": {
"jsonSchemaExample": "{\n \"VideoID\": \"the video's unique id\",\n \"Field\": \"the domain/category the video belongs to\",\n \"Output\": \"the analysis result\"\n}"
},
"typeVersion": 1.3
},
{
"id": "7958ee72-77b0-434e-800e-d20303e99ba0",
"name": "数据处理脚本",
"type": "n8n-nodes-base.code",
"position": [
944,
1408
],
"parameters": {
"jsCode": "const results = [];\n\nfor (const item of items) {\n const data = item.json.output; // 取出内部的 output 对象\n\n results.push({\n json: {\n VideoID: data.VideoID,\n Field: data.Field,\n Summary: data.Output\n }\n });\n}\n\nreturn results;\n"
},
"typeVersion": 2
},
{
"id": "c42a9ec1-919c-4de9-9550-c58b922c585c",
"name": "等待15秒",
"type": "n8n-nodes-base.wait",
"position": [
96,
640
],
"webhookId": "5c354cd1-bb19-43e7-bb98-7ef5b9a05b96",
"parameters": {
"amount": 15
},
"typeVersion": 1.1
},
{
"id": "b2a81c4d-b6d1-43d1-b19b-6c5935a4b872",
"name": "转换为文件",
"type": "n8n-nodes-base.convertToFile",
"position": [
992,
640
],
"parameters": {
"options": {}
},
"typeVersion": 1.1
},
{
"id": "d4f8de19-8c86-43e7-bb69-414c560533dd",
"name": "上传到Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
1184,
736
],
"parameters": {
"name": "={{ $('Parameters').item.json.Storing_Name }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "k3pd0AH9zJsf5yrF",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "94dc0d4d-4d38-4229-b857-40189710e9b0",
"name": "从文件提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-448,
1552
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "28641279-d6e3-4836-9b33-780ea0138ad7",
"name": "从Google Drive下载",
"type": "n8n-nodes-base.googleDrive",
"position": [
-672,
1552
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Upload_To_Google_Drive').item.json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "k3pd0AH9zJsf5yrF",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 3
},
{
"id": "b58658ce-ef88-476e-a610-61be50e99daf",
"name": "处理每个视频",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-32,
1552
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "4d0ee473-3d4d-41a3-ac43-5215e5f7315d",
"name": "选择字幕语言",
"type": "n8n-nodes-base.code",
"position": [
208,
1424
],
"parameters": {
"jsCode": "const items = $input.all();\n\nconst isEnglish = (val) => {\n if (typeof val !== 'string') return false;\n const v = val.toLowerCase();\n return v === 'en' || v === 'english' || v.startsWith('en-') || v.startsWith('en_');\n};\n\nconst out = items.map(({ json: src }) => {\n let A = Number(src.A ?? 0); // select the A-th English track (0 = first)\n let i = 0, res = null;\n\n while (true) {\n const lang = src[`subtitles.${i}.language`];\n if (lang === undefined) break;\n\n if (isEnglish(lang)) {\n if (A === 0) {\n res = {\n index: i,\n language: lang,\n srt: src[`subtitles.${i}.srt`],\n srtUrl: src[`subtitles.${i}.srtUrl`],\n };\n break;\n }\n A--;\n }\n i++;\n }\n\n return { json: res ?? { index: null, language: null, srt: null, srtUrl: null } };\n});\n\nreturn out;"
},
"typeVersion": 2
},
{
"id": "66c57b93-9c38-458d-9ad0-8ffc1cb1f762",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
32
],
"parameters": {
"color": 6,
"width": 496,
"height": 864,
"content": "## 1) 输入与初始化"
},
"typeVersion": 1
},
{
"id": "b37d3864-79e8-47f9-8520-a44f75f19946",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1600,
592
],
"parameters": {
"width": 816,
"height": 688,
"content": "# 🚀 YouTuber爬虫 — 快速入门指南"
},
"typeVersion": 1
},
{
"id": "25bff827-a101-4615-b001-babf3f205fe8",
"name": "参数",
"type": "n8n-nodes-base.formTrigger",
"position": [
-576,
720
],
"webhookId": "45bb5142-6b1c-4a54-98fe-b44a39ad0548",
"parameters": {
"options": {},
"formTitle": "={{ $workflow.name }}",
"formFields": {
"values": [
{
"fieldLabel": "Youtuber_MainPage_URL",
"placeholder": "This parameters determines which YouTuber’s channel will be scraped.\nexample: https://www.youtube.com/@n8n-io",
"requiredField": true
},
{
"fieldType": "number",
"fieldLabel": "Total_number_video",
"placeholder": "This parameters determines how much video will be scraped. \n(Recommended: fill in the total number of videos currently on the YouTuber’s channel.)",
"requiredField": true
},
{
"fieldLabel": "Storing_Name",
"placeholder": "This parameter determines the name used for storing the file/data.\nexample: n8n.io"
},
{
"fieldLabel": "Apify_API",
"placeholder": "Fill in your Apify API key.",
"requiredField": true
},
{
"fieldLabel": "Email",
"placeholder": "This parameter specifies the email address to receive notifications when the workflow is completed."
}
]
},
"formDescription": "=Please complete all the parameters listed below."
},
"typeVersion": 2.3
},
{
"id": "c128f91e-9eff-4d16-8478-09564392afe9",
"name": "发送消息",
"type": "n8n-nodes-base.gmail",
"position": [
208,
1856
],
"webhookId": "880710a2-1482-4dde-8a41-c5024dd6c625",
"parameters": {
"sendTo": "={{ $('Parameters').item.json.Email }}",
"message": "= {{ $workflow.name }} finished at 🕓{{ new Date().toLocaleString(\"en-CA\", { hour12: false }).replace(',', '') }}\n",
"options": {
"appendAttribution": true
},
"subject": "=🎉 {{ $workflow.name }} Done~"
},
"credentials": {
"gmailOAuth2": {
"id": "jCTNCiXplqBJRbmj",
"name": "Gmail account"
}
},
"executeOnce": true,
"retryOnFail": true,
"typeVersion": 2.1
},
{
"id": "746238f0-288f-4be9-9378-1499a825045a",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
32
],
"parameters": {
"color": 2,
"width": 1120,
"height": 864,
"content": "## 2) 频道抓取与状态循环"
},
"typeVersion": 1
},
{
"id": "decd4294-a551-4283-a260-b2b0b3db1e8d",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
928,
32
],
"parameters": {
"color": 6,
"width": 432,
"height": 864,
"content": "## 3A) 原始备份到Google Drive"
},
"typeVersion": 1
},
{
"id": "a61ec128-8f33-4277-84d1-8822d87152f6",
"name": "便签说明4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-112,
928
],
"parameters": {
"color": 3,
"width": 496,
"height": 896,
"content": "## 5) 批量处理与英文字幕选择"
},
"typeVersion": 1
},
{
"id": "b2c5aaed-db92-4384-ad8d-8eaef5a17113",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
928
],
"parameters": {
"color": 4,
"width": 704,
"height": 896,
"content": "## 6) AI摘要流水线（结构化）"
},
"typeVersion": 1
},
{
"id": "fc98de8f-63c6-46ae-9fac-8b1772f279ab",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1120,
928
],
"parameters": {
"color": 5,
"width": 640,
"height": 896,
"content": "## 7) 表格写入与温和限流"
},
"typeVersion": 1
},
{
"id": "4f7fc3dd-8439-4e2d-b110-0cf889c01502",
"name": "## 为什么选择 4o 模型？👆",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
1728
],
"parameters": {
"color": 5,
"width": 400,
"height": 272,
"content": "## 9) 完成通知（邮件）"
},
"typeVersion": 1
},
{
"id": "3367d34e-7529-4fa6-959e-4eb6a038be32",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
928
],
"parameters": {
"color": 4,
"width": 416,
"height": 896,
"content": "## 4) 重新加载与结构化提取"
},
"typeVersion": 1
},
{
"id": "d1dced07-8e95-4174-a2f5-9c00fb3b4789",
"name": "从何处开始？",
"type": "n8n-nodes-base.code",
"disabled": true,
"position": [
-256,
1552
],
"parameters": {
"jsCode": "const START = 0;\n// ================================\nif (!Array.isArray(items)) return items;\n\nconst n = items.length;\nconst s = Number.isFinite(START) && START >= 0 ? START : 0;\n\nif (s >= n) return []; \n\nreturn items.slice(s); "
},
"typeVersion": 2
},
{
"id": "90b79d9c-259c-4508-b1d1-a005dfb351da",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1600,
1360
],
"parameters": {
"color": 3,
"width": 816,
"height": 416,
"content": "## （高级）工作流失败时从Drive CSV恢复"
},
"typeVersion": 1
},
{
"id": "e03152a8-1392-4d92-b067-4d261209289a",
"name": "等待2秒",
"type": "n8n-nodes-base.wait",
"position": [
1584,
1616
],
"webhookId": "4e77c4b0-3c7d-402f-9297-212327f7d4ae",
"parameters": {
"amount": 2
},
"typeVersion": 1.1
},
{
"id": "6561ca4a-68f5-4b05-aacf-c76484d663f8",
"name": "写入内容数据到表格1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1408,
1424
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "VideoID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "VideoID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Duration",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Duration",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Likes",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Field",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Field",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"VideoID"
],
"attemptToConvertTypes": false,
"convertFieldsToString": true
},
"options": {
"cellFormat": "RAW"
},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "={{ $('Parameters').item.json.Storing_Name }}"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc/edit?usp=drivesdk",
"cachedResultName": "youtuber scrape"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i2QQ5h70aiZ7H0s3",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 4.7
},
{
"id": "8116cbb0-9252-4b19-bb70-44209144512a",
"name": "DeepSeek 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatDeepSeek",
"position": [
528,
1664
],
"parameters": {
"options": {}
},
"credentials": {
"deepSeekApi": {
"id": "XqASxHFKyMoe6qdX",
"name": "DeepSeek account"
}
},
"typeVersion": 1
},
{
"id": "6493519d-22c2-4450-9b2c-1699e1861252",
"name": "提取所有数据",
"type": "n8n-nodes-base.set",
"position": [
1200,
1408
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3c8320dd-b38e-49ff-9b3c-ca88f469ccad",
"name": "VideoID",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.id }}"
},
{
"id": "2b00dcfd-b55b-47e7-a11e-790389c90a8c",
"name": "Title",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json['\\uFEFFtitle'] }}"
},
{
"id": "2ffc02ec-ae5e-440c-8e5f-1b9083dc44b0",
"name": "Duration",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.duration }}"
},
{
"id": "adc143bc-2934-4a39-a96d-e996e2b64fc2",
"name": "Date",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.date }}"
},
{
"id": "fd284be2-851b-4da9-bb09-d368e89ff590",
"name": "URL",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.url }}"
},
{
"id": "1ae57f58-5908-468c-803d-857dd72181be",
"name": "Likes",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.likes }}"
},
{
"id": "e66dedb2-609c-4d2b-8c0a-e4a8451dddb2",
"name": "Description",
"type": "string",
"value": "={{ $('Process_Each_Video').item.json.text }}"
},
{
"id": "8405d779-9f1a-4b30-9a8f-3fccc6677f22",
"name": "Field",
"type": "string",
"value": "={{ $('Data_Processing_Script').item.json.Field }}"
},
{
"id": "a11425da-157d-4bd3-a02f-ea0ae44a7034",
"name": "Summary",
"type": "string",
"value": "={{ $('Data_Processing_Script').item.json.Summary }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2508e77d-61d2-4d5d-bdc8-71544e9370a1",
"name": "创建表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
-368,
688
],
"parameters": {
"title": "={{ $('Parameters').item.json.Storing_Name }}",
"options": {},
"operation": "create",
"documentId": {
"__rl": true,
"mode": "list",
"value": "1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rvEoecYv3awJNLa41W7RwRb6YM1L8eZ6t65A0Q6wnIc/edit?usp=drivesdk",
"cachedResultName": "youtuber scrape"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "i2QQ5h70aiZ7H0s3",
"name": "owen"
}
},
"retryOnFail": true,
"typeVersion": 4.7,
"alwaysOutputData": true
}
],
"pinData": {},
"connections": {
"Parameters": {
"main": [
[
{
"node": "Create_Sheet",
"type": "main",
"index": 0
}
]
]
},
"start from?": {
"main": [
[
{
"node": "Process_Each_Video",
"type": "main",
"index": 0
}
]
]
},
"Create_Sheet": {
"main": [
[
{
"node": "Start_YouTube_Scraper",
"type": "main",
"index": 0
}
]
]
},
"Wait_2_Seconds": {
"main": [
[
{
"node": "Process_Each_Video",
"type": "main",
"index": 0
}
]
]
},
"Convert_To_File": {
"main": [
[
{
"node": "Upload_To_Google_Drive",
"type": "main",
"index": 0
}
]
]
},
"Extract_Alldata": {
"main": [
[
{
"node": "Write_Contentdata_To_Sheet1",
"type": "main",
"index": 0
}
]
]
},
"Wait_15_Seconds": {
"main": [
[
{
"node": "Get_Scraper_Status",
"type": "main",
"index": 0
}
]
]
},
"Extract_From_File": {
"main": [
[
{
"node": "start from?",
"type": "main",
"index": 0
}
]
]
},
"Get_Scraper_Status": {
"main": [
[
{
"node": "Check_Scraper_Status",
"type": "main",
"index": 0
}
]
]
},
"Process_Each_Video": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
],
[
{
"node": "Select_Subtitle_Language",
"type": "main",
"index": 0
}
]
]
},
"DeepSeek Chat Model": {
"ai_languageModel": [
[
{
"node": "Content_Analysis_Agent",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Output_Parser_Auto_Fix",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Check_Scraper_Status": {
"main": [
[
{
"node": "Retrieve_Scraped_Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait_15_Seconds",
"type": "main",
"index": 0
}
]
]
},
"Retrieve_Scraped_Data": {
"main": [
[
{
"node": "Convert_To_File",
"type": "main",
"index": 0
}
]
]
},
"Start_YouTube_Scraper": {
"main": [
[
{
"node": "Wait_15_Seconds",
"type": "main",
"index": 0
}
]
]
},
"Content_Analysis_Agent": {
"main": [
[
{
"node": "Data_Processing_Script",
"type": "main",
"index": 0
}
]
]
},
"Data_Processing_Script": {
"main": [
[
{
"node": "Extract_Alldata",
"type": "main",
"index": 0
}
]
]
},
"Output_Parser_Auto_Fix": {
"ai_outputParser": [
[
{
"node": "Content_Analysis_Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Upload_To_Google_Drive": {
"main": [
[
{
"node": "Download_From_Google_Drive",
"type": "main",
"index": 0
}
]
]
},
"Select_Subtitle_Language": {
"main": [
[
{
"node": "Content_Analysis_Agent",
"type": "main",
"index": 0
}
]
]
},
"Structured_Output_Parser": {
"ai_outputParser": [
[
{
"node": "Output_Parser_Auto_Fix",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Download_From_Google_Drive": {
"main": [
[
{
"node": "Extract_From_File",
"type": "main",
"index": 0
}
]
]
},
"Write_Contentdata_To_Sheet1": {
"main": [
[
{
"node": "Wait_2_Seconds",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
自动化学术论文元数据及变量提取，从Gemini到Google Sheets
自动化学术论文元数据及变量提取，从Gemini到Google Sheets
Set
Code
Wait
+14
39 节点OwenLee
文档提取
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
BrightData每周对比
使用Bright Data、GPT-4.1和Google Workspace的自动化网站变更监控
If
Set
Code
+15
35 节点Daniel Shashko
人工智能
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
