提案生成_草稿保存自动化
高级
这是一个CRM, Multimodal AI领域的自动化工作流，包含 16 个节点。主要使用 If, Code, Gmail, GoogleSheets, ManualTrigger 等节点。 使用Azure GPT-4o生成商业提案并从Sheets保存为Gmail草稿
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "uM6YAMBuMgbu0VKt",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "提案生成_草稿保存自动化",
"tags": [],
"nodes": [
{
"id": "b6261462-f2cf-4989-81f1-9303e2b805e7",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-208,
-624
],
"parameters": {},
"typeVersion": 1
},
{
"id": "101bb3e2-36a1-4df7-ab49-b116abb69f86",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
16,
-624
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "2b13049a-e27d-48d8-bb99-48beba7c7476",
"name": "检查提案状态",
"type": "n8n-nodes-base.if",
"position": [
240,
-624
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "886f8fb6-c9d0-4575-865e-ba067c8f59df",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
688,
-624
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "b1edd21d-e96e-4729-8726-543a6f6b58b7",
"name": "Azure OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
784,
-400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "372e14c9-f545-4643-b3a6-54a0439a43e5",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
464,
-624
],
"parameters": {},
"typeVersion": 3
},
{
"id": "8e55578c-f6f9-40b9-8d41-b69601d9d671",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
1072,
-624
],
"parameters": {},
"typeVersion": 2
},
{
"id": "855b8a09-9ca0-4966-8c0d-ec2078a0a75c",
"name": "创建草稿",
"type": "n8n-nodes-base.gmail",
"position": [
1312,
-624
],
"webhookId": "182ed1a5-d698-47fb-8678-3e70a062c0b0",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "1fd057dd-1793-4905-9329-ed1f8131d4ff",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-272,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2fe2308c-9a60-4b34-a465-83ba05b69be7",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
-448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "082d3907-cfe6-4c1f-bacd-a83374e79246",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
176,
-944
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "84d7e086-966c-431b-9b99-847990ffc1d2",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5b863a97-92d7-40b0-ac95-e5e8cd2cbea4",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
688,
-1104
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "305705dd-01a9-4229-a3af-00c32182b95c",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
-256
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "69898e6c-54ad-4a9d-a63d-5d17376e511f",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1008,
-464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2409ec85-6238-468b-8e4b-3052cd1e7015",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1232,
-944
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "39af8b7b-2a69-4881-b93c-9edf6bbdf49f",
"connections": {
"Code": {
"main": [
[
{
"node": "Create a draft",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "checks propsal status",
"type": "main",
"index": 0
}
]
]
},
"checks propsal status": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"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）可能需要您自行付费。
相关工作流推荐
从 Stripe 支付自动交付模板给客户
使用Stripe、GPT-4o和Gmail的自动化模板交付系统
If
Code
Gmail
+12
44 节点Rahul Joshi
客户关系管理
销售代表绩效追踪器
基于HighLevel CRM、GPT-4o、Notion和Slack的自动化销售排行榜
If
Code
Slack
+7
21 节点Rahul Joshi
客户关系管理
服务后评价收集器
客户评价收集与情感分析：HighLevel、GPT-4o、Gmail和Slack
If
Wait
Gmail
+7
20 节点Rahul Joshi
客户关系管理
从Google Drive生成n8n模板描述
使用Azure GPT-4从Google Drive生成模板描述
Code
Gmail
Google Drive
+9
27 节点Rahul Joshi
内容创作
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
客户关系管理
使用 Azure OpenAI 和 Google Workspace 自动化 DEI 资格筛选
使用Azure GPT-4o、Google云端硬盘和表格自动进行DEI资格筛选
If
Code
Gmail
+9
19 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量16
分类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 查看 →
分享此工作流