8
n8n 中文网amn8n.com

优先级跟进队列构建器

高级

这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 18 个节点。主要使用 Sort, Limit, ClickUp, Function, GoogleSheets 等节点。 使用 Google Sheets + ClickUp 自动进行潜在客户排名与任务创建

前置要求
  • •Google Sheets API 凭证

使用的节点 (18)

Sort
Limit
ClickUp
Function
StickyNote
GoogleSheets
ManualTrigger

分类

内容创作
多模态 AI
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "EHOx9tJ71PVTuz5c",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "优先级跟进队列构建器",
  "tags": [],
  "nodes": [
    {
      "id": "f6fbaebc-f91b-4f31-810b-945d282a29b2",
      "name": "手动触发器",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        944,
        704
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6dab30f9-0b1c-463f-909c-0b9239dbf1cd",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        624
      ],
      "parameters": {
        "width": 380,
        "height": 280,
        "content": "## 🚀 工作流开始"
      },
      "typeVersion": 1
    },
    {
      "id": "24b80916-7fbf-415c-89fe-ec198bf10623",
      "name": "从表格读取潜在客户",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1168,
        704
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hYKQSySynmFlOwF1MJZko7kiY9wJE26M-l5bgeoEw98/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1hYKQSySynmFlOwF1MJZko7kiY9wJE26M-l5bgeoEw98",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hYKQSySynmFlOwF1MJZko7kiY9wJE26M-l5bgeoEw98/edit?usp=drivesdk",
          "cachedResultName": "Priority followup"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "68039cea-d1b3-4395-88e9-ea530e8d2eec",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1056,
        352
      ],
      "parameters": {
        "width": 300,
        "height": 332,
        "content": "## 📊 步骤 1：读取潜在客户数据"
      },
      "typeVersion": 1
    },
    {
      "id": "a11cadaa-c5e6-4f36-8c09-be885e0484b0",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1296,
        864
      ],
      "parameters": {
        "width": 300,
        "height": 304,
        "content": "## ⏰ 步骤 2：计算最近联系时间"
      },
      "typeVersion": 1
    },
    {
      "id": "58f3405e-6db0-4dee-8efc-704f460299d8",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1536,
        320
      ],
      "parameters": {
        "width": 300,
        "height": 340,
        "content": "## 🎯 步骤 3：计算优先级"
      },
      "typeVersion": 1
    },
    {
      "id": "3501da06-dcb6-403a-96d1-8b8524958f7e",
      "name": "按优先级分数排序",
      "type": "n8n-nodes-base.sort",
      "position": [
        1840,
        704
      ],
      "parameters": {
        "options": {},
        "sortFieldsUi": {
          "sortField": [
            {
              "order": "descending",
              "fieldName": "Priority_Score"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "367e537c-63b2-47bb-86b3-96102cc54081",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1776,
        880
      ],
      "parameters": {
        "width": 280,
        "height": 164,
        "content": "## 📈 步骤 4：排序潜在客户"
      },
      "typeVersion": 1
    },
    {
      "id": "b7f1fd67-804a-4f67-9817-e6be404a2aff",
      "name": "选择前 10 名潜在客户",
      "type": "n8n-nodes-base.limit",
      "position": [
        2064,
        704
      ],
      "parameters": {
        "maxItems": 10
      },
      "typeVersion": 1
    },
    {
      "id": "024f813e-41c8-42fb-a6c4-3a61b3d4232b",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2000,
        400
      ],
      "parameters": {
        "width": 280,
        "height": 264,
        "content": "## 🔝 步骤 5：筛选最高优先级潜在客户"
      },
      "typeVersion": 1
    },
    {
      "id": "a2905675-38e1-4ebb-892b-e428af5245f9",
      "name": "建议最佳发送时间",
      "type": "n8n-nodes-base.function",
      "position": [
        2288,
        704
      ],
      "parameters": {
        "functionCode": "// Suggest optimal send time based on lead's timezone\nreturn items.map(item => {\n  const tz = (item.json.Timezone || '').toUpperCase();\n  let suggestedTime = '9:00 AM';\n  \n  // Timezone-specific recommendations\n  if (tz.includes('IST')) suggestedTime = '10:00 AM IST';\n  else if (tz.includes('PST')) suggestedTime = '9:00 AM PST';\n  else if (tz.includes('EST')) suggestedTime = '9:30 AM EST';\n  else if (tz.includes('GMT')) suggestedTime = '9:00 AM GMT';\n  \n  item.json.Suggested_Send_Time = suggestedTime;\n  \n  return item;\n});"
      },
      "typeVersion": 1
    },
    {
      "id": "a46f0103-bcdc-4d4b-957e-a2d0d1b8d532",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2224,
        880
      ],
      "parameters": {
        "width": 300,
        "height": 320,
        "content": "## 🕐 步骤 6：时间优化"
      },
      "typeVersion": 1
    },
    {
      "id": "2545f230-e090-413c-aec2-b02c1b82fc62",
      "name": "创建 ClickUp 任务",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        2512,
        704
      ],
      "parameters": {
        "list": "901611225384",
        "name": "={{ $json.Lead_Name }} - Priority Follow-up",
        "team": "90161261705",
        "space": "90165174252",
        "folderless": true,
        "additionalFields": {}
      },
      "credentials": {
        "clickUpApi": {
          "id": "mcOAWijv7qCSnkNx",
          "name": "ClickUp account-test anuj"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "15b9e908-0b83-4256-b1e5-50fda3da8c51",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2464,
        336
      ],
      "parameters": {
        "width": 300,
        "height": 320,
        "content": "## ✅ 步骤 7：创建任务"
      },
      "typeVersion": 1
    },
    {
      "id": "437dec32-0caf-4493-ab5e-e530b8ec7803",
      "name": "更新表格 - 标记为已排队",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2736,
        704
      ],
      "parameters": {
        "options": {},
        "dataMode": "autoMapInputData",
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 704813266,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hYKQSySynmFlOwF1MJZko7kiY9wJE26M-l5bgeoEw98/edit#gid=704813266",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1hYKQSySynmFlOwF1MJZko7kiY9wJE26M-l5bgeoEw98",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hYKQSySynmFlOwF1MJZko7kiY9wJE26M-l5bgeoEw98/edit?usp=drivesdk",
          "cachedResultName": "Priority followup"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "4c1dfd1b-b7c2-474b-b9be-0d0b3d40c7cc",
      "name": "## 为什么选择 4o 模型？👆",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2688,
        912
      ],
      "parameters": {
        "width": 300,
        "height": 268,
        "content": "## 📝 步骤 8：更新记录"
      },
      "typeVersion": 1
    },
    {
      "id": "3bba318c-52ef-49ff-95ff-ed546bb0fcf9",
      "name": "计算自上次联系天数1",
      "type": "n8n-nodes-base.function",
      "position": [
        1392,
        704
      ],
      "parameters": {
        "functionCode": "// Calculate how many days have passed since last contact\nconst today = new Date();\n\nreturn items.map(item => {\n  const lastContact = new Date(item.json.Last_Contact_Date);\n  const diffDays = Math.floor((today - lastContact) / (1000 * 60 * 60 * 24));\n  \n  item.json.Days_Since_Last_Contact = diffDays;\n  \n  return item;\n});"
      },
      "typeVersion": 1
    },
    {
      "id": "5875baa9-f729-4f6c-872a-9f621b9470dc",
      "name": "计算优先级分数1",
      "type": "n8n-nodes-base.function",
      "position": [
        1616,
        704
      ],
      "parameters": {
        "functionCode": "// Calculate priority score combining engagement and recency\nreturn items.map(item => {\n  const engagement = parseFloat(item.json.Engagement_Score) || 0;\n  const days = parseFloat(item.json.Days_Since_Last_Contact) || 0;\n  \n  // Recency score: 100 points minus days (0-100 scale)\n  const recencyScore = Math.max(0, 100 - days);\n  \n  // Priority Score: 70% engagement + 30% recency\n  item.json.Priority_Score = Math.round((engagement * 0.7) + (recencyScore * 0.3));\n  \n  return item;\n});"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4bc03222-7267-4d72-be6d-6be0c3e3b6c7",
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Read Leads from Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create ClickUp Task": {
      "main": [
        [
          {
            "node": "Update Sheet - Mark as Queued",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select Top 10 Leads": {
      "main": [
        [
          {
            "node": "Suggest Optimal Send Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Leads from Sheet": {
      "main": [
        [
          {
            "node": "Calculate Days Since Contact1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sort by Priority Score": {
      "main": [
        [
          {
            "node": "Select Top 10 Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Priority Score1": {
      "main": [
        [
          {
            "node": "Sort by Priority Score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Suggest Optimal Send Time": {
      "main": [
        [
          {
            "node": "Create ClickUp Task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Days Since Contact1": {
      "main": [
        [
          {
            "node": "Calculate Priority Score1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 内容创作, 多模态 AI

需要付费吗？

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

相关工作流推荐

待处理付款自动化 - ClickUp集成
使用Google Sheets、ClickUp、Gmail和Slack自动化付款跟踪
If
Gmail
Slack
+4
12 节点Rahul Joshi
内容创作
客户入职帮助请求（Typeform 到 Gmail 和 Sheets）
客户入职帮助请求（Typeform 到 Gmail 和 Sheets）
If
Code
Gmail
+10
28 节点Rahul Joshi
内容创作
面试质量审计
使用GPT-4o-mini和Google表格通过Slack审核面试反馈并生成报告
If
Code
Slack
+5
23 节点Rahul Joshi
内容创作
Bug汇总器
自动Bug报告汇总器：将Zendesk Bug工单同步到Google表格
If
Zendesk
Google Sheets
+2
11 节点Rahul Joshi
内容创作
潜在客户意图分类与自动任务创建器
使用 Azure GPT-4 从 Google Sheets 到 ClickUp 自动进行潜在客户意图分类
Set
Switch
Click Up
+9
32 节点Rahul Joshi
内容创作
使用Stripe、Google Drive和Google Sheets归档付款收据
自动化付款收据：通过Stripe和Google Workspace发送邮件、归档和跟踪
If
Gmail
Split Out
+5
21 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量18
分类2
节点类型7
难度说明

适合高级用户，包含 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 查看 →

分享此工作流