使用 GPT-4o 通过自然语言查询 Monday.com 任务

• •OpenAI API Key

{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "8ba2051a-bd8a-47e0-b475-3d5504bec53d",
      "name": "OpenAI Chat Model7",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1088,
        9792
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "gpt-4o"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "4l6TDfLZVFS24g3X",
          "name": "OpenAi account 4"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "5b288b80-01b6-41fa-9df4-1b0f05b3b684",
      "name": "获取多个项目",
      "type": "n8n-nodes-base.mondayCom",
      "position": [
        224,
        9760
      ],
      "parameters": {
        "boardId": "9865886546",
        "groupId": "new_group29179",
        "resource": "boardItem",
        "operation": "getAll"
      },
      "credentials": {
        "mondayComApi": {
          "id": "swmFzbI2ZRBZwzn5",
          "name": "Monday.com account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f5280014-9a86-44c3-af08-df26a2f13afa",
      "name": "Simple Memory3",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        1360,
        9664
      ],
      "parameters": {
        "sessionKey": "={{ $('Merge with Chat').item.json.sessionId }}",
        "sessionIdType": "customKey"
      },
      "typeVersion": 1.3
    },
    {
      "id": "e90e531d-dac8-487c-96ab-c8c721c49712",
      "name": "Sticky Note65",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        9072
      ],
      "parameters": {
        "color": 7,
        "width": 1488,
        "height": 928,
        "content": "# 💬 与 Monday.com 聊天 (n8n + OpenAI)"
      },
      "typeVersion": 1
    },
    {
      "id": "ad88962e-6fd8-48ea-953d-49399b9d2439",
      "name": "便签23",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -368,
        9072
      ],
      "parameters": {
        "width": 400,
        "height": 928,
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "355aaf4d-fd7e-484b-a0ce-fa9e7530ec99",
      "name": "Set Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        464,
        9792
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "1aa1b62d-d066-41ab-b2e6-91237d4c5980",
              "name": "name",
              "type": "string",
              "value": "={{ $json.name }}"
            },
            {
              "id": "f705bdab-3675-4a36-a072-ed9516f9f228",
              "name": "Status",
              "type": "string",
              "value": "={{ $json.column_values[1].text }}"
            },
            {
              "id": "e23d72c7-f8d1-4751-98d9-63c7842cced6",
              "name": "Due Date",
              "type": "string",
              "value": "={{ $json.column_values[2].value }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "32626cb8-dcf6-4edb-9562-33b7b2e7dc2a",
      "name": "Combine to One Field",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        608,
        9504
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "622e83be-2561-49d4-a47c-e7352d1dc6ec",
      "name": "Merge with Chat",
      "type": "n8n-nodes-base.merge",
      "position": [
        768,
        9296
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3.2
    },
    {
      "id": "c13001b6-577a-4ff3-8ba2-b39456f5d725",
      "name": "Convert to text",
      "type": "n8n-nodes-base.set",
      "position": [
        912,
        9424
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "22d18601-d561-4021-a62b-6dc353907240",
              "name": "data",
              "type": "string",
              "value": "={{ $json.data }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "e3ba1cbd-1997-4384-8abd-fab1f59219dc",
      "name": "Chat with Monday.com",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1184,
        9312
      ],
      "parameters": {
        "text": "=Chat Message: {{ $('Merge with Chat').item.json.chatInput }} Tasks:  {{ $json.data }}",
        "options": {
          "systemMessage": "Use the tasks data to answer the chat message"
        },
        "promptType": "define"
      },
      "typeVersion": 2.2
    },
    {
      "id": "bbb5baca-6411-4d41-8530-3aff0a228513",
      "name": "Sample Chatbot",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        208,
        9280
      ],
      "webhookId": "d38a0072-420b-4de8-86b6-03a8f9a6e254",
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.3
    },
    {
      "id": "3df62184-2163-4718-af00-d4f9cc57fede",
      "name": "便签 70",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        144,
        9424
      ],
      "parameters": {
        "color": 3,
        "width": 256,
        "height": 480,
        "content": "### 2️⃣ 连接 Monday.com 节点"
      },
      "typeVersion": 1
    },
    {
      "id": "0545ed6f-b4b6-4bbb-82aa-a0e1cbf60d1f",
      "name": "便签25",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        9632
      ],
      "parameters": {
        "color": 3,
        "width": 288,
        "height": 304,
        "content": "### 1️⃣ 设置 OpenAI 连接"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Set Fields1": {
      "main": [
        [
          {
            "node": "Combine to One Field",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get many items": {
      "main": [
        [
          {
            "node": "Set Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sample Chatbot": {
      "main": [
        [
          {
            "node": "Get many items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory3": {
      "ai_memory": [
        [
          {
            "node": "Chat with Monday.com",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Convert to text": {
      "main": [
        [
          {
            "node": "Chat with Monday.com",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge with Chat": {
      "main": [
        [
          {
            "node": "Convert to text",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model7": {
      "ai_languageModel": [
        [
          {
            "node": "Chat with Monday.com",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Chat with Monday.com": {
      "main": [
        []
      ]
    },
    "Combine to One Field": {
      "main": [
        [
          {
            "node": "Merge with Chat",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}