反馈保存和报告生成
高级
这是一个CRM, AI Summarization领域的自动化工作流，包含 28 个节点。主要使用 Set, Code, EmailSend, GoogleSheets, ManualTrigger 等节点。 使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "INCHeFIxjP8eus8J",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "反馈保存和报告生成",
"tags": [],
"nodes": [
{
"id": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"name": "提取笔记/邮件",
"type": "n8n-nodes-base.code",
"position": [
16,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9cb26417-5674-44cb-ab6f-28c44b168094",
"name": "解析 AI 响应",
"type": "n8n-nodes-base.code",
"position": [
1264,
-224
],
"parameters": {},
"typeVersion": 2
},
{
"id": "60a74709-38da-48d6-9227-eeed1734c0f6",
"name": "保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1488,
-96
],
"parameters": {},
"typeVersion": 4
},
{
"id": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"name": "获取 Google Sheets 数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
448,
480
],
"parameters": {},
"typeVersion": 4
},
{
"id": "5bb2b739-60d9-4043-9771-979ad1c593da",
"name": "筛选近期数据",
"type": "n8n-nodes-base.code",
"position": [
1232,
416
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"name": "发送邮件摘要",
"type": "n8n-nodes-base.emailSend",
"position": [
1472,
416
],
"webhookId": "2fd9cd32-4351-49a0-ba18-310a17f086b5",
"parameters": {},
"typeVersion": 2
},
{
"id": "073e3c65-5662-4c40-8f7c-abb1b5d54030",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-432,
112
],
"parameters": {},
"typeVersion": 1
},
{
"id": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-208,
112
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "dd009347-1c1e-4d77-880f-98a1268feab6",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
432,
-368
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "3914f8f7-955b-4464-9548-89f6b79f67bb",
"name": "Azure OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
464,
-208
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
240,
112
],
"parameters": {},
"typeVersion": 3
},
{
"id": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
896,
-368
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"name": "AI Agent1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
752,
416
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "5529bf2c-a211-43bb-8a1a-1c2027fb7daf",
"name": "Azure OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
832,
592
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d1043f1a-2691-4f2f-a5e9-108431e7a7f8",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d232025f-784f-4ef6-8a4d-d0b62a7bd651",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-256
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "222b661a-1825-42f0-9548-b4c7a35928b5",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bfc6fdc7-1535-4849-8995-8cbabb4b4db5",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3d1bbe23-6654-4708-9088-3e931e8da497",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
-752
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33538927-39dd-4cbe-8e7b-a8cf69bdad23",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2bd5d02c-5fbc-4b0b-8526-3222daeef829",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
832,
-704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "db617a0c-d9d3-4e46-b305-c471b35884e1",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1216,
-608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1c2fd82b-2067-43c8-8a6b-2eaaa00e20aa",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1584,
-432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e87af0fc-8734-47d6-8630-d20cee16d6bc",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e8d0fdf6-e192-4d2d-ba57-e38f413fde9d",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
752,
144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4ac6d3a4-4c29-4fea-adb8-28bff7c90f9d",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
752
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3ecd8bc0-6e57-40c1-bee9-ecce4253097b",
"name": "便签 12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1184,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "007b3968-5938-4abf-b369-16e119de46c9",
"name": "便签 13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1664,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1552e070-ec28-47ce-b4e6-41c3fd0dd004",
"connections": {
"AI Agent": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"AI Agent1": {
"main": [
[
{
"node": "Filter Recent Data",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Parse AI Response",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Fetch Google Sheet Data",
"type": "main",
"index": 0
}
],
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Parse AI Response": {
"main": [
[
{
"node": "Save to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Send Email Digest": {
"main": [
[]
]
},
"Filter Recent Data": {
"main": [
[
{
"node": "Send Email Digest",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Extract Notes/Emails",
"type": "main",
"index": 0
}
]
]
},
"Extract Notes/Emails": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Save to Google Sheets": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Fetch Google Sheet Data": {
"main": [
[
{
"node": "AI Agent1",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "AI Agent1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户关系管理, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
使用GPT-4o-mini和Gmail分析YouTube频道并发送性能报告
Code
Email Send
Http Request
+6
20 节点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
开发运维
提案生成_草稿保存自动化
使用Azure GPT-4o生成商业提案并从Sheets保存为Gmail草稿
If
Code
Gmail
+6
16 节点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
潜在客户开发
工作流信息
难度等级
高级
节点数量28
分类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 查看 →
分享此工作流