使用 Gemini AI 转录和摘要的 YouTube 频道监控并同步至 Google Sheets
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 33 个节点。主要使用 If, Set, Code, Wait, HttpRequest 等节点。 使用 Gemini AI 转录和摘要的 YouTube 频道监控并同步至 Google Sheets
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (33)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "b6be3264d10563f53f60f119665bef14019561878be2f73c07ebd4200e9255cf",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "23ed0a44-17f3-4ddd-98d7-667c813b8c26",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-2800,
400
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1f54c4f3-f673-40be-b40a-a1ebe1d95c8f",
"name": "Google Gemini 聊天模型13",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-2960,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "acc97cba-b203-42ef-9c88-b9f3c84e034e",
"name": "YouTube 视频摘要器",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-3024,
128
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.5
},
{
"id": "bbfdd52b-e9ae-41e9-830e-ac080c661fc5",
"name": "如果4",
"type": "n8n-nodes-base.if",
"position": [
-4928,
64
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "80402260-bb85-42b9-84b1-05f4dcd27e88",
"name": "遍历视频",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4624,
48
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5875d204-c4d9-4bf5-95a3-922f91c72293",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
-3216,
128
],
"parameters": {},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "91a45e4e-1bc5-4bfc-ba87-83f55cf233fa",
"name": "YouTube 转录器 Gemini",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
-3712,
144
],
"parameters": {},
"typeVersion": 4.2,
"alwaysOutputData": true
},
{
"id": "50bf5f8c-0451-47dc-bb87-1f58e091fe5d",
"name": "获取表中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-6000,
-384
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "ef915172-5a3b-412f-a499-99a73262783c",
"name": "检查是否为 YouTube 链接",
"type": "n8n-nodes-base.if",
"position": [
-5632,
-384
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "980c2c80-b9fd-454a-b8b5-737a45d93f01",
"name": "拆分为独立链接",
"type": "n8n-nodes-base.code",
"position": [
-5824,
-384
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5ddd6b95-2478-4fe2-87a0-c84ec9eff978",
"name": "遍历频道",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-5360,
-400
],
"parameters": {},
"typeVersion": 3
},
{
"id": "a6a4e066-3e32-4fdd-9e5e-5ff26324ecd0",
"name": "设置频道",
"type": "n8n-nodes-base.set",
"position": [
-5152,
-384
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "3e39e5bf-5308-41e9-8d14-0bd0188f1ff4",
"name": "获取频道详情",
"type": "n8n-nodes-base.httpRequest",
"position": [
-4848,
-384
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "83b56b40-54d7-45e4-ac7f-aa305d2e1ae4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4960,
-464
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "c3b35667-6075-49ad-8ae6-5fe0fea9a393",
"name": "RSS 读取（YouTube 频道视频）",
"type": "n8n-nodes-base.rssFeedRead",
"position": [
-4544,
-384
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "8d3877bf-74d4-4181-9432-76816a356094",
"name": "最近 X 天内发布的视频（在第 6 行修改）",
"type": "n8n-nodes-base.code",
"position": [
-4352,
-384
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "12741747-d3cf-4d31-b8fd-eb34258ca2d9",
"name": "视频详情",
"type": "n8n-nodes-base.set",
"position": [
-4128,
-384
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "771f493f-204e-493a-bca0-08ea4b961b13",
"name": "如果标题存在？",
"type": "n8n-nodes-base.if",
"position": [
-3904,
-384
],
"parameters": {},
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "f7eab8e8-1728-478c-bf80-79c74d628e82",
"name": "所有视频",
"type": "n8n-nodes-base.set",
"position": [
-3616,
-400
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "6c1a61e0-65f7-4d2f-b58c-c9ab72bfdc35",
"name": "视频数据与条件",
"type": "n8n-nodes-base.set",
"position": [
-4432,
160
],
"parameters": {},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "f96c44e3-c59d-406c-8988-d75574d3aeb7",
"name": "获取 sheet1 中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-4224,
160
],
"parameters": {},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "928e2dd5-c6a6-4bd2-875c-7a70e647de79",
"name": "如果表中不存在？",
"type": "n8n-nodes-base.if",
"position": [
-4032,
160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "cce80df2-48e0-46f5-aada-cf4220876e0e",
"name": "如果转录文本存在",
"type": "n8n-nodes-base.if",
"position": [
-3440,
144
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f035199a-b515-4ae6-b536-177cf6e84736",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2672,
128
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "96e91e5b-52ff-49f3-9b89-fdd6f92de5f1",
"name": "结束",
"type": "n8n-nodes-base.set",
"position": [
-4160,
32
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c2dc9bcc-7e97-4c9a-b775-a72dffc60941",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4688,
-80
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "b3a5afe3-5fe5-47cc-94f3-b14feea2d956",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3120,
-80
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "45e914ff-808e-4596-bf69-6c6799324702",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3888,
16
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "68dfb732-4799-46e7-8274-5749cd8dc807",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-6208,
-384
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "1a29295c-be37-4b1f-b281-c9e00c6de8c5",
"name": "等待 2 秒",
"type": "n8n-nodes-base.wait",
"position": [
-3408,
-256
],
"webhookId": "e7a42ad4-7cb0-4942-9709-d9dae054d8c6",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "27f95674-e042-4fd1-9d54-c34c70cd8fba",
"name": "失败时等待 85 秒",
"type": "n8n-nodes-base.wait",
"position": [
-3232,
256
],
"webhookId": "8580d46f-0ff8-4687-a5f2-e71960000462",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "ddb1108d-c984-47be-bc43-0dedb3ced055",
"name": "为下一个视频等待 70 秒",
"type": "n8n-nodes-base.wait",
"position": [
-2240,
352
],
"webhookId": "999d44b4-113e-4dcf-bbf0-a0c3dcce7369",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "987ba628-ce7b-4ed0-967e-e00be26359ac",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6288,
-208
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If4": {
"main": [
[
{
"node": "Loop Over Videos",
"type": "main",
"index": 0
}
]
]
},
"If title?": {
"main": [
[
{
"node": "all videos",
"type": "main",
"index": 0
}
]
]
},
"Wait 2 sec": {
"main": [
[
{
"node": "Loop Over channels",
"type": "main",
"index": 0
}
]
]
},
"all videos": {
"main": [
[
{
"node": "Wait 2 sec",
"type": "main",
"index": 0
}
]
]
},
"set channel": {
"main": [
[
{
"node": "Get Channel details",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "youtube video summariser",
"type": "main",
"index": 0
}
]
]
},
"video details": {
"main": [
[
{
"node": "If title?",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Videos": {
"main": [
[
{
"node": "End",
"type": "main",
"index": 0
}
],
[
{
"node": "Video Data and criteria",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Loop Over channels": {
"main": [
[
{
"node": "If4",
"type": "main",
"index": 0
}
],
[
{
"node": "set channel",
"type": "main",
"index": 0
}
]
]
},
"Get Channel details": {
"main": [
[
{
"node": "RSS Read (youtube channel videos)",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Split into individual links",
"type": "main",
"index": 0
}
]
]
},
"Wait 85 sec on fail": {
"main": [
[
{
"node": "Video Data and criteria",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet1": {
"main": [
[
{
"node": "if not exist in sheet?",
"type": "main",
"index": 0
}
]
]
},
"If transcript exists": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait 85 sec on fail",
"type": "main",
"index": 0
}
]
]
},
"check if youtube link": {
"main": [
[
{
"node": "Loop Over channels",
"type": "main",
"index": 0
}
]
]
},
"if not exist in sheet?": {
"main": [
[
{
"node": "Youtube Transcriber Gemini",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait 70 sec for next video",
"type": "main",
"index": 0
}
]
]
},
"Video Data and criteria": {
"main": [
[
{
"node": "Get row(s) in sheet1",
"type": "main",
"index": 0
}
]
]
},
"youtube video summariser": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "youtube video summariser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Google Gemini Chat Model13": {
"ai_languageModel": [
[
{
"node": "youtube video summariser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Wait 70 sec for next video": {
"main": [
[
{
"node": "Loop Over Videos",
"type": "main",
"index": 0
}
]
]
},
"Youtube Transcriber Gemini": {
"main": [
[
{
"node": "If transcript exists",
"type": "main",
"index": 0
}
]
]
},
"Split into individual links": {
"main": [
[
{
"node": "check if youtube link",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Wait 70 sec for next video",
"type": "main",
"index": 0
}
]
]
},
"RSS Read (youtube channel videos)": {
"main": [
[
{
"node": "Videos Posted in Last X days (change on line 6)",
"type": "main",
"index": 0
}
]
]
},
"Videos Posted in Last X days (change on line 6)": {
"main": [
[
{
"node": "video details",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
基于Gemini AI、Supabase和Nano-Banana的端到端博客创建自动化
使用Gemini AI、Supabase和Nano-Banana实现端到端博客创建自动化
If
Set
Code
+16
51 节点Muhammad Asadullah
内容创作
使用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 电影短片生成器
使用 Gemini、GPT 和 ElevenLabs 将名言转换为社交媒体热门视频
If
Jwt
Set
+17
48 节点LukaszB
内容创作
内容生成器 v3
AI驱动博客自动化：使用GPT-4生成并发布SEO文章至WordPress和Twitter
If
Set
Code
+25
144 节点Jay Emp0
内容创作
工作流信息
难度等级
高级
节点数量33
分类2
节点类型13
作者
Muhammad Asadullah
@asadtechI am a Data Scientist, and Generative AI Developer with expertise in building AI applications, chatbots, and automation systems. Skilled in Python, R, and no-code/low-code platforms like n8n and Make, I combine strong technical knowledge in machine learning and NLP with hands-on experience in power systems, transformers, and solar design.
外部链接
在 n8n.io 查看 →
分享此工作流