8
n8n 中文网amn8n.com

HR简历筛选

高级

这是一个HR, AI Summarization领域的自动化工作流,包含 23 个节点。主要使用 If, Set, Merge, Telegram, GoogleDrive 等节点。 使用Telegram、Gemini AI和Google Workspace自动化简历筛选与分析

前置要求
  • Telegram Bot Token
  • Google Drive API 凭证
  • 可能需要目标 API 的认证凭证
  • Google Sheets API 凭证
  • Google Gemini API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "[WORKFLOW_ID_REMOVED]",
  "meta": {
    "instanceId": "[INSTANCE_ID_REMOVED]"
  },
  "name": "HR 简历筛选",
  "tags": [],
  "nodes": [
    {
      "id": "cbc5c20a-7d3e-49b9-8c05-9e5657cb7ecf",
      "name": "消息触发器",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -1232,
        352
      ],
      "webhookId": "[WEBHOOK_ID_REMOVED]",
      "parameters": {
        "updates": [
          "message"
        ],
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "[CREDENTIAL_ID_REMOVED]",
          "name": "Telegram Bot Account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "dcd295a9-1f02-40e3-8cdc-ecba77eb5a86",
      "name": "文件验证",
      "type": "n8n-nodes-base.if",
      "position": [
        -944,
        352
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "ff01b24f-92a6-4e95-9349-5f78a7ff1e74",
              "operator": {
                "type": "boolean",
                "operation": "true",
                "singleValue": true
              },
              "leftValue": "={{ $json.message.document.mime_type === 'application/pdf' }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "ab833633-da0d-4977-ab62-329b94a9a6eb",
      "name": "下载简历文件",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -624,
        256
      ],
      "parameters": {
        "url": "=https://api.telegram.org/bot[YOUR_BOT_TOKEN]/getFile?file_id={{ $json.message.document.file_id }}",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "a4d42d7f-dcc8-4fc0-8ffd-e8113d7b74b7",
      "name": "下载实际文件",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -384,
        256
      ],
      "parameters": {
        "url": "=https://api.telegram.org/file/bot[YOUR_BOT_TOKEN]/{{ $json.result.file_path }}",
        "options": {}
      },
      "typeVersion": 4.2
    },
    {
      "id": "bfc4232c-670f-4f0b-95a6-ae980cdc1f00",
      "name": "Google Gemini 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        192,
        496
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "googlePalmApi": {
          "id": "[CREDENTIAL_ID_REMOVED]",
          "name": "Google Gemini API Account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e91d4847-c1f0-4600-94d1-2ff61da3e68f",
      "name": "提取简历内容",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        0,
        256
      ],
      "parameters": {
        "options": {},
        "operation": "pdf"
      },
      "typeVersion": 1
    },
    {
      "id": "84a28f1c-27f5-4aa1-9f71-1c3464e213d2",
      "name": "简历资格审核代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        192,
        256
      ],
      "parameters": {
        "text": "=You are an expert HR assistant specializing in CV analysis and candidate qualification.From {{ $json.text }} Your task is to extract key information from CV content and categorize candidates based on their experience level.\nInstructions:\nAnalyze the provided CV text and extract the following information with high accuracy:\n\nFull Name: Extract the candidate's complete name (first and last name)\nPhone Number: Find and format phone numbers (include country code if available without + )\nEmail Address: Extract the primary email address\nJob Title: Identify the current or most recent job title/position\nExperience Analysis: Calculate total years of professional experience and categorize\n\nExperience Categorization Rules:\n\nJunior: 0-3 years of professional experience\nSenior: 3-6 years of professional experience\nExpert: 6+ years of professional experience\n\nExperience Calculation Guidelines:\n\nCount only professional work experience (internships count as 0.5x)\nCalculate total duration from all positions\nIf less than 12 months, express in months\nIf 12+ months, express in years (round to 1 decimal place)\nOverlapping positions should not be double-counted\nConsider career gaps but focus on actual work experience\n\n\nOutput Format:\nReturn ONLY a valid JSON object in this exact format:\n\n{\n  \"name\": \"Full Name Here\",\n  \"phone_number\": \"+1234567890 or Not Found\",\n  \"email\": \"email@example.com or Not Found\",\n  \"job_title\": \"Current/Recent Job Title or Not Found\",\n  \"experience\": [\"Category: X.X years\"]\n}",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 2.1
    },
    {
      "id": "b4721c8b-26b4-4d16-a028-4bba586de195",
      "name": "PDF 请求",
      "type": "n8n-nodes-base.telegram",
      "position": [
        -928,
        688
      ],
      "webhookId": "[WEBHOOK_ID_REMOVED]",
      "parameters": {
        "text": "Please send your CV in PDF format only",
        "chatId": "={{ $json.message.chat.id }}",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "[CREDENTIAL_ID_REMOVED]",
          "name": "Telegram Bot Account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "299bf1d9-da18-422b-86fc-88e3ced3a966",
      "name": "存储简历",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        0,
        0
      ],
      "parameters": {
        "name": "={{ $('Message Trigger').item.json.message.document.file_name }}",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "[YOUR_FOLDER_ID]",
          "cachedResultUrl": "https://drive.google.com/drive/folders/[YOUR_FOLDER_ID]",
          "cachedResultName": "HR-CVs"
        }
      },
      "credentials": {
        "googleDriveOAuth2Api": {
          "id": "[CREDENTIAL_ID_REMOVED]",
          "name": "Google Drive Account"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "9a11470f-8693-4305-a747-589e10883227",
      "name": "合并",
      "type": "n8n-nodes-base.merge",
      "position": [
        0,
        544
      ],
      "parameters": {
        "mode": "chooseBranch",
        "useDataOfInput": 2
      },
      "typeVersion": 3.2
    },
    {
      "id": "d1e8219e-1a93-4d2b-9b95-2788c46f20b8",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1280,
        272
      ],
      "parameters": {
        "color": 3,
        "width": 192,
        "height": 224,
        "content": "捕获来自候选人的传入简历 PDF"
      },
      "typeVersion": 1
    },
    {
      "id": "f54b90e6-6f6e-47cb-ba08-5bb30a19c56b",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -992,
        272
      ],
      "parameters": {
        "color": 4,
        "width": 192,
        "height": 224,
        "content": "过滤掉非 PDF 提交"
      },
      "typeVersion": 1
    },
    {
      "id": "8a4f5f7e-4629-442d-a615-ec316dab9107",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        176
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 208,
        "content": "从 Telegram 获取文件下载链接"
      },
      "typeVersion": 1
    },
    {
      "id": "dbffccb2-9d00-41ca-b72a-77552d4bef79",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -432,
        176
      ],
      "parameters": {
        "color": 4,
        "width": 192,
        "height": 208,
        "content": "下载实际的 PDF 文件"
      },
      "typeVersion": 1
    },
    {
      "id": "cda722d0-a7c3-4ced-bb09-158eea9007d3",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -960,
        576
      ],
      "parameters": {
        "color": 5,
        "width": 176,
        "height": 256,
        "content": "如果验证失败,发送消息要求用户重新以 PDF 格式发送简历。"
      },
      "typeVersion": 1
    },
    {
      "id": "83aad1ce-0738-483d-a0df-9d04324d26cf",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        -64
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 208,
        "content": "将下载的 PDF 文件上传到 Google Drive。"
      },
      "typeVersion": 1
    },
    {
      "id": "7d5e134a-cc84-43b0-9e43-f258e1cc28b3",
      "name": "便签 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        448
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 240,
        "content": "合并文件存储和下载路径,将数据传递到提取步骤。"
      },
      "typeVersion": 1
    },
    {
      "id": "8cf9d727-a25c-48e9-a65f-e621c0ea7ff2",
      "name": "便签7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        192
      ],
      "parameters": {
        "color": 4,
        "width": 176,
        "height": 224,
        "content": "从上传的 PDF 文件中提取文本内容进行分析。"
      },
      "typeVersion": 1
    },
    {
      "id": "dc51feca-11d5-4f83-8b50-82d45929d2d1",
      "name": "便签8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        208,
        160
      ],
      "parameters": {
        "color": 6,
        "height": 240,
        "content": "分析简历文本并提取结构化数据,如姓名、电话号码、邮箱、经验和工作职位。"
      },
      "typeVersion": 1
    },
    {
      "id": "b9cfbd21-df7c-4d25-ad4a-c02c1ff3e533",
      "name": "便签 9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        160
      ],
      "parameters": {
        "color": 5,
        "width": 192,
        "height": 256,
        "content": "清理并将结构化的 JSON AI 输出映射到各个字段,以便在 Google Sheets 中使用"
      },
      "typeVersion": 1
    },
    {
      "id": "59bbda91-ff07-437d-a384-1e513faeaa3a",
      "name": "便签10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        144
      ],
      "parameters": {
        "color": 4,
        "width": 224,
        "height": 272,
        "content": "将提取的候选人信息和简历链接保存到 Google Sheet,如有需要则更新现有条目。"
      },
      "typeVersion": 1
    },
    {
      "id": "ad464c7a-8b69-47ad-9b9f-8ba57af6d728",
      "name": "清理和映射提取的数据",
      "type": "n8n-nodes-base.set",
      "position": [
        608,
        256
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "91323867-f4bf-4bcc-a696-6524795e082f",
              "name": "full name",
              "type": "string",
              "value": "={{ JSON.parse($json[\"output\"].replace(/```json|```/g, \"\").trim()).name }}\n"
            },
            {
              "id": "33d44685-8463-4730-8bb4-c1f006f6a466",
              "name": "phone number",
              "type": "string",
              "value": "={{ JSON.parse($json[\"output\"].replace(/```json|```/g, \"\").trim()).phone_number }}\n"
            },
            {
              "id": "915dec92-ad74-423a-a81e-30b027100eb1",
              "name": "experiene",
              "type": "string",
              "value": "={{ JSON.parse($json[\"output\"].replace(/```json|```/g, \"\").trim()).experience }}"
            },
            {
              "id": "5c7cbab9-8090-436e-962f-6626f6855393",
              "name": "job title",
              "type": "string",
              "value": "={{ JSON.parse($json[\"output\"].replace(/```json|```/g, \"\").trim()).job_title }}\n"
            },
            {
              "id": "27984293-5bcd-4b43-9316-95ae05200018",
              "name": "email",
              "type": "string",
              "value": "={{ JSON.parse($json[\"output\"].replace(/```json|```/g, \"\").trim()).email }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "f0c044fa-2d29-4db6-b723-a735f799aef7",
      "name": "保存候选人信息到表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        800,
        256
      ],
      "parameters": {
        "columns": {
          "value": {
            "CV": "=\"CV\": \"=https://drive.google.com/file/d/{{ $node['Store CV'].json.id }}/view\"",
            "Name": "={{ $json[\"full name\"] }}",
            "Email": "={{ $json.email }}",
            "Job Title": "={{ $json['job title'] }}",
            "Experience": "={{ $json.experiene }}",
            "Phone Number": "={{ $json[\"phone number\"] }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Experience",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Experience",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone Number",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Phone Number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CV",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CV",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Job Title",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Job Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_SPREADSHEET_ID]/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "[YOUR_SPREADSHEET_ID]",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/[YOUR_SPREADSHEET_ID]/edit",
          "cachedResultName": "HR CV Filter"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "[CREDENTIAL_ID_REMOVED]",
          "name": "Google Sheets Account"
        }
      },
      "typeVersion": 4.6
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "[VERSION_ID_REMOVED]",
  "connections": {
    "Merge": {
      "main": [
        [
          {
            "node": "Extract cv content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store CV": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "File Validation": {
      "main": [
        [
          {
            "node": "Download CV File",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "PDF Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Message Trigger": {
      "main": [
        [
          {
            "node": "File Validation",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download CV File": {
      "main": [
        [
          {
            "node": "Download Actual File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Qualify CV Agent": {
      "main": [
        [
          {
            "node": "Clean & Map Extracted Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract cv content": {
      "main": [
        [
          {
            "node": "Qualify CV Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download Actual File": {
      "main": [
        [
          {
            "node": "Store CV",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Google Gemini Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Qualify CV Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Clean & Map Extracted Data": {
      "main": [
        [
          {
            "node": "Save Candidate Info to Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 人力资源, AI 摘要总结

需要付费吗?

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

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

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

作者
Abdullah Alshiekh

Abdullah Alshiekh

@abdullah01

🚀 Automation pro building AI-powered workflows with n8n. 💼 Special focus on real use cases 🔧 Love clean, flexible, and business-ready automations.

外部链接
在 n8n.io 查看

分享此工作流