应聘者追踪自动化
中级
这是一个Content Creation、Multimodal AI领域的自动化工作流，包含 13 个节点。主要使用 If、Code、Gmail、FormTrigger、GoogleSheets 等节点。 使用GPT-4.1简历解析、Google表格和Gmail提醒实现应聘者追踪自动化
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "cb5caf45c9475b848c7e83772505bb02340e165acdd8de77e25011192306257c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "c30700f0-60c1-4c18-bd05-93d28ae09c42",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-1552,
208
],
"parameters": {
"jsCode": "// Binary data'nın gerçek yapısını görmek için\nconsole.log(\"JSON Keys:\", Object.keys($input.first().json));\nconsole.log(\"Binary Keys:\", Object.keys($input.first().binary || {}));\nconsole.log(\"Full Binary:\", $input.first().binary);\n\nreturn $input.all();"
},
"typeVersion": 2
},
{
"id": "a61166c0-b977-4482-bb70-f36c022613a1",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
0,
0
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3b700a92-f90e-458e-a17f-942d483cff5f",
"name": "1. 申请人提交表单",
"type": "n8n-nodes-base.formTrigger",
"position": [
-1760,
208
],
"webhookId": "e92eb47d-5fd9-4055-bd89-6eeff65a00b7",
"parameters": {
"options": {},
"formTitle": "test",
"formFields": {
"values": [
{
"fieldLabel": "Name surname",
"requiredField": true
},
{
"fieldLabel": "email",
"requiredField": true
},
{
"fieldType": "file",
"fieldLabel": "CV",
"multipleFiles": false,
"requiredField": true,
"acceptFileTypes": ".pdf"
},
{
"fieldType": "number",
"fieldLabel": "Experience Years",
"requiredField": true
}
]
}
},
"typeVersion": 2.3,
"alwaysOutputData": true
},
{
"id": "bf5e61be-2934-4b99-aaf0-6c264a0b55b7",
"name": "2. 从 PDF 简历提取文本",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-1360,
208
],
"parameters": {
"options": {},
"operation": "pdf",
"binaryPropertyName": "CV"
},
"typeVersion": 1
},
{
"id": "4d93769b-1807-4b42-af08-b86cf92f30de",
"name": "3. 使用 AI 分析和结构化简历",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-1120,
208
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=FORM DATA:\n- Name: {{ $node[\"On form submission1\"].json[\"Name surname\"] }}\n- Email: {{ $node[\"On form submission1\"].json[\"email\"] }}\n- Experience Years: {{ $node[\"On form submission1\"].json[\"Experience Years\"] }}\n\nCV TEXT:\n{{ $json.text }}\n\nExtract the data into the following JSON format for Google Sheets:\n{\n \"name\": \"use_name_from_form\",\n \"email\": \"use_email_from_form\",\n \"phone\": \"phone_extracted_from_cv\",\n \"experience_years\": \"use_experience_years_from_form\",\n \"education\": \"All education as a single string - school, degree, year\",\n \"work_experience\": \"All work experience as a single string - company, position, duration\",\n \"skills\": \"All skills, comma-separated\",\n \"certifications\": \"All certifications, comma-separated\",\n \"languages\": \"Languages and their proficiency levels\",\n \"address\": \"address_extracted_from_cv\",\n \"cv_summary\": \"A 10-sentence summary of the CV for an HR manager\",\n \"application_date\": \"{{ new Date().toLocaleDateString('en-US') }}\",\n \"status\": \"New Application\"\n}\n\nIMPORTANT: Respond ONLY in the valid JSON format. Do not add any other text or explanations."
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "7ZvT0NzDJ8AjFf1B",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "14a1c88a-20cc-46b5-a9d3-1c26c6a230e2",
"name": "4. 解析 AI 输出",
"type": "n8n-nodes-base.code",
"position": [
-752,
208
],
"parameters": {
"jsCode": "// content zaten object, parse etmeye gerek yok\nconst data = items[0].json.message.content;\n\nreturn [{ json: data }];"
},
"typeVersion": 2
},
{
"id": "d1bff2d5-b644-441b-b76d-7b41dda8800f",
"name": "5. 检查重复申请人",
"type": "n8n-nodes-base.googleSheets",
"position": [
-512,
208
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $node[\"4. Parse AI Output\"].json.email }}",
"lookupColumn": "email"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UvFYOE5C47Q8eQpGq0fLmxHwRjXpZTzssQiv7mOsC1E/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1UvFYOE5C47Q8eQpGq0fLmxHwRjXpZTzssQiv7mOsC1E/edit?gid=0#gid=0"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "df8r9D022KIAOHTC",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "4bce4857-f0b0-4ac9-b11b-d57f41d7c72c",
"name": "6. 如果申请人是新用户...",
"type": "n8n-nodes-base.if",
"position": [
-240,
208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3009324b-7124-488e-931d-37221b4b57f9",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b4320ad6-1d8c-491d-b7fa-78734aa6ff36",
"name": "7. 将申请人数据保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
16,
368
],
"parameters": {
"columns": {
"value": {
"email": "={{ $node[\"4. Parse AI Output\"].json.email }}",
"status": "= {{ $node[\"4. Parse AI Output\"].json.status }}",
"address": "={{ $node[\"4. Parse AI Output\"].json.address }}",
"talents": "={{ $node[\"4. Parse AI Output\"].json.skills }}",
"education": "={{ $node[\"4. Parse AI Output\"].json.education }}",
"languages": "={{ $node[\"4. Parse AI Output\"].json.languages }}",
"telephone": "={{ $node[\"4. Parse AI Output\"].json.phone }}",
"cv_summary": "={{ $node[\"4. Parse AI Output\"].json.cv_summary }}",
"experience": "={{ $node[\"4. Parse AI Output\"].json.work_experience }}",
"certificates": "={{ $node[\"4. Parse AI Output\"].json.certifications }}",
"name surname": "={{ $node[\"4. Parse AI Output\"].json.name }}",
"application_date": "={{ $node[\"4. Parse AI Output\"].json.application_date }}",
"experience_years": "={{ $node[\"4. Parse AI Output\"].json.experience_years }}"
},
"schema": [
{
"id": "name surname",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name surname",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "telephone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "telephone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "experience_years",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "experience_years",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "education",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "education",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "experience",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "experience",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "talents",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "talents",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "certificates",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "certificates",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "languages",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "languages",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "cv_summary",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "cv_summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "application_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "application_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "index",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "index",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "message",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "message",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "logprobs",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "logprobs",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "finish_reason",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "finish_reason",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UvFYOE5C47Q8eQpGq0fLmxHwRjXpZTzssQiv7mOsC1E/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1UvFYOE5C47Q8eQpGq0fLmxHwRjXpZTzssQiv7mOsC1E/edit?gid=0#gid=0"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "df8r9D022KIAOHTC",
"name": "Google Sheets account"
}
},
"typeVersion": 4.7
},
{
"id": "fb6b0443-dfda-4bc6-a1d7-f86ce2df4ada",
"name": "8a. 向申请人发送确认邮件",
"type": "n8n-nodes-base.gmail",
"position": [
368,
208
],
"webhookId": "c7bed720-0890-42ca-a2d1-e5a80e931250",
"parameters": {
"sendTo": "={{ $node[\"4. Parse AI Output\"].json.email }}",
"message": "=Dear {{ $node[\"4. Parse AI Output\"].json.name }},\n\nYour application has been received successfully.\n\nHere are your application details:\n- Email: {{ $node[\"4. Parse AI Output\"].json.email }}\n- Experience: {{ $node[\"4. Parse AI Output\"].json.experience_years }} years\n- Application Date: {{ $node[\"4. Parse AI Output\"].json.application_date }}\n\nWe will review your application and get back to you shortly.\n\nThank you.",
"options": {},
"subject": "Your Application Has Been Received"
},
"typeVersion": 2.1
},
{
"id": "1177788a-8ce6-40b1-8e71-5825afefb22e",
"name": "8b. 向招聘人员发送通知邮件",
"type": "n8n-nodes-base.gmail",
"position": [
368,
512
],
"webhookId": "38206975-448a-4964-a917-e03e2445356c",
"parameters": {
"sendTo": "bsezi1409@gmail.com",
"message": "=A new CV application has been received:\n\nName: {{ $node[\"4. Parse AI Output\"].json.name }}\nEmail: {{ $node[\"4. Parse AI Output\"].json.email }}\nExperience: {{ $node[\"4. Parse AI Output\"].json.experience_years }} years\n\nAI-Generated CV Summary:\n{{ $node[\"4. Parse AI Output\"].json.cv_summary }}\n\nThe applicant's data has been saved to Google Sheets.",
"options": {},
"subject": "=New Application - {{ $node[\"4. Parse AI Output\"].json.name }}"
},
"typeVersion": 2.1
},
{
"id": "0fa496ba-afdb-4290-a6cb-cf15cacae9e2",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2384,
16
],
"parameters": {
"width": 544,
"height": 512,
"content": "# AI 驱动的申请人跟踪系统 (ATS)"
},
"typeVersion": 1
},
{
"id": "f3165533-3506-48b3-9524-496252336362",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1424,
-80
],
"parameters": {
"color": 3,
"width": 752,
"height": 240,
"content": "### 阶段 1：AI 简历解析引擎"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Code": {
"main": [
[
{
"node": "2. Extract Text from PDF CV",
"type": "main",
"index": 0
}
]
]
},
"4. Parse AI Output": {
"main": [
[
{
"node": "5. Check for Duplicate Applicant",
"type": "main",
"index": 0
}
]
]
},
"1. Applicant Submits Form": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"6. If Applicant is New...": {
"main": [
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
],
[
{
"node": "7. Save Applicant Data to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"2. Extract Text from PDF CV": {
"main": [
[
{
"node": "3. Analyze & Structure CV with AI",
"type": "main",
"index": 0
}
]
]
},
"5. Check for Duplicate Applicant": {
"main": [
[
{
"node": "6. If Applicant is New...",
"type": "main",
"index": 0
}
]
]
},
"3. Analyze & Structure CV with AI": {
"main": [
[
{
"node": "4. Parse AI Output",
"type": "main",
"index": 0
}
]
]
},
"7. Save Applicant Data to Google Sheets": {
"main": [
[
{
"node": "8a. Send Confirmation Email to Applicant",
"type": "main",
"index": 0
},
{
"node": "8b. Send Notification Email to Recruiter",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个中级难度的工作流，适用于Content Creation、Multimodal AI等场景。适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
预订自动化模板
使用GPT-5和Gmail上下文分析生成个性化音乐推广邮件
If
Code
Gmail
+12
27 节点Václav Čikl
Content Creation
HR候选人解析与评估 - 使用GPT-4.1和LinkedIn数据的CSV/XLSX
HR候选人解析与评估 - 使用GPT-4.1和LinkedIn数据的CSV/XLSX
Set
Code
Gmail
+15
33 节点Elay Guez
Content Creation
通过 OpenAI GPT-4o 进行 AI 内容生成，包含人工审核与一键批准工作流
使用GPT-4o简化内容创建，集成一键人工审核批准
If
Set
Code
+8
23 节点Cheng Siong Chin
Content Creation
LinkedIn潜在客户信息丰富与AI个性化冷外联
LinkedIn潜在客户信息丰富与个性化冷外联，集成Hunter.io、GPT-4和Sheets
If
Set
Code
+7
18 节点Amirul Hakimi
Content Creation
使用 Dumpling AI 和 GPT-4 根据关键词生成博客文章
使用 Dumpling AI 和 GPT-4 根据关键词研究并生成博客文章到 WordPress
If
Code
Gmail
+6
9 节点Yang
Content Creation
使用 Azure OpenAI 和 Google Workspace 自动化 DEI 资格筛选
使用Azure GPT-4o、Google云端硬盘和表格自动进行DEI资格筛选
If
Code
Gmail
+9
19 节点Rahul Joshi
Content Creation
工作流信息
难度等级
中级
节点数量13
分类2
节点类型9
作者
Onur
@onurpolat05Hello, I'm Onur I've been working as a freelance software developer for about four years. In addition, I develop my own projects. For some time, I have been improving myself and providing various services related to AI and AI workflows. Both by writing low code and code. If you have any questions, don't hesitate to contact me.
外部链接
在 n8n.io 上查看 →
分享此工作流