COO任务优先级排序
中级
这是一个AI, IT Ops领域的自动化工作流，包含 15 个节点。主要使用 Asana, Postgres, Agent, ScheduleTrigger, LmChatOpenAi 等节点，结合人工智能技术实现智能自动化。 基于GPT-4和Pinecone Memory的AI驱动Asana任务优先级排序
前置要求
- •PostgreSQL 数据库连接信息
- •OpenAI API Key
- •Pinecone API Key
使用的节点 (15)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "czDg0Q7wsAoqYQIx",
"meta": {
"instanceId": "84ad02d6104594179f43f1ce9cfe3a81637b2faedb57dafcb9e649b7542988db"
},
"name": "COO 任务优先级排序",
"tags": [],
"nodes": [
{
"id": "39d955ab-7c8e-4faa-ae3d-948dfa5e0615",
"name": "Pinecone Vector Store",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
640,
500
],
"parameters": {
"options": {},
"pineconeIndex": {
"__rl": true,
"mode": "list",
"value": ""
}
},
"credentials": {
"pineconeApi": {
"id": "PSI5CiZnLRSkEgJg",
"name": "PineconeApi account"
}
},
"typeVersion": 1.1
},
{
"id": "923a5e54-785a-4c4f-b6b8-f540bb1c4e19",
"name": "每日 9 点触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "28adcd8d-e4cf-45f7-ad32-16ffe30a525b",
"name": "获取任务",
"type": "n8n-nodes-base.asana",
"position": [
220,
0
],
"parameters": {
"filters": {
"project": ""
},
"operation": "getAll",
"returnAll": true
},
"typeVersion": 1
},
{
"id": "b43946e1-1b62-46fc-9211-72551b6c55c7",
"name": "COO 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
660,
0
],
"parameters": {
"text": "={{ $json.data }}",
"options": {
"systemMessage": "=You are a COO AI agent that helps prioritize operational tasks. Use the retrieved context from vector_database_tool to assess task urgency and strategic importance.\n\nFor the most priority task, output:\n\nTask Name\n\nPriority Level: High / Medium / Low\n\nDue Date\n\nReason for Priority\n\nConsider urgency (due date), impact on operations, and dependencies retrieved from vector knowledge.\nJust give back the most important task"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "b716a7b4-0357-4730-89b2-8bc295d5a22a",
"name": "保存优先级任务",
"type": "n8n-nodes-base.postgres",
"position": [
1600,
0
],
"parameters": {
"table": {
"__rl": true,
"mode": "list",
"value": "prioritized_tasks",
"cachedResultName": "prioritized_tasks"
},
"schema": {
"__rl": true,
"mode": "list",
"value": "public"
},
"columns": {
"value": {
"task_name": "={{ $json.output.tasks[0][\"Task Name\"] }}",
"priority_level": "={{ $json.output.tasks[0][\"Priority Level\"] }}",
"reason_for_priority": "={{ $json.output.tasks[0][\"Reason for Priority\"] }}"
},
"schema": [
{
"id": "id",
"type": "number",
"display": true,
"removed": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "task_name",
"type": "string",
"display": true,
"required": true,
"displayName": "task_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "priority_level",
"type": "string",
"display": true,
"required": false,
"displayName": "priority_level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reason_for_priority",
"type": "string",
"display": true,
"required": false,
"displayName": "reason_for_priority",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"credentials": {
"postgres": {
"id": "6DsmtQnULFUnNgy4",
"name": "Postgres account"
}
},
"typeVersion": 2.6
},
{
"id": "759f799a-d046-4609-8894-99a9b951e43f",
"name": "任务推理模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
560,
260
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "wYwTjEv45IzlAOAu",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "4e3a60ec-d900-44e9-beaf-0de5905d9b2e",
"name": "优先级输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1120,
180
],
"parameters": {
"jsonSchemaExample": "{\n \"tasks\": [\n {\n \"Task Name\": \"Review quarterly KPIs\",\n \"Priority Level\": \"High\",\n \"Reason for Priority\": \"Provides critical performance metrics for all departments; deadline is approaching.\"\n },\n"
},
"typeVersion": 1.2
},
{
"id": "d7ae1305-e2f2-44c0-9c21-8cb29310a5d8",
"name": "任务知识向量数据库",
"type": "@n8n/n8n-nodes-langchain.toolVectorStore",
"position": [
820,
220
],
"parameters": {
"name": "vector_database_tool",
"description": "与任务优先级排序相关的信息在此处"
},
"typeVersion": 1
},
{
"id": "906b83fc-d501-4442-b470-3e90148ace33",
"name": "向量查询模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
960,
440
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "wYwTjEv45IzlAOAu",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "e2b8e43c-1f7e-43e0-bba1-d186776d1e2b",
"name": "生成任务嵌入",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
580,
720
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "wYwTjEv45IzlAOAu",
"name": "OpenAi account 2"
}
},
"typeVersion": 1.2
},
{
"id": "61c92166-6068-4884-ac39-af52ae4a496a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-480
],
"parameters": {
"color": 6,
"width": 400,
"height": 680,
"content": "## 🔁 第一部分：触发器与数据检索"
},
"typeVersion": 1
},
{
"id": "c9d36c9c-2cd3-407c-bc97-c765e6cb3bc6",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
500,
-600
],
"parameters": {
"color": 5,
"width": 760,
"height": 1480,
"content": "## 🧠 第二部分：AI 优先级排序"
},
"typeVersion": 1
},
{
"id": "4030c4f7-140c-453b-8441-4ed230da0928",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1460,
-460
],
"parameters": {
"color": 3,
"width": 380,
"height": 640,
"content": "## 🗃️ 第三部分：数据存储与丰富"
},
"typeVersion": 1
},
{
"id": "cd768682-0aee-41d9-bdbc-0b3e8509a042",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1980,
-460
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "019cb716-597a-49b3-8eeb-fc523f210c8f",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1980,
-120
],
"parameters": {
"color": 4,
"width": 1289,
"height": 2238,
"content": "当然！这是您工作流程的**非常详细、精炼的解释**——采用**清晰、专业的格式**，带有图标，并分为**三个逻辑部分**。这适用于文档、演示或新团队成员入职。"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "8c201cdf-caaa-423e-ad38-f6ac7955ff32",
"connections": {
"COO Agent": {
"main": [
[
{
"node": "Save Prioritized Task",
"type": "main",
"index": 0
}
]
]
},
"Fetch Tasks": {
"main": [
[
{
"node": "COO Agent",
"type": "main",
"index": 0
}
]
]
},
"Daily 9AM Trigger": {
"main": [
[
{
"node": "Fetch Tasks",
"type": "main",
"index": 0
}
]
]
},
"Vector Query Model": {
"ai_languageModel": [
[
{
"node": "Task Knowledge Vector DB",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Task Reasoning Model": {
"ai_languageModel": [
[
{
"node": "COO Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Pinecone Vector Store": {
"ai_vectorStore": [
[
{
"node": "Task Knowledge Vector DB",
"type": "ai_vectorStore",
"index": 0
}
]
]
},
"Priority Output Parser": {
"ai_outputParser": [
[
{
"node": "COO Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Generate Task Embeddings": {
"ai_embedding": [
[
{
"node": "Pinecone Vector Store",
"type": "ai_embedding",
"index": 0
}
]
]
},
"Task Knowledge Vector DB": {
"ai_tool": [
[
{
"node": "COO Agent",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 人工智能, IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
首席财务官预测智能体
基于Stripe数据的GPT-4与Google表格自动化收入预测
Set
Code
Stripe
+9
16 节点Yaron Been
人工智能
CFO 费用审核智能体
使用GPT-4、Airtable和Pinecone向量数据库的自动化费用审批系统
Airtable
Agent
Airtable Trigger
+7
15 节点Yaron Been
人工智能
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
🤖 WhatsApp AI个人助手：GPT-4o、记忆和日程安排功能
AI个人助手：集成GPT-4o、RAG和语音功能，使用Supabase的WhatsApp助手
If
Set
Wait
+22
76 节点Amanda Benks
人工智能
Upwork 职位聚合与通知器
自动化职位搜索：Upwork 机会聚合与 AI 驱动通知器
Set
Gmail
Http Request
+6
13 节点Yaron Been
其他
基于文档的带记忆聊天机器人，使用 OpenAI、Pinecone 和 Google Drive
基于文档的带记忆聊天机器人，使用 OpenAI、Pinecone 和 Google Drive
Merge
Airtable
Aggregate
+15
22 节点Sally
人工智能
工作流信息
难度等级
中级
节点数量15
分类2
节点类型10
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos
外部链接
在 n8n.io 查看 →
分享此工作流