8
n8n 中文网amn8n.com

自动筛选和阶段移动

中级

这是一个HR领域的自动化工作流，包含 12 个节点。主要使用 If, Gmail, ClickUp, GoogleSheets, ManualTrigger 等节点。 使用Sheets、Gmail、ClickUp和Calendly自动化HR候选人筛选

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Google Sheets API 凭证

使用的节点 (12)

If
Gmail
ClickUp
StickyNote
GoogleSheets
ManualTrigger

分类

人力资源
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "K90xXcomw9TStJaJ",
  "meta": {
    "instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
    "templateCredsSetupCompleted": true
  },
  "name": "自动筛选和阶段移动",
  "tags": [],
  "nodes": [
    {
      "id": "43002ed8-acce-4d29-ad66-699c73b02d34",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -400,
        992
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4ebed495-ccb8-40ac-99f8-6a3b6167d59e",
      "name": "获取所有候选人记录",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -176,
        992
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1424038785,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA/edit#gid=1424038785",
          "cachedResultName": "Sheet2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1JlXxy90s0we_IqErHyvomrJSijb8pd4H91hOUCH6xCA/edit?usp=drivesdk",
          "cachedResultName": "Resume store"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "s4dP1fNuVZ2gWvs3",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "8b80964b-ae94-48f5-9f67-2aeb2299fa6b",
      "name": "筛选高分候选人",
      "type": "n8n-nodes-base.if",
      "position": [
        48,
        992
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "a2452d84-cf9b-4c61-bbd9-485ef1aa23f4",
              "operator": {
                "type": "number",
                "operation": "gt"
              },
              "leftValue": "={{ $json.Score}}",
              "rightValue": 70
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "a4aa56b3-cf55-45bd-bfcb-2f5bd671730a",
      "name": "发送祝贺邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        272,
        992
      ],
      "webhookId": "2122a833-8e99-41ac-b3ab-beac7ebc38e4",
      "parameters": {
        "sendTo": "{{ $json.receiver_email }}",
        "message": "=Hii {{ $json.Name }}!\n\nCongratulations for moving forward.\nPlease book your calendly time slot.\nhttps://calendly.com/anuj-techdome/30min",
        "options": {},
        "subject": "=Congratulations! {{ $json.Name }} for moving forward",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "RchiXdmY8WaQhOSJ",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "5f8674a5-eb1e-4e1e-a06c-185902e5a965",
      "name": "在 ClickUp 中创建筛选任务",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        496,
        992
      ],
      "parameters": {
        "list": "901610812551",
        "name": "=Screening {{ $('Filter High-Score Candidates').item.json.Name }} TO BE DONE",
        "team": "9016683627",
        "space": "90162844741",
        "folder": "90164394824",
        "additionalFields": {
          "assignees": [
            95074494
          ]
        }
      },
      "credentials": {
        "clickUpApi": {
          "id": "FwrdqPtvlxnMFvdx",
          "name": "ClickUp account-Anuj"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e3f57c76-3a7b-4980-938d-b467c14364c6",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        1168
      ],
      "parameters": {
        "width": 320,
        "height": 280,
        "content": "## 🚀 启动流程"
      },
      "typeVersion": 1
    },
    {
      "id": "c25d82b5-f8cb-412b-9d50-0cdc9699e569",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -352,
        624
      ],
      "parameters": {
        "width": 320,
        "height": 336,
        "content": "## 📊 数据检索"
      },
      "typeVersion": 1
    },
    {
      "id": "689e0030-bf25-43f3-b99d-2bc1727c89cd",
      "name": "便签 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        1184
      ],
      "parameters": {
        "width": 320,
        "height": 372,
        "content": "## 🔍 资格筛选"
      },
      "typeVersion": 1
    },
    {
      "id": "1bebc8b2-183e-43ac-8883-5901aad35ed6",
      "name": "便签 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        144,
        592
      ],
      "parameters": {
        "width": 320,
        "height": 372,
        "content": "## 📧 候选人通知"
      },
      "typeVersion": 1
    },
    {
      "id": "ae10a73b-da03-4c2e-9b56-5c7746d2c287",
      "name": "便签 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        480,
        1184
      ],
      "parameters": {
        "width": 320,
        "height": 412,
        "content": "## 📋 任务管理"
      },
      "typeVersion": 1
    },
    {
      "id": "449a2ec7-a2d8-43eb-a1d8-3e148108f4b2",
      "name": "便签6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1136,
        672
      ],
      "parameters": {
        "width": 440,
        "height": 776,
        "content": "## 🎯 自动筛选和阶段移动工作流"
      },
      "typeVersion": 1
    },
    {
      "id": "53306dfd-4d03-404a-b568-ffe307dc20ed",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        704
      ],
      "parameters": {
        "width": 360,
        "height": 500,
        "content": "## ⚙️ 配置设置"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "c2746ca9-779a-4021-b6c8-e43ab32c3276",
  "connections": {
    "Send Congratulations Email": {
      "main": [
        [
          {
            "node": "Create Screening Task in ClickUp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch All Candidate Records": {
      "main": [
        [
          {
            "node": "Filter High-Score Candidates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter High-Score Candidates": {
      "main": [
        [
          {
            "node": "Send Congratulations Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Fetch All Candidate Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 人力资源

需要付费吗？

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

相关工作流推荐

结构化面试反馈收集
使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝
If
Code
Gmail
+6
18 节点Rahul Joshi
人力资源
个性化拒绝/下一步邮件
使用Google Sheets、GPT-4o-mini、Gmail和ClickUp自动化候选人拒绝
If
Set
Code
+7
38 节点Rahul Joshi
人力资源
新开发人员入职自动化
使用 GPT-4o 实现员工入职自动化：Jira、Notion 和 Gmail 集成
If
Set
Code
+9
21 节点Rahul Joshi
人力资源
待处理付款自动化 - ClickUp集成
使用Google Sheets、ClickUp、Gmail和Slack自动化付款跟踪
If
Gmail
Slack
+4
12 节点Rahul Joshi
内容创作
面试官简报包
使用Google表格和GPT-4o从简历生成AI驱动的面试简报
Code
Gmail
Google Drive
+6
16 节点Rahul Joshi
人力资源
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
工作流信息
难度等级
中级
节点数量12
分类1
节点类型6
难度说明

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

作者
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 查看 →

分享此工作流