8
n8n 中文网amn8n.com

使用OpenAI GPT自然语言查询Trello看板

中级

这是一个AI Chatbot, Multimodal AI领域的自动化工作流，包含 15 个节点。主要使用 Set, Merge, Trello, Aggregate, Agent 等节点。 使用OpenAI GPT通过自然语言查询Trello看板

前置要求
  • •OpenAI API Key

使用的节点 (15)

Set
Merge
Trello
Aggregate
StickyNote
Agent
ChatTrigger
LmChatOpenAi
MemoryBufferWindow

分类

AI 聊天机器人
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "7e5004b9-222b-4685-9f2c-248def0db89c",
      "name": "OpenAI 聊天模型1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        448,
        8080
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-5-nano",
          "cachedResultName": "gpt-5-nano"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "4l6TDfLZVFS24g3X",
          "name": "OpenAi account 4"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "7224dcb8-9d1e-4bc0-8410-b2bc2644d4af",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -944,
        7360
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": "## ⚙️ 设置说明"
      },
      "typeVersion": 1
    },
    {
      "id": "c22061aa-f423-4eba-959d-76df33468dc7",
      "name": "Sticky Note53",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        7360
      ],
      "parameters": {
        "color": 7,
        "width": 1504,
        "height": 928,
        "content": "# 💬 与您的 Trello 看板对话 (n8n + OpenAI)"
      },
      "typeVersion": 1
    },
    {
      "id": "6e1ad091-728f-40ab-ab24-ec1725e014b1",
      "name": "Sticky Note54",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        7904
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 304,
        "content": "### 2️⃣ 设置 OpenAI 连接"
      },
      "typeVersion": 1
    },
    {
      "id": "50e502a8-b9d1-4c1a-b7df-89ba16ffb9ca",
      "name": "获取看板3",
      "type": "n8n-nodes-base.trello",
      "position": [
        -416,
        7760
      ],
      "parameters": {
        "id": {
          "__rl": true,
          "mode": "url",
          "value": "https://trello.com/b/DCpuJbnd/administrative-tasks"
        },
        "resource": "board",
        "operation": "get",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "49a15c6f-e6ae-4e11-a862-9f22f6063f1f",
      "name": "获取列表3",
      "type": "n8n-nodes-base.trello",
      "position": [
        -208,
        8096
      ],
      "parameters": {
        "id": "={{ $json.id }}",
        "resource": "list",
        "operation": "getAll",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "2d9ab2fc-7eb1-4c49-bb3d-888f69705ed9",
      "name": "获取卡片3",
      "type": "n8n-nodes-base.trello",
      "position": [
        -96,
        7648
      ],
      "parameters": {
        "id": "={{ $json.id }}",
        "resource": "list",
        "operation": "getCards",
        "additionalFields": {}
      },
      "credentials": {
        "trelloApi": {
          "id": "0inUg5020tWOj6Qr",
          "name": "Trello account 4"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "379e1633-90dd-49ab-ac55-3b37092e2d6e",
      "name": "映射字段3",
      "type": "n8n-nodes-base.set",
      "position": [
        64,
        7776
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "3c2613df-a000-4c8e-bd27-2aef696f5ced",
              "name": "Board Name",
              "type": "string",
              "value": "={{ $('Get Board3').item.json.name }}"
            },
            {
              "id": "e4048a3f-d352-4b1f-a76a-4fbf9b74b163",
              "name": "List Name",
              "type": "string",
              "value": "={{ $('Get Lists3').item.json.name }}"
            },
            {
              "id": "d0236a8a-8129-4370-b241-9e27adcb9952",
              "name": "Task Name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "8b6b23c1-1661-4af7-b62d-4facaf0d2651",
              "name": "Task Description",
              "type": "string",
              "value": "={{ $json.desc }}"
            },
            {
              "id": "69b2b12a-9e67-4313-b395-83a5b613a0d7",
              "name": "badges.due",
              "type": "string",
              "value": "={{ $json.badges.due }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "9a6f85cd-6a72-4de1-8731-43f8a9cb9e7e",
      "name": "合并为一个1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        208,
        7648
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "fc282406-1bdc-4f72-9e9a-6520d20881c2",
      "name": "Sticky Note55",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        7920
      ],
      "parameters": {
        "color": 3,
        "width": 336,
        "height": 304,
        "content": "### 1️⃣ 连接 Trello（开发者 API）"
      },
      "typeVersion": 1
    },
    {
      "id": "dee41412-f458-43b5-a918-aa8badd79cdc",
      "name": "当收到聊天消息时",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -448,
        7536
      ],
      "webhookId": "9c5af39a-d2a0-4837-9315-2f88184b8ab6",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.3
    },
    {
      "id": "9acdfd7e-acd4-4a87-b850-f60677e89433",
      "name": "简单记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        768,
        8064
      ],
      "parameters": {
        "sessionKey": "={{ $('Merge With Chat').item.json.sessionId }}",
        "sessionIdType": "customKey"
      },
      "typeVersion": 1.3
    },
    {
      "id": "cd0c4fe0-60cb-4e47-b7c5-53272b6274af",
      "name": "编辑字段1",
      "type": "n8n-nodes-base.set",
      "position": [
        656,
        7504
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "0e3cf129-4b85-4255-ba25-5663531e9a0f",
              "name": "trello",
              "type": "string",
              "value": "={{ $json.data }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "10874d59-574e-47ff-8b8b-794193fafa26",
      "name": "与聊天合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        368,
        7536
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "f7ea9fe1-2ec3-46de-b046-38a995d3edc2",
      "name": "Trello 聊天机器人",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        592,
        7744
      ],
      "parameters": {
        "text": "=trellow board aggregation: {{ $json.trello }} Chat message: {{ $('Merge With Chat').item.json.chatInput }} ",
        "options": {
          "systemMessage": "Summarize this board"
        },
        "promptType": "define"
      },
      "typeVersion": 2.2
    }
  ],
  "pinData": {},
  "connections": {
    "Get Board3": {
      "main": [
        [
          {
            "node": "Get Lists3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Cards3": {
      "main": [
        [
          {
            "node": "Map Fields3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Lists3": {
      "main": [
        [
          {
            "node": "Get Cards3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Map Fields3": {
      "main": [
        [
          {
            "node": "Combine into One1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Trello Chatbot",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "Trello Chatbot",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Trello Chatbot": {
      "main": [
        []
      ]
    },
    "Merge With Chat": {
      "main": [
        [
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine into One1": {
      "main": [
        [
          {
            "node": "Merge With Chat",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Trello Chatbot",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "Get Board3",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge With Chat",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - AI 聊天机器人, 多模态 AI

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

使用 GPT-4o 通过自然语言查询 Monday.com 任务
使用 GPT-4o 通过自然语言查询 Monday.com 任务
Set
Merge
Aggregate
+6
13 节点Robert Breen
AI 聊天机器人
使用GPT-5 Nano多语言聊天机器人自动处理电商客户支持
使用GPT-5 Nano多语言聊天机器人自动处理电商客户支持
Set
Merge
Split Out
+6
13 节点Robert Breen
AI 聊天机器人
新闻搜索与分类聊天机器人（Google News、SerpAPI和OpenAI）
使用Google News、SerpAPI和OpenAI的新闻搜索与分类聊天机器人
Split Out
Aggregate
Serp Api
+5
11 节点Robert Breen
AI 聊天机器人
使用 GPT-4o 聊天从自然语言查询生成 BigQuery SQL
使用 GPT-4o 聊天从自然语言查询生成 BigQuery SQL
Code
Merge
Aggregate
+7
13 节点Robert Breen
内部知识库
使用 GPT-4o 通过自然语言查询搜索 Outlook 邮件
使用 GPT-4o 通过自然语言查询搜索 Outlook 邮件
Merge
Aggregate
Agent
+6
17 节点Robert Breen
AI RAG 检索增强
基于 Google Finance、SerpAPI 和 OpenAI 的财务数据问答聊天机器人
集成 Google Finance、SerpAPI 和 OpenAI 的财务数据问答聊天机器人
Set
Http Request
Agent
+3
9 节点Robert Breen
AI 聊天机器人
工作流信息
难度等级
中级
节点数量15
分类2
节点类型9
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Robert Breen

Robert Breen

@rbreen

Professional 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 查看 →

分享此工作流