使用GPT-4.1-mini聊天助手将项目任务添加到Google表格
高级
这是一个Project Management、AI Chatbot领域的自动化工作流，包含 17 个节点。主要使用 If、GoogleSheets、Chat、Agent、ChatTrigger 等节点。 使用GPT-4.1-mini聊天助手将项目任务添加到Google表格
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (17 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "b96307a6-bb22-4556-96a9-89ca63119d1e",
"name": "聊天触发器",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-48,
-240
],
"webhookId": "87dac172-bf37-4f9d-982a-d5ecddc07f38",
"parameters": {
"options": {
"responseMode": "responseNodes"
}
},
"typeVersion": 1.3
},
{
"id": "ad1d74e7-99a7-481d-8b1e-1c10c41d5571",
"name": "项目经理代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
288,
0
],
"parameters": {
"options": {
"systemMessage": "Goal:\nYou are only helping the user create new tasks in a Google Sheet. Do not handle updates yet.\n\nProcess:\n\nStart by determining whether the user wants to create a new item or update an existing one.\n\nContinue chatting naturally with the user until:\n\nYou know that they want to update (in which case you’ll stop and output that), or\n\nYou’ve gathered all the necessary fields for a new task.\n\nRequired fields for creating a new task:\n\nTask\n\nDescription\n\nStatus\n\nThe user can respond with “don’t know,” in which case that field is left blank (output nothing for that field).\n\nOutput Format:\n\n{\n \"response\": \"Your message back to the user\",\n \"info gathered\": {\n \"type\": \"create or update\",\n \"Task\": \"\",\n \"Description\": \"\",\n \"Status\": \"\"\n },\n \"all Info\": \"Yes or No\"\n}\n\n\nRules:\n\n\"type\" can only be \"create\" or \"update\".\n\n\"all Info\" can only be \"Yes\" or \"No\", depending on whether you have all required fields for the chosen action.\n\nKeep chatting with the user until \"all Info\" = \"Yes\"."
},
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "59010e50-ee02-4de3-b5a0-346d4178a449",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
64,
432
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "LC2f70Ar9JzG209n",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "a848cc81-5f47-4858-8a12-9a831486e071",
"name": "聊天记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
320,
256
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "10c72aeb-b224-49fb-86cd-93470008271b",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
496,
256
],
"parameters": {
"autoFix": true,
"jsonSchemaExample": "{\n\t\"response\": \"what you want to say back to the user\", \n \"info gathered\": \"all of the info you have gathered so far\", \n \"all Info\": \"Yes or no if you have all of the fields\"\n}"
},
"typeVersion": 1.3
},
{
"id": "6fb809a0-142c-400b-b9de-e18ad05b2a07",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
512,
432
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "LC2f70Ar9JzG209n",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "f14a95f4-5673-43f6-91f8-c23f2c15d508",
"name": "OpenAI 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1216,
-64
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "LC2f70Ar9JzG209n",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "cee60393-1bd8-4f9d-a9d2-d905b5a52806",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1440,
-80
],
"parameters": {
"jsonSchemaExample": "{\n\t\"task\": \"task\",\n\t\"description\": \"description\",\n \"status\": \"status\"\n}"
},
"typeVersion": 1.3
},
{
"id": "2b3667cb-be26-496a-adf0-1e0057d0483f",
"name": "写入 Json",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1264,
-288
],
"parameters": {
"text": "={{ $json.output['info gathered'] }}",
"options": {
"systemMessage": "take in this info and parse it into this json. "
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "724db2b3-48c4-4979-bdd8-b56db7473cf0",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-448
],
"parameters": {
"color": 7,
"width": 2448,
"height": 1136,
"content": "### AI 项目经理 — 从聊天添加任务到 Google 表格"
},
"typeVersion": 1
},
{
"id": "705cd275-88bd-4002-9e0e-cbc070614196",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-448
],
"parameters": {
"width": 400,
"height": 1136,
"content": "## ⚙️ 设置说明"
},
"typeVersion": 1
},
{
"id": "7783171c-3b32-4a8c-8b50-4017c024506a",
"name": "便签64",
"type": "n8n-nodes-base.stickyNote",
"position": [
1632,
-272
],
"parameters": {
"color": 3,
"width": 256,
"height": 656,
"content": "### 2) 连接 Google Sheets（OAuth2）"
},
"typeVersion": 1
},
{
"id": "d3082998-cae4-4be1-97a4-55c37fae9452",
"name": "添加任务",
"type": "n8n-nodes-base.googleSheets",
"position": [
1712,
160
],
"parameters": {
"columns": {
"value": {
"Task": "={{ $json.output.task }}",
"Status": "={{ $json.output.status }}",
"Description": "={{ $json.output.description }}"
},
"schema": [
{
"id": "Task",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Task",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Description",
"type": "string",
"display": true,
"required": false,
"displayName": "Description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Task"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pbK-B-Q9p8fVjxJIsjEVrAfRgqEPCeYw8rZojZPAb84/edit#gid=0",
"cachedResultName": "Tasks"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1pbK-B-Q9p8fVjxJIsjEVrAfRgqEPCeYw8rZojZPAb84",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pbK-B-Q9p8fVjxJIsjEVrAfRgqEPCeYw8rZojZPAb84/edit?usp=drivesdk",
"cachedResultName": "Project Manager"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "0cfb869e-1572-4a14-b280-f41c274b5c3e",
"name": "响应完成",
"type": "@n8n/n8n-nodes-langchain.chat",
"position": [
2000,
-288
],
"parameters": {
"message": "=Item Added",
"options": {},
"waitUserReply": false
},
"typeVersion": 1
},
{
"id": "72085766-5d15-4556-b034-2b009340bfbd",
"name": "拥有所有信息？",
"type": "n8n-nodes-base.if",
"position": [
640,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "852bfa85-8367-4822-ae6b-e8490c57f00e",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.output['all Info'] }}",
"rightValue": "Yes"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "eaa01a56-d5c6-415e-b445-56a8dedc8a5e",
"name": "便签29",
"type": "n8n-nodes-base.stickyNote",
"position": [
-48,
256
],
"parameters": {
"color": 3,
"width": 288,
"height": 304,
"content": "### 1 设置 OpenAI 连接"
},
"typeVersion": 1
},
{
"id": "6959a232-2f84-438e-830a-15cc240f6c5b",
"name": "获取更多信息",
"type": "@n8n/n8n-nodes-langchain.chat",
"position": [
992,
128
],
"parameters": {
"message": "={{ $json.output.response }}",
"options": {},
"waitUserReply": false
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Add Task": {
"main": [
[
{
"node": "Respond Complete",
"type": "main",
"index": 0
}
]
]
},
"Write Json": {
"main": [
[
{
"node": "Add Task",
"type": "main",
"index": 0
}
]
]
},
"Chat Memory": {
"ai_memory": [
[
{
"node": "Project Manager Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Chat Trigger": {
"main": [
[
{
"node": "Project Manager Agent",
"type": "main",
"index": 0
}
]
]
},
"Have All Info?": {
"main": [
[
{
"node": "Write Json",
"type": "main",
"index": 0
}
],
[
{
"node": "Get More Info",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Project Manager Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Structured Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "Write Json",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Project Manager Agent": {
"main": [
[
{
"node": "Have All Info?",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Project Manager Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "Write Json",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Project Management、AI Chatbot等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 GPT-4o-mini 代理自动进行潜在客户资格认定与客户支持
使用 GPT-4o-mini 代理自动进行潜在客户资格认定与客户支持
If
Set
Code
+8
16 节点Robert Breen
Lead Nurturing
博客写作与编辑器
基于Google Sheets记忆的博客写作与编辑器 (GPT-4)
If
Code
Filter
+10
18 节点Robert Breen
Content Creation
使用GPT-5 Nano多语言聊天机器人自动处理电商客户支持
使用GPT-5 Nano多语言聊天机器人自动处理电商客户支持
Set
Merge
Split Out
+6
13 节点Robert Breen
AI Chatbot
使用 GPT-4o 聊天从自然语言查询生成 BigQuery SQL
使用 GPT-4o 聊天从自然语言查询生成 BigQuery SQL
Code
Merge
Aggregate
+7
13 节点Robert Breen
Internal Wiki
通过短信使用 GPT-4o、Twilio 和 Google Sheets 筛选房地产潜在客户
通过短信使用 GPT-4o、Twilio 和 Google Sheets 筛选房地产潜在客户
If
Wait
Twilio
+10
23 节点Robert Breen
Lead Nurturing
AI网站聊天机器人 - GPT与Google表格CRM线索收集
集成GPT和Google表格的AI网站聊天机器人 - CRM线索收集系统
Code
Google Sheets
Agent
+7
14 节点Robert Breen
Lead Generation
工作流信息
难度等级
高级
节点数量17
分类2
节点类型9
作者
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
外部链接
在 n8n.io 上查看 →
分享此工作流