使用GPT-4、Airtable和Google Drive筛选和评估求职者
高级
这是一个HR, AI领域的自动化工作流，包含 22 个节点。主要使用 If, Set, Gmail, Merge, Airtable 等节点，结合人工智能技术实现智能自动化。 使用GPT-4、Airtable和Google Drive筛选和评估求职者
前置要求
- •Google 账号和 Gmail API 凭证
- •Airtable API Key
- •Google Drive API 凭证
- •OpenAI API Key
使用的节点 (22)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "d1786ab0d745a7498abf13a9c2cdabb1374c006e889b79eef64ce0386b8f8a41"
},
"nodes": [
{
"id": "4dcbc7a2-8df4-4da0-ade0-0cec3a3e434f",
"name": "搜索职位发布",
"type": "n8n-nodes-base.airtable",
"position": [
240,
-100
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appgVjZcaRP8BsKf0",
"cachedResultUrl": "https://airtable.com/appgVjZcaRP8BsKf0",
"cachedResultName": "HR Database"
},
"limit": 1,
"table": {
"__rl": true,
"mode": "list",
"value": "tblla4rBCW3BhPtRO",
"cachedResultUrl": "https://airtable.com/appgVjZcaRP8BsKf0/tblla4rBCW3BhPtRO",
"cachedResultName": "Job Posting"
},
"options": {},
"operation": "search",
"returnAll": false,
"filterByFormula": "=FIND(LOWER(\"{{ $('Candidate Application Form').item.json['Position Applied For'] }}\"), LOWER({Job Title})) > 0"
},
"credentials": {
"airtableTokenApi": {
"id": "r2IibdsQurA56LDa",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "20da52d2-e172-4861-9569-b3cdd5f489cc",
"name": "创建候选人",
"type": "n8n-nodes-base.airtable",
"position": [
1200,
120
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appgVjZcaRP8BsKf0",
"cachedResultUrl": "https://airtable.com/appgVjZcaRP8BsKf0",
"cachedResultName": "HR Database"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblQy83erGR5lQj5c",
"cachedResultUrl": "https://airtable.com/appgVjZcaRP8BsKf0/tblQy83erGR5lQj5c",
"cachedResultName": "Candidates"
},
"columns": {
"value": {
"Resume": "={{ $json.file_array }}",
"Full Name": "={{ $('Candidate Application Form').item.json['Full Name '] }}",
"Cover Letter": "={{ $('Candidate Application Form').item.json['Cover Letter'] }}",
"Date Applied": "={{ $now }}",
"Email Address": "={{ $('Candidate Application Form').item.json['Email Address'] }}",
"Relevant Skills": "={{ $('Candidate Application Form').item.json['Relevant Skills'] }}",
"Screening Notes": "={{ $json.output.screening_notes }}",
"Match Percentage": "={{ $json.output.match_percentage }}",
"Position Applied": "={{ $('Candidate Application Form').item.json['Position Applied For'] }}",
"Screening Status": "={{ $json.output.screening_status }}"
},
"schema": [
{
"id": "Candidate ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Candidate ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Full Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Full Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Position Applied",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Position Applied",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Relevant Skills",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Relevant Skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Cover Letter",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Cover Letter",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Resume",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Resume",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Screening Status",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Screening Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Match Percentage",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Match Percentage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Screening Notes",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Screening Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Applied",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Date Applied",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "test",
"type": "options",
"display": true,
"options": [
{
"name": "1",
"value": "1"
},
{
"name": "2",
"value": "2"
},
{
"name": "3",
"value": "3"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "test",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "r2IibdsQurA56LDa",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "c9f24379-d359-4dcf-b84a-d60b1d6a7dc3",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
520,
120
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "MGwGMKEkdcjzlYCw",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "909abe51-f13a-418b-b473-9049b07953fe",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
700,
120
],
"parameters": {
"jsonSchemaExample": "{\n \"screening_status\": \"Suitable\",\n \"match_percentage\": 88,\n \"screening_notes\": \"Detailed explanation of the assessment, including relevant skill matches, experience analysis, and justification for the screening status.\"\n}"
},
"typeVersion": 1.2
},
{
"id": "036f79d9-7d08-4b61-a5bd-b9dea26f929d",
"name": "候选人筛选 AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
520,
-100
],
"parameters": {
"text": "=Candidate Screening Information:\n\n///\nUser Side:\n\nPosition Applied: \n{{ $('Search Job Posting').item.json['Job Title'] }}\n\nRelevant Skills the Candidate Possesses:\n{{ $('Candidate Application Form').item.json['Relevant Skills'] }}\n\n\nCover Letter: \n{{ $('Candidate Application Form').item.json['Cover Letter'] }}\n\nResume Content: \n{{ $('Extract Resume PDF').item.json.text }}\n\n///\n\nEmployer Side:\n\nPosition Description: \n{{ $('Search Job Posting').item.json['Job Description'] }}\n\nSkills Required: \n{{ $('Search Job Posting').item.json['Required Skills'] }}\n\n///",
"options": {
"systemMessage": "=You are a Candidate Screening AI Agent responsible for assessing candidate suitability for specific job positions based on the provided information. \n\nObjective:\nEvaluate the candidate’s fit for the applied position by analyzing their relevant skills, cover letter, and resume content. Compare this information with the job description and required skills provided by the employer to determine suitability, a match percentage, and screening notes.\n\nInput Fields:\n\nUser Side:\n- Position applied: The job position the candidate applied for.\n- Relevant skills: A list of key skills the candidate possesses.\n- Cover letter: Candidate’s introduction, work experience, and key achievements.\n- Resume: Parsed text content extracted from the resume in plain text format.\n\nEmployer Side:\n- Position description: Detailed job description including responsibilities and expectations.\n- Skills required: A list of required skills for the position.\n\nOutput Fields:\n- Screening Status: One of the following options: \"Suitable\", \"Not Suitable\", \"Under Review\".\n- Match Percentage: A numerical score indicating the percentage of relevant skills matching the job requirements.\n- Screening Notes: A summary of the assessment, including strengths, areas for improvement, and justification for the screening status.\n\nInstructions:\n1. Extract and analyze relevant skills mentioned in the cover letter and resume content.\n2. Compare the extracted skills with the job requirements and skills required by the employer.\n3. Assign a Match Percentage based on the alignment of skills and experience.\n4. Determine the Screening Status based on the skill match and relevance of the candidate’s experience to the position.\n5. Provide comprehensive Screening Notes to justify the assigned status and percentage, highlighting strengths and areas for improvement."
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "feb35aa1-cd20-470c-90b3-7267f3c3c7b4",
"name": "为 Airtable 设置文件数组",
"type": "n8n-nodes-base.set",
"position": [
560,
560
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={\"file_array\":[\n {\n \"url\": \"{{ $('Upload File').item.json.webContentLink }}\",\n \"filename\": \"{{ $('Upload File').item.json.name }}\"\n }\n]\n}"
},
"typeVersion": 3.4
},
{
"id": "57c4180d-05e6-4a4b-af86-cc5c2e67b098",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
960,
120
],
"parameters": {
"mode": "combine",
"options": {},
"combineBy": "combineAll"
},
"typeVersion": 3.1
},
{
"id": "83de9df9-4ff6-4832-bc99-0ebc9c749c3e",
"name": "上传文件",
"type": "n8n-nodes-base.googleDrive",
"position": [
80,
560
],
"parameters": {
"name": "={{ $json.Resume.filename }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "13BuRkJofybsBlF77oqoS87A2qq4zD2aP",
"cachedResultUrl": "https://drive.google.com/drive/folders/13BuRkJofybsBlF77oqoS87A2qq4zD2aP",
"cachedResultName": "pdf dev"
},
"inputDataFieldName": "Resume"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "SEUhrgz30NMJS3cH",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "19c8ac22-6cd4-4ffb-9193-d9a2e1ce5ffc",
"name": "设置文件权限",
"type": "n8n-nodes-base.googleDrive",
"position": [
320,
560
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "share",
"permissionsUi": {
"permissionsValues": {
"role": "reader",
"type": "anyone"
}
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "SEUhrgz30NMJS3cH",
"name": "Google Drive account"
}
},
"typeVersion": 3
},
{
"id": "fe28d107-0b25-4218-af94-f4937aa91035",
"name": "检查候选人是否合适",
"type": "n8n-nodes-base.if",
"position": [
1400,
120
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "ab5102cf-0952-465e-9340-59ced9f39ce1",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Merge').item.json.output.screening_status }}",
"rightValue": "Suitable"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "379b61c4-89f8-447f-b9ac-b0d3aa56dc38",
"name": "发送邮件给 HR",
"type": "n8n-nodes-base.gmail",
"position": [
1680,
120
],
"webhookId": "48fa841c-0312-4829-a80c-85cd37deec25",
"parameters": {
"sendTo": "hr_team_n8n@yopmail.com",
"message": "=We have successfully completed the candidate screening process, and {{ $('Candidate Application Form').item.json['Full Name '] }} has been identified as a suitable candidate for the {{ $('Search Job Posting').item.json['Job Title'] }} position. \n\nCandidate Details: \n- Position Applied: {{ $('Search Job Posting').item.json['Job Title'] }} \n- Match Percentage: {{ $('Candidate Screener AI Agent').item.json.output.match_percentage }}% \n- Screening Notes: {{ $('Candidate Screener AI Agent').item.json.output.screening_notes }}\n\nPlease proceed with the next steps in the interview scheduling process. If you need any further information or clarification, feel free to reach out. \n\nThank you, \nSuper Awesome HR AI Agent",
"options": {
"appendAttribution": false
},
"subject": "=Candidate {{ $('Candidate Application Form').item.json['Full Name '] }} - Suitable for {{ $('Search Job Posting').item.json['Job Title'] }}\n",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "sWl7FFMkEUYBj0zM",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "a7bb9cf2-5df0-4937-b17a-271c60157da0",
"name": "候选人申请表",
"type": "n8n-nodes-base.formTrigger",
"position": [
-400,
-100
],
"webhookId": "2d4004d0-4c93-49d5-9c3a-4e05264fc772",
"parameters": {
"options": {},
"formTitle": "Smart Candidate Screening Form",
"formFields": {
"values": [
{
"fieldLabel": "Full Name ",
"requiredField": true
},
{
"fieldType": "email",
"fieldLabel": "Email Address",
"requiredField": true
},
{
"fieldLabel": "Position Applied For",
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Relevant Skills",
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Cover Letter",
"requiredField": true
},
{
"fieldType": "file",
"fieldLabel": "Resume",
"multipleFiles": false,
"acceptFileTypes": ".pdf"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7531bc26-0c23-4a3e-8739-e90379879c08",
"name": "提取简历 PDF",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-80,
-100
],
"parameters": {
"options": {},
"operation": "pdf",
"binaryPropertyName": "Resume"
},
"typeVersion": 1
},
{
"id": "a014c89d-db01-435f-957d-830fb4ae94b4",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-380
],
"parameters": {
"color": 4,
"width": 360,
"height": 680,
"content": "🧠 候选人筛选 AI 代理"
},
"typeVersion": 1
},
{
"id": "1505d7cf-0a7e-4794-980e-a08be353810f",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
-240
],
"parameters": {
"color": 4,
"width": 340,
"height": 300,
"content": "## 搜索职位发布（职位匹配）"
},
"typeVersion": 1
},
{
"id": "e76d4408-42b4-4757-a26e-59b5844e123b",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
360
],
"parameters": {
"color": 4,
"width": 760,
"height": 340,
"content": "## Airtable 上传文件准备"
},
"typeVersion": 1
},
{
"id": "6ff2294a-95dd-46ba-a19e-7855ef78c669",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
-40
],
"parameters": {
"color": 4,
"width": 420,
"height": 380,
"content": "## 合并并创建候选人"
},
"typeVersion": 1
},
{
"id": "13bcc44a-55e6-46ce-8eeb-1e1241e8569f",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1380,
-80
],
"parameters": {
"color": 4,
"width": 420,
"height": 420,
"content": "## 检查候选人并向 HR 发送邮件"
},
"typeVersion": 1
},
{
"id": "1fe8867b-b2a9-4ff0-813a-9e147c16cb2b",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-400
],
"parameters": {
"color": 4,
"width": 560,
"height": 580,
"content": "## 候选人申请表"
},
"typeVersion": 1
},
{
"id": "9147da55-77dc-4780-83cd-2c6969574fb3",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
-400
],
"parameters": {
"color": 4,
"width": 280,
"height": 280,
"content": "## 必需设置"
},
"typeVersion": 1
},
{
"id": "b0c1aba2-4b2a-4ba6-b625-9bb6d2af4356",
"name": "便签 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1120,
320
],
"parameters": {
"color": 5,
"width": 460,
"height": 460,
"content": "## 🤖 基于 AI 的候选人筛选评估工作流（使用 OpenAI 和 Airtable）"
},
"typeVersion": 1
},
{
"id": "53fbb743-892a-45dc-9dc7-9596fda47686",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
320
],
"parameters": {
"color": 5,
"width": 500,
"height": 460,
"content": "## 📋 工作流流程概览"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Create Candidate",
"type": "main",
"index": 0
}
]
]
},
"Upload File": {
"main": [
[
{
"node": "Set File Permission",
"type": "main",
"index": 0
}
]
]
},
"Create Candidate": {
"main": [
[
{
"node": "Check if candidate is suitable",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Candidate Screener AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Extract Resume PDF": {
"main": [
[
{
"node": "Search Job Posting",
"type": "main",
"index": 0
}
]
]
},
"Search Job Posting": {
"main": [
[
{
"node": "Candidate Screener AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Set File Permission": {
"main": [
[
{
"node": "Set File Array for airtable",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Candidate Screener AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Candidate Application Form": {
"main": [
[
{
"node": "Extract Resume PDF",
"type": "main",
"index": 0
},
{
"node": "Upload File",
"type": "main",
"index": 0
}
]
]
},
"Candidate Screener AI Agent": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Set File Array for airtable": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Check if candidate is suitable": {
"main": [
[
{
"node": "Send email to HR",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人力资源, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动化PDF发票处理与审批流程，使用OpenAI和Google表格
自动化PDF发票处理与审批流程，使用OpenAI和Google表格
If
Gmail
Form Trigger
+9
17 节点Billy Christi
财务
使用AI进行HR职位发布和评估
使用AI的人力资源职位发布和评估系统
If
Set
Form
+12
36 节点Francis Njenga
人力资源
使用AI、ElevenLabs、PIAPI Shotstack/Creatomate生成视频并发布到YouTube
使用AI、ElevenLabs、PIAPI Shotstack/Creatomate生成视频并发布到YouTube
If
Set
Code
+16
79 节点Immanuel
人工智能
面向人力资源的 AI 自动化流程
简历分析与候选人评估
Set
Merge
Form Trigger
+9
18 节点Davide
人力资源
AI驱动的RAG文档处理与聊天机器人 - Google Drive、Supabase、OpenAI
基于Google Drive、Supabase和OpenAI的AI驱动RAG文档处理与聊天机器人
Set
Code
Limit
+19
35 节点Billy Christi
人工智能
使用OpenAI + Google表格的自动化简历审核系统
使用OpenAI + Google表格的自动化简历审核系统
Set
Merge
Form Trigger
+9
17 节点Mirza Ajmal
人力资源
工作流信息
难度等级
高级
节点数量22
分类2
节点类型12
作者
Billy Christi
@billyI'm a professional software engineer and n8n expert with a passion for building scalable, no-code and low-code automation workflows. I specialize in creating seamless integrations between APIs, CRMs, and everyday tools to help businesses save time, reduce manual work, and operate smarter. Whether it's automating marketing pipelines, backend systems, or approval processes, I turn complex logic into simple, powerful workflows with n8n.
外部链接
在 n8n.io 查看 →
分享此工作流