ClickUp中的任务分配与所有权

高级

这是一个Lead Generation、AI Summarization领域的自动化工作流,包含 17 个节点。主要使用 If、Code、Cron、ClickUp、GoogleSheets 等节点。 使用GPT-4 Mini的线索资质判定与自动分配:从Google Sheets到ClickUp

前置要求
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "Pr9N8Qv2r0QN4xNn",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "ClickUp 中的任务分配与所有权",
  "tags": [
    {
      "id": "mcI28lNgyo60M2wb",
      "name": "Lead Automation",
      "createdAt": "2025-09-03T08:08:38.479Z",
      "updatedAt": "2025-09-03T08:08:38.479Z"
    }
  ],
  "nodes": [
    {
      "id": "8c83502f-a29c-4048-a6cc-4d98158a5801",
      "name": "每 5 分钟",
      "type": "n8n-nodes-base.cron",
      "position": [
        96,
        352
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "fdd4ac7d-603b-486a-94b7-cbcd02304c45",
      "name": "基础LLM链",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        800,
        336
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "0f73dd56-3892-403d-add1-302b92af9f82",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        752,
        560
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "902b212d-bed6-4448-8bcc-966876cf155a",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        48,
        128
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "b4c12526-52df-4ed3-9f69-285cc4b00884",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        144
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "d040c008-842d-4d99-b09c-dfc01684c948",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        256,
        544
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "e89846e0-2f35-4391-94c1-c777718d62df",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        96
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "c0fc238b-0a2a-4789-b09e-2e835da78ea3",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1152,
        512
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "9baa1c57-20b4-42ac-807e-61e636ffbed3",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1344,
        96
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "791072e2-a9ba-492f-8ec9-f8c14fa7d142",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        512
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "e7803d39-8513-4f2b-9248-e5b425038ddd",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1808,
        96
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "f7560e2f-62d2-448d-9fc5-dc754c222538",
      "name": "重构 AI 输出",
      "type": "n8n-nodes-base.code",
      "position": [
        1200,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "0df28053-2ff9-41f2-8e67-3a18052f6940",
      "name": "创建并分配任务",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        1408,
        336
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bd9a8584-3bb9-4339-932f-fcb62922ec6c",
      "name": "重构 ClickUp 输出",
      "type": "n8n-nodes-base.code",
      "position": [
        1632,
        336
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "57329d9c-43d5-41f1-b409-b4801cedc63f",
      "name": "在表格中更新新任务",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1856,
        336
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "8f82c52b-13da-4556-aa62-92a2fc668a5f",
      "name": "潜在客户资质鉴定",
      "type": "n8n-nodes-base.if",
      "position": [
        544,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1cbc990f-2279-4682-a0d8-70405d19eab0",
      "name": "获取新任务",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        352
      ],
      "parameters": {},
      "typeVersion": 4
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "ffd4e55b-68d1-427b-9c9e-c3910e74cf9f",
  "connections": {
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Restructuring AI Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Every 5 Minutes": {
      "main": [
        [
          {
            "node": "Getting New Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Qualifying Leads": {
      "main": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Getting New Tasks": {
      "main": [
        [
          {
            "node": "Qualifying Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Restructuring AI Output": {
      "main": [
        [
          {
            "node": "Creating and Assigning Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Creating and Assigning Tasks": {
      "main": [
        [
          {
            "node": "Restructuring ClickUp Output",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Restructuring ClickUp Output": {
      "main": [
        [
          {
            "node": "Updating New Tasks on Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

这是一个高级难度的工作流,适用于Lead Generation、AI Summarization等场景。适合高级用户,包含 16+ 个节点的复杂工作流

需要付费吗?

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

工作流信息
难度等级
高级
节点数量17
分类2
节点类型8
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Rahul Joshi

Rahul Joshi

@rahul08

Rahul 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 上查看 →

分享此工作流