YouTube视频本地化更新 - Hoàng
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 28 个节点。主要使用 If, Set, Code, YouTube, HttpRequest 等节点。 基于Gemini AI和Google Sheets的多语言YouTube元数据翻译器
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (28)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "sM8cQjF7S5RDoQh6",
"meta": {
"instanceId": "ed6d846a2fce1f660ede2e7da800724cca01dc3d0685524a3c917881b7cfcfe9",
"templateCredsSetupCompleted": true
},
"name": "YouTube - 更新视频本地化 - Hoàng",
"tags": [],
"nodes": [
{
"id": "26bda9e3-2fe0-479a-a46b-a37940a56c9b",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1060,
-1440
],
"parameters": {},
"typeVersion": 3
},
{
"id": "f2e103fd-ac19-4c6b-bc25-d374dbd1b641",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-3900,
-1440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "8ad0e2cd-3be8-4f12-8e44-539c7ae76f97",
"name": "获取语言列表",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1320,
-1440
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "e04a3c36-0bd6-4cc6-bcf1-3d490007f33a",
"name": "解析数据为 JSON",
"type": "n8n-nodes-base.code",
"position": [
-580,
-1280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3c93cd87-e161-4f3b-912b-a8111cf3b2a8",
"name": "设置语言 - 新建",
"type": "n8n-nodes-base.set",
"position": [
-400,
-1280
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "e7ccb483-aeac-4a95-93a5-7d5c85e42722",
"name": "AI",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-920,
-1280
],
"parameters": {},
"typeVersion": 1.6
},
{
"id": "600be5f6-983e-44ea-9678-06852cc83497",
"name": "更新状态 - 成功",
"type": "n8n-nodes-base.googleSheets",
"position": [
400,
-1560
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "3d163ede-31fa-42a4-876d-7a74014e250e",
"name": "更新状态 - 错误",
"type": "n8n-nodes-base.googleSheets",
"position": [
400,
-1360
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "3a6563eb-2f69-447d-a544-da3ab293d148",
"name": "准备数值",
"type": "n8n-nodes-base.set",
"position": [
-3680,
-1440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "49c26bcc-640f-4448-aa91-da11e2117f96",
"name": "获取自动抓取状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
-3360,
-1260
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ca243a16-7adf-466d-b4d1-09817ff943c9",
"name": "检查自动抓取状态",
"type": "n8n-nodes-base.if",
"position": [
-3140,
-1260
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "9649a75e-dd9d-4965-87c8-265453bfa569",
"name": "合并所有语言",
"type": "n8n-nodes-base.code",
"position": [
-80,
-1460
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4ff77c6a-9a83-40db-9516-ed13a69f682d",
"name": "获取视频 URL",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1980,
-1440
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ebf0b684-3289-4a43-8b22-e92bb3e55372",
"name": "提取视频 ID",
"type": "n8n-nodes-base.code",
"position": [
-1800,
-1440
],
"parameters": {},
"typeVersion": 2
},
{
"id": "b0f90d46-aafc-4027-9bd7-bb1a598e6d65",
"name": "获取视频信息",
"type": "n8n-nodes-base.youTube",
"position": [
-1620,
-1440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4a841e42-8e87-41d4-958c-3dab1c1bea2a",
"name": "YouTube - 获取最新视频",
"type": "n8n-nodes-base.youTube",
"position": [
-2920,
-1260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c1857ba5-8b74-4552-8f66-e6082055f2bf",
"name": "检查最新视频 ID",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2700,
-1260
],
"parameters": {},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "23771d89-e6b1-41a7-9c0c-ae9b129bf04a",
"name": "如果视频 ID 尚不存在",
"type": "n8n-nodes-base.if",
"position": [
-2480,
-1260
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0c392fad-2209-4636-89e1-a4ba59662177",
"name": "插入视频信息",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2260,
-1260
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "97bdee40-86e3-4ac9-867a-4f40bc5f6e8e",
"name": "使用选定语言更新视频元数据",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
140,
-1460
],
"parameters": {},
"retryOnFail": false,
"typeVersion": 4.1
},
{
"id": "789d312b-b42c-4c41-a826-fe8749bc5825",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-920,
-1120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4b5f94a6-8824-42df-8ffb-254157821dab",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4060,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "8f7a28ef-fd97-419a-b510-e005f26e99af",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2040,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "00c32941-3273-4787-922f-36ac18ae9bc7",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "5d3fcf35-ebc0-4cea-bce7-43be6efb0e48",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "96387528-13b0-4e56-bd24-3bbddb387ff9",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3400,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "5925802b-0858-422e-a472-4524f95cd204",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6300,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "e8f2bc25-d167-48e5-871b-731848955755",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5180,
-1860
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "6607b57b-dd6a-4e66-ad62-74162228a676",
"connections": {
"AI": {
"main": [
[
{
"node": "Parse Data To JSON",
"type": "main",
"index": 0
}
]
]
},
"Get Video URL": {
"main": [
[
{
"node": "Extract Video ID",
"type": "main",
"index": 0
}
]
]
},
"Get Video Info": {
"main": [
[
{
"node": "Get Language List",
"type": "main",
"index": 0
}
]
]
},
"Prepare Values": {
"main": [
[
{
"node": "Get Auto Crawl Status",
"type": "main",
"index": 0
},
{
"node": "Get Video URL",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Merge All Languages",
"type": "main",
"index": 0
}
],
[
{
"node": "AI",
"type": "main",
"index": 0
}
]
]
},
"Extract Video ID": {
"main": [
[
{
"node": "Get Video Info",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Prepare Values",
"type": "main",
"index": 0
}
]
]
},
"Get Language List": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Insert Video Info": {
"main": [
[
{
"node": "Get Video URL",
"type": "main",
"index": 0
}
]
]
},
"Parse Data To JSON": {
"main": [
[
{
"node": "Set Languages - New",
"type": "main",
"index": 0
}
]
]
},
"Merge All Languages": {
"main": [
[
{
"node": "Update Video Metadata with Selected Languages",
"type": "main",
"index": 0
}
]
]
},
"Set Languages - New": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Check Latest Video ID": {
"main": [
[
{
"node": "If Video ID Not Exist Yet",
"type": "main",
"index": 0
}
]
]
},
"Get Auto Crawl Status": {
"main": [
[
{
"node": "Check Auto Crawl Status",
"type": "main",
"index": 0
}
]
]
},
"Check Auto Crawl Status": {
"main": [
[
{
"node": "Youtube - Get Lastest Video",
"type": "main",
"index": 0
}
],
[]
]
},
"If Video ID Not Exist Yet": {
"main": [
[
{
"node": "Insert Video Info",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini's Chat Model": {
"ai_languageModel": [
[
{
"node": "AI",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Youtube - Get Lastest Video": {
"main": [
[
{
"node": "Check Latest Video ID",
"type": "main",
"index": 0
}
]
]
},
"Update Video Metadata with Selected Languages": {
"main": [
[
{
"node": "Update Status - Success",
"type": "main",
"index": 0
}
],
[
{
"node": "Update Status - Error",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 Gemini AI 转录和摘要的 YouTube 频道监控并同步至 Google Sheets
使用 Gemini AI 转录和摘要的 YouTube 频道监控并同步至 Google Sheets
If
Set
Code
+10
33 节点Muhammad Asadullah
内容创作
博客发布器 – 完整的AI驱动内容研究、创作、优化与发布自动化
使用 Gemini、Ideogram AI 和 WordPress 自动化博客创建与发布
If
Set
Code
+9
35 节点Incrementors
内容创作
使用Groq、Gemini和Slack审批系统自动化RSS到Medium发布
通过Groq、Gemini和Slack审批系统实现RSS到Medium发布的自动化流程
If
Set
Code
+16
41 节点ObisDev
内容创作
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
If
Set
Code
+16
48 节点Daniel Lianes
内容创作
工作流信息
难度等级
高级
节点数量28
分类2
节点类型11
作者
Agent Circle
@agentcircleAgent Circle - A growing marketplace of AI agents, workflows, and toolkits — built to help teams automate smarter and scale faster
外部链接
在 n8n.io 查看 →
分享此工作流