使用Gmail、OpenAI和Google表格自动化敏捷细化准备
高级
这是一个Product, AI领域的自动化工作流，包含 51 个节点。主要使用 If, Set, Gmail, Merge, Filter 等节点，结合人工智能技术实现智能自动化。 使用Gmail、OpenAI和Google表格自动化敏捷细化准备
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (51)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "916ac1062ab9498cb176046f06d28d55b1a694b26c6d9e9270c694bdbe01997d",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "188d1e63-306b-4ee9-a39c-04a50ad0045c",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
340,
505
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f741929-ecc7-4cbc-994c-e6b7b9c40e46",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"disabled": true,
"position": [
340,
305
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "321a045f-0e5f-4992-aa75-4b639a5a7f9b",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
680,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a522ba37-96a2-42da-b7e8-b4e1af223537",
"name": "加载 Scrum Master 的日历",
"type": "n8n-nodes-base.googleCalendar",
"position": [
820,
400
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.3,
"waitBetweenTries": 5000
},
{
"id": "8207984e-800c-4ed2-ab1b-7c2bf4f01cbc",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "513f18e3-0dde-4a10-95f0-1f43f90e1c63",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-620,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6980a1b-812a-47a9-adb4-be31349e0334",
"name": "检查优化项目 A",
"type": "n8n-nodes-base.filter",
"position": [
960,
400
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "dbf9f9b7-ec74-48da-8004-99c1184049a2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1140,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "070ef37d-0d33-4ce9-9ca3-0bdd2a210e30",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2020,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "cb8006d1-64fc-4727-ab67-5b4622a1dad7",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
5860,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a280ba9a-8df7-4c56-abe1-9c97c6ab9e76",
"name": "读取 DoR 标准",
"type": "n8n-nodes-base.googleSheets",
"position": [
2340,
580
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "d2c2c85a-0559-4639-a02d-dbb58dda34b6",
"name": "循环遍历项目进行 DoR 检查",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2140,
480
],
"parameters": {},
"typeVersion": 3
},
{
"id": "5383fd92-16d5-455a-be67-9f4b759d07fe",
"name": "比较用户故事与 DoR 标准",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2560,
440
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.9,
"waitBetweenTries": 5000
},
{
"id": "964f81bc-cdf6-40b2-8e7b-0c1a7c801481",
"name": "起草优化邮件",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
6220,
440
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.8,
"waitBetweenTries": 5000
},
{
"id": "55acf57c-9560-46ba-ada4-8c0a4f51c6c6",
"name": "业务验证",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
4120,
360
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.9,
"waitBetweenTries": 5000
},
{
"id": "ff51012c-1591-4a00-b8d1-94d2f14c4512",
"name": "如果没有事件则不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
1160,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c12ab6c0-571d-4111-aeaa-49ba7558bc38",
"name": "在待办事项中更新业务验证",
"type": "n8n-nodes-base.googleSheets",
"position": [
4500,
560
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "ace506a2-5fa5-4b02-b261-368febf85298",
"name": "获取待办事项链接以供进一步参考",
"type": "n8n-nodes-base.googleDrive",
"position": [
1440,
400
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 3,
"waitBetweenTries": 5000
},
{
"id": "dd821197-174f-4de5-8c32-44eb0d994bee",
"name": "在待办事项中更新技术验证",
"type": "n8n-nodes-base.googleSheets",
"position": [
5640,
580
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "8a730d15-166a-475a-ad41-1746f94b3252",
"name": "在待办事项中更新 Scrum 反馈",
"type": "n8n-nodes-base.googleSheets",
"position": [
3540,
600
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "b333f793-93b3-445c-ac2a-d9d450157e0c",
"name": "OpenAI 业务分析师",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
4120,
600
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "3b6215f6-ee09-482d-a830-4a6f007e491e",
"name": "OpenAI 技术分析师",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
5280,
580
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9da57209-6d17-414d-9e5e-28ce11aa033f",
"name": "从待办事项中选择准备优化的故事",
"type": "n8n-nodes-base.googleSheets",
"position": [
1660,
300
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "785ca288-ea0c-4e7c-8126-01f65178c0c8",
"name": "从待办事项中选择高优先级待办故事",
"type": "n8n-nodes-base.googleSheets",
"position": [
1660,
520
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 4.5,
"waitBetweenTries": 5000
},
{
"id": "a0ccb135-25a4-4064-b385-c38504dad671",
"name": "OpenAI Scrum Master 邮件发送器",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
6220,
660
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "ea7c3f2b-0a6c-4f71-b75a-32af19e4bb84",
"name": "OpenAI Scrum Master 故事反馈",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3200,
640
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "54415f41-f33d-4a20-a774-1008985d6f84",
"name": "OpenAI Scrum Master DoR 检查",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2560,
620
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e2212d56-7eb8-4182-9807-8cc307764bcb",
"name": "开发团队验证",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
5280,
380
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.9,
"waitBetweenTries": 5000
},
{
"id": "2f9867e3-2951-4446-8733-3fdce506e5b4",
"name": "合并可能优化的故事",
"type": "n8n-nodes-base.merge",
"position": [
1880,
405
],
"parameters": {},
"typeVersion": 3.1,
"alwaysOutputData": false
},
{
"id": "576123fb-dab4-44eb-b9c7-1821c9fd60db",
"name": "向故事添加 Scrum 反馈",
"type": "n8n-nodes-base.merge",
"position": [
2840,
260
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "cf901d64-c170-4028-8126-728bd10cf53f",
"name": "向故事添加业务反馈",
"type": "n8n-nodes-base.merge",
"position": [
4420,
240
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "3aeb5768-3cde-4dde-afbb-40cafd323c1c",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
3740,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5f52b8c0-39da-428d-a6b7-23951c4a8ccc",
"name": "循环遍历项目业务反馈",
"type": "n8n-nodes-base.splitInBatches",
"position": [
3820,
340
],
"parameters": {},
"typeVersion": 3
},
{
"id": "04794eea-55fa-4e65-b896-893495fd6aee",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
4820,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1e6ee03-02c4-463b-9103-ad5c7a12a5f4",
"name": "向故事添加技术反馈",
"type": "n8n-nodes-base.merge",
"position": [
5540,
180
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "cfa35094-197e-49c6-91bf-f2e5cc7a7eea",
"name": "将 DoR 检查汇总到用户故事级别",
"type": "n8n-nodes-base.aggregate",
"position": [
2860,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "077821fa-de34-4fab-86d5-572c3ecf505c",
"name": "向用户故事添加 DoR 反馈",
"type": "n8n-nodes-base.merge",
"position": [
3040,
540
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "67c79fda-7b07-4132-8186-1dab33168235",
"name": "提供 Scrum Master 对故事的反馈",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
3220,
440
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 1.9,
"waitBetweenTries": 5000
},
{
"id": "0356faaf-4b2b-4f5e-a233-0368af0a1ad1",
"name": "循环遍历项目技术反馈",
"type": "n8n-nodes-base.splitInBatches",
"position": [
4940,
400
],
"parameters": {},
"typeVersion": 3
},
{
"id": "69b422e6-9554-48e1-967b-b0c43d5059e7",
"name": "将故事合并到一个列表中",
"type": "n8n-nodes-base.aggregate",
"position": [
6000,
440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6797258c-5bd3-459e-8ad2-5cae5f925a3a",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
-100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "12706b00-05b1-452a-970d-77b251731b7a",
"name": "错误触发器",
"type": "n8n-nodes-base.errorTrigger",
"position": [
640,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e5c7fce5-a868-4ef4-abda-952af2b32191",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
6540,
140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "687d92d0-ab1e-4562-990d-554f93924f7f",
"name": "向 Scrum Master 请求批准",
"type": "n8n-nodes-base.gmail",
"position": [
6620,
440
],
"webhookId": "094525b3-6943-4384-8177-77b745894cd5",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4e04e194-00b4-47b7-87d6-8f11d60b268e",
"name": "向与会者发送邮件",
"type": "n8n-nodes-base.gmail",
"position": [
7000,
380
],
"webhookId": "48e5bb87-20e3-4a7a-950a-cc253b36ba07",
"parameters": {},
"retryOnFail": true,
"typeVersion": 2.1,
"waitBetweenTries": 5000
},
{
"id": "a7eec739-76c3-4bbd-8603-517ad5ca3014",
"name": "在 Scrum Master 邮箱中创建草稿",
"type": "n8n-nodes-base.gmail",
"position": [
7000,
540
],
"webhookId": "00f7b5c0-8645-4995-bf62-9ae0cdb5458d",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "f60a810d-1984-434e-9e87-37f74041920d",
"name": "提醒草稿已准备好手动调整",
"type": "n8n-nodes-base.gmail",
"position": [
7220,
540
],
"webhookId": "43d07e42-3339-4e34-9421-308df087f59c",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "380a0918-67a9-4fa8-b27f-fdb0f07494fe",
"name": "如果邮件内容已批准",
"type": "n8n-nodes-base.if",
"position": [
6800,
440
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "d184a895-96c9-4af8-ba74-67a60c04c123",
"name": "从此开始：设置环境变量",
"type": "n8n-nodes-base.set",
"position": [
520,
400
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d54917ca-4554-4b5a-ac37-be1eca003b41",
"name": "获取 DoR 链接以供进一步参考",
"type": "n8n-nodes-base.googleDrive",
"position": [
1300,
400
],
"parameters": {},
"retryOnFail": true,
"typeVersion": 3,
"waitBetweenTries": 5000
},
{
"id": "98b08147-3ef7-4e95-937d-d30f4938afe2",
"name": "发送错误邮件",
"type": "n8n-nodes-base.gmail",
"maxTries": 5,
"position": [
880,
-60
],
"webhookId": "3b95ad1e-14e5-47b3-977d-f088b00949c6",
"parameters": {},
"retryOnFail": true,
"typeVersion": 2.1,
"waitBetweenTries": 5000
}
],
"pinData": {},
"connections": {
"Error Trigger": {
"main": [
[
{
"node": "Send Error Email",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Start Here: Set Environment Variables",
"type": "main",
"index": 0
}
]
]
},
"Read DoR criteria": {
"main": [
[
{
"node": "Compare User Story to DoR Criterium",
"type": "main",
"index": 0
}
]
]
},
"Business Validation": {
"main": [
[
{
"node": "Update Business Validation in Backlog",
"type": "main",
"index": 0
}
]
]
},
"If no event do nothing": {
"main": [
[
{
"node": "Take DoR link for further referral",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Business Analyst": {
"ai_languageModel": [
[
{
"node": "Business Validation",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"No Operation, do nothing": {
"main": [
[
{
"node": "Load Calendar of Scrum Master",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Technical Analyst": {
"ai_languageModel": [
[
{
"node": "Development Team Validation",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Draft Email for Refinement": {
"main": [
[
{
"node": "Ask Approval to Scrum Master",
"type": "main",
"index": 0
}
]
]
},
"Add Scrum Feedback to Story": {
"main": [
[
{
"node": "Add Business feedback to Story",
"type": "main",
"index": 0
},
{
"node": "Loop Over Items Business Feedback",
"type": "main",
"index": 0
}
]
]
},
"Development Team Validation": {
"main": [
[
{
"node": "Update Technical Validation in Backlog",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Scrum Master Emailer": {
"ai_languageModel": [
[
{
"node": "Draft Email for Refinement",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Ask Approval to Scrum Master": {
"main": [
[
{
"node": "If Email content is Approved",
"type": "main",
"index": 0
}
]
]
},
"If Email content is Approved": {
"main": [
[
{
"node": "Send Email to Attendees",
"type": "main",
"index": 0
}
],
[
{
"node": "Create Draft in Scrum Master Email",
"type": "main",
"index": 0
}
]
]
},
"Combine stories into one list": {
"main": [
[
{
"node": "Draft Email for Refinement",
"type": "main",
"index": 0
}
]
]
},
"Load Calendar of Scrum Master": {
"main": [
[
{
"node": "Check for Refinement Project A",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items for DoR check": {
"main": [
[
{
"node": "Add Scrum Feedback to Story",
"type": "main",
"index": 1
}
],
[
{
"node": "Read DoR criteria",
"type": "main",
"index": 0
},
{
"node": "Add DoR feedback to User Story",
"type": "main",
"index": 1
}
]
]
},
"OpenAI Scrum Master DoR Check": {
"ai_languageModel": [
[
{
"node": "Compare User Story to DoR Criterium",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Add Business feedback to Story": {
"main": [
[
{
"node": "Loop Over Items Technical Feedback",
"type": "main",
"index": 0
},
{
"node": "Add Technical feedback to the story",
"type": "main",
"index": 0
}
]
]
},
"Add DoR feedback to User Story": {
"main": [
[
{
"node": "Provide Scrum Master Feedback on the story",
"type": "main",
"index": 0
}
]
]
},
"Check for Refinement Project A": {
"main": [
[
{
"node": "If no event do nothing",
"type": "main",
"index": 0
}
]
]
},
"Update Scrum feedback in Backlog": {
"main": [
[
{
"node": "Loop Over Items for DoR check",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items Business Feedback": {
"main": [
[
{
"node": "Add Business feedback to Story",
"type": "main",
"index": 1
}
],
[
{
"node": "Business Validation",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Start Here: Set Environment Variables",
"type": "main",
"index": 0
}
]
]
},
"Create Draft in Scrum Master Email": {
"main": [
[
{
"node": "Make aware the draft is ready to be adjusted manually",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items Technical Feedback": {
"main": [
[
{
"node": "Add Technical feedback to the story",
"type": "main",
"index": 1
}
],
[
{
"node": "Development Team Validation",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Scrum Master Story Feedback": {
"ai_languageModel": [
[
{
"node": "Provide Scrum Master Feedback on the story",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Take DoR link for further referral": {
"main": [
[
{
"node": "Take backlog link for further referral",
"type": "main",
"index": 0
}
]
]
},
"Add Technical feedback to the story": {
"main": [
[
{
"node": "Combine stories into one list",
"type": "main",
"index": 0
}
]
]
},
"Compare User Story to DoR Criterium": {
"main": [
[
{
"node": "Aggregate DoR check to User Story Level",
"type": "main",
"index": 0
}
]
]
},
"Join Potential Stories for Refinement": {
"main": [
[
{
"node": "Loop Over Items for DoR check",
"type": "main",
"index": 0
},
{
"node": "Add Scrum Feedback to Story",
"type": "main",
"index": 0
}
]
]
},
"Start Here: Set Environment Variables": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Update Business Validation in Backlog": {
"main": [
[
{
"node": "Loop Over Items Business Feedback",
"type": "main",
"index": 0
}
]
]
},
"Take backlog link for further referral": {
"main": [
[
{
"node": "Select Stories Ready for Refinement from Backlog",
"type": "main",
"index": 0
},
{
"node": "Select Stories High Prio To Do from Backlog",
"type": "main",
"index": 0
}
]
]
},
"Update Technical Validation in Backlog": {
"main": [
[
{
"node": "Loop Over Items Technical Feedback",
"type": "main",
"index": 0
}
]
]
},
"Aggregate DoR check to User Story Level": {
"main": [
[
{
"node": "Add DoR feedback to User Story",
"type": "main",
"index": 0
}
]
]
},
"Provide Scrum Master Feedback on the story": {
"main": [
[
{
"node": "Update Scrum feedback in Backlog",
"type": "main",
"index": 0
}
]
]
},
"Select Stories High Prio To Do from Backlog": {
"main": [
[
{
"node": "Join Potential Stories for Refinement",
"type": "main",
"index": 1
}
]
]
},
"Select Stories Ready for Refinement from Backlog": {
"main": [
[
{
"node": "Join Potential Stories for Refinement",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 产品, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
敏捷团队冲刺规划自动化
使用OpenAI、Google日历和Gmail为敏捷团队自动化冲刺规划
If
Set
Code
+17
52 节点Willemijn
产品
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
AIAutomationPro终极RAG聊天机器人v1 n8n市场模板
多语言Telegram RAG聊天机器人，集成监督AI和自动化Google Drive流程
If
Set
Wait
+29
128 节点Daniel Ng
客服机器人
基于AI的潜在客户信息增强（Bright Data MCP和Google Sheets）
基于AI的潜在客户信息增强：使用Bright Data MCP和Google Sheets
If
Set
Wait
+19
51 节点Cyril Nicko Gaspar
销售
工作流信息
难度等级
高级
节点数量51
分类2
节点类型17
作者
Willemijn
@willemijnSharing automation templates and ideas based on agile ways of working. Exploring how AI and no-code tools like n8n can improve how teams work and collaborate.
外部链接
在 n8n.io 查看 →
分享此工作流