使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
高级
这是一个Market Research, AI Summarization领域的自动化工作流，包含 20 个节点。主要使用 Code, EmailSend, HttpRequest, GoogleSheets, ManualTrigger 等节点。 使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (20)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177"
},
"nodes": [
{
"id": "12b5b00a-6001-45bf-859e-5c2b257dcab0",
"name": "Sending report via email",
"type": "n8n-nodes-base.emailSend",
"position": [
2112,
128
],
"webhookId": "75c1ce39-8ca3-4dc8-9342-186dabbdc32c",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "968f662d-cee2-471a-bdac-82b61d2f4a78",
"name": "Creating Email",
"type": "n8n-nodes-base.code",
"position": [
1824,
128
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c7059c42-2d43-4557-80ca-acaf8c53fd28",
"name": "Creating Analysis",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1376,
128
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4d02cf88-8091-46a9-9de4-d08990f0fcef",
"name": "Formatting Data",
"type": "n8n-nodes-base.code",
"position": [
1152,
128
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9ba90e49-e76b-4a5c-8b33-2fabe4a3e554",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2016,
368
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "60b2a151-9d69-4a16-b31c-e85a6df529da",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1776,
-304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "772c89ac-7ca4-4fe2-8ab2-16648d974816",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1328,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "23565517-1526-4c9c-8a88-00183d0b7616",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1392,
-304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f26bd60a-cc9b-4297-9636-d56ebb1ed3c2",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1072,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3e8c9dc0-9740-408b-9313-45d251a9cd9b",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
848,
336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "35b1c8c3-d5e2-4915-8d7b-4837d80db850",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
624,
-336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "39281538-83a8-4686-bee1-380ace24dba0",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
384,
336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7c69eb73-fb88-412c-baa8-8ec143fd36e9",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-288
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "dff02713-98de-40c4-bf82-8e6c3e5293c5",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-160
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1535cbe4-0963-43ab-a5c4-28103ce562f3",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
448,
128
],
"parameters": {},
"typeVersion": 3
},
{
"id": "fb553ab6-9166-4d87-95a8-98d9faf6560a",
"name": "Comments segergation",
"type": "n8n-nodes-base.code",
"position": [
944,
128
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a89c606e-c276-4787-877a-f5a51bfa7697",
"name": "Azure OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
1376,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "31ef09fc-9291-4eac-a01f-94566b30a606",
"name": "Content extraction",
"type": "n8n-nodes-base.httpRequest",
"position": [
704,
128
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "bab393a2-1232-4c0e-9f15-3074b3ab9d19",
"name": "Get row(s) in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
224,
128
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "14a1b5d5-146f-4b5e-9d2b-e01ee486de04",
"name": "When clicking ‘Execute workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
128
],
"parameters": {},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Creating Email": {
"main": [
[
{
"node": "Sending report via email",
"type": "main",
"index": 0
}
]
]
},
"Formatting Data": {
"main": [
[
{
"node": "Creating Analysis",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Content extraction",
"type": "main",
"index": 0
}
]
]
},
"Creating Analysis": {
"main": [
[
{
"node": "Creating Email",
"type": "main",
"index": 0
}
]
]
},
"Content extraction": {
"main": [
[
{
"node": "Comments segergation",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Comments segergation": {
"main": [
[
{
"node": "Formatting Data",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Creating Analysis",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Sending report via email": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 市场调研, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
客户关系管理
将服装图片上传到Cloudinary并使用Azure OpenAI (GPT-4o) 记录到工作表
使用GPT-4o、Cloudinary和Google Sheets处理和编目服装图片
Set
Code
Merge
+9
26 节点Rahul Joshi
内容创作
智能线索标记与路由
基于HighLevel和Azure GPT-4o-mini的AI驱动线索分类与路由
If
Code
Email Send
+5
17 节点Rahul Joshi
潜在客户开发
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
自动化依赖更新跟踪
使用 GPT-4o、Slack、Jira 和 Google Sheets 进行依赖更新风险分析
If
Set
Code
+8
23 节点Rahul Joshi
开发运维
技能矩阵提取器
使用Google Drive和GPT-4o将技能矩阵提取至Google表格
Code
Google Drive
Google Sheets
+5
17 节点Rahul Joshi
杂项
工作流信息
难度等级
高级
节点数量20
分类2
节点类型9
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 查看 →
分享此工作流