候选人问卷分析
高级
这是一个Miscellaneous, AI Summarization, Multimodal AI领域的自动化工作流，包含 16 个节点。主要使用 Set, Code, GoogleSheets, Agent, GoogleSheetsTrigger 等节点。 使用Azure GPT-4o-mini和Google Sheets评估面试并更新分数
前置要求
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ncJgeZeVdsws0GpM",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "候选人问卷分析",
"tags": [],
"nodes": [
{
"id": "5745071e-e64f-44ab-a972-65a3b7ef2a06",
"name": "监控新问卷回复",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-80,
816
],
"parameters": {
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 3745099,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SFFWWqefQ6tcaEK0_Ovy9nVgyxS4LQPvno1i8fi39MY/edit#gid=3745099",
"cachedResultName": "Form Responses 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1SFFWWqefQ6tcaEK0_Ovy9nVgyxS4LQPvno1i8fi39MY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SFFWWqefQ6tcaEK0_Ovy9nVgyxS4LQPvno1i8fi39MY/edit?usp=drivesdk",
"cachedResultName": "BD Questionarie"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "tjY8nawuuRO1rxAE",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "cb360f3e-257f-49d8-930a-b3d31841edbe",
"name": "AI问卷评估器",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
144,
816
],
"parameters": {
"text": "=Role:\nQuestions and Candidate Answers:\nQ1: What is Business development according to you\nA1: {{ $json[\"What is BD according to you?\"] }}\nQ2: What is SWOT analysis\nA2: {{ $json[\"What is SWOT analysis\"] }}\n\nPlease evaluate the above responses based on knowledge depth, problem-solving ability, and communication clarity.",
"options": {
"systemMessage": "=You are an AI evaluator for candidate screening. \nYou will be given:\n- A set of role-specific questions.\n- A candidate's answers.\n\nYour job:\n1. Evaluate the quality of the answers against the intent of each question.\n2. Score the questionnaire (0–30 by default, or adjust scale if specified).\n3. Provide key takeaways (strengths, weaknesses, red flags, or standout qualities).\n\nOutput ONLY in JSON with this structure:\n{\n \"questionnaire_score\": <number>,\n \"key_takeaways\": \"<summary of candidate performance>\"\n}"
},
"promptType": "define"
},
"typeVersion": 2.1
},
{
"id": "ed9b6126-dadf-4bd6-851f-dbe3e421434e",
"name": "Azure OpenAI GPT-4模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
240,
1040
],
"parameters": {
"model": "gpt-4o-mini",
"options": {}
},
"credentials": {
"azureOpenAiApi": {
"id": "C3WzT18XqF8OdVM6",
"name": "Azure Open AI account"
}
},
"typeVersion": 1
},
{
"id": "3817a7af-23d1-445d-abc3-b68556ff5ec4",
"name": "查找候选人档案数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
768,
816
],
"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": "5cd8411b-1851-46e5-833b-2723d14dd509",
"name": "解析AI评估结果",
"type": "n8n-nodes-base.code",
"position": [
544,
816
],
"parameters": {
"jsCode": "return items.map(item => {\n let text = item.json.output;\n\n // Remove code fences like ```json ... ```\n text = text.replace(/```json|```/g, \"\").trim();\n\n let parsed = {};\n try {\n parsed = JSON.parse(text);\n } catch (err) {\n parsed = { error: \"Failed to parse JSON\", raw: text };\n }\n\n return { json: parsed };\n});"
},
"typeVersion": 2
},
{
"id": "abfe1e72-3291-4bfe-ab80-8b9339ea0aa9",
"name": "计算综合分数",
"type": "n8n-nodes-base.set",
"position": [
992,
816
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "1fb84fd6-db3f-432d-baee-2e3e2cfd404a",
"name": "=final score",
"type": "number",
"value": "={{ $json.Score + $('Parse AI Evaluation Results').item.json.questionnaire_score }}\n\n"
},
{
"id": "d257e53b-6887-4cdc-8f50-f90715312b81",
"name": "Questionarie Score",
"type": "string",
"value": "={{ $('Parse AI Evaluation Results').item.json.questionnaire_score }}"
}
]
}
},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "895de667-d515-4331-a2be-e3079af6b468",
"name": "更新候选人数据库",
"type": "n8n-nodes-base.googleSheets",
"position": [
1216,
816
],
"parameters": {
"columns": {
"value": {
"Name": "John Doe",
"Final score": "={{ $json[\"final score\"] }}",
"Questionarie Score": "={{ $json[\"Questionarie Score\"] }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone ",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Phone ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Years of experience",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Years of experience",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "skills",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "skills",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "curent role",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "curent role",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "education",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "education",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Questionarie Score",
"type": "string",
"display": true,
"required": false,
"displayName": "Questionarie Score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Final score",
"type": "string",
"display": true,
"required": false,
"displayName": "Final score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Summary",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skill name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skill name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skill level",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skill level",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skill years",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Skill years",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"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": "60456c78-e211-4bfe-852d-81467d3d5fda",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-448,
512
],
"parameters": {
"width": 320,
"height": 352,
"content": "## 🔔 自动触发器"
},
"typeVersion": 1
},
{
"id": "eb5a2306-50c1-4222-9778-8dbd51546ae8",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
96,
368
],
"parameters": {
"width": 320,
"height": 420,
"content": "## 🤖 AI评估引擎"
},
"typeVersion": 1
},
{
"id": "29578b3f-a8ff-42d9-9b30-61821ad9a807",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-128,
1088
],
"parameters": {
"width": 320,
"height": 280,
"content": "## ⚙️ AI模型配置"
},
"typeVersion": 1
},
{
"id": "2f0e9fba-d447-4951-ac95-7b71ed965e7a",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
400
],
"parameters": {
"width": 320,
"height": 340,
"content": "## 🔧 数据处理"
},
"typeVersion": 1
},
{
"id": "2ba1d0f1-4531-4b09-8283-df69a1425360",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
656,
992
],
"parameters": {
"width": 320,
"height": 352,
"content": "## 📊 数据检索"
},
"typeVersion": 1
},
{
"id": "512b6d1c-c678-4d9f-9b12-0243b2b44dc0",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
384
],
"parameters": {
"width": 320,
"height": 372,
"content": "## 🧮 分数计算"
},
"typeVersion": 1
},
{
"id": "605aa0a9-3b28-4251-b55a-a0d5d6b8e074",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1200,
1008
],
"parameters": {
"width": 320,
"height": 360,
"content": "## 💾 数据库更新"
},
"typeVersion": 1
},
{
"id": "2bd8f006-8113-4ed2-a56a-1973f6a8ecec",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-976,
704
],
"parameters": {
"width": 480,
"height": 620,
"content": "## 📝 候选人问卷分析工作流"
},
"typeVersion": 1
},
{
"id": "5dceeae5-f433-42ae-9a42-8d8491133104",
"name": "便签 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1616,
640
],
"parameters": {
"width": 380,
"height": 520,
"content": "## ⚙️ 配置与自定义"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "17c11c31-64d6-417f-b01d-863e13dd207f",
"connections": {
"Azure OpenAI GPT-4 Model": {
"ai_languageModel": [
[
{
"node": "AI Questionnaire Evaluator",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Calculate Combined Scores": {
"main": [
[
{
"node": "Update Candidate Database",
"type": "main",
"index": 0
}
]
]
},
"AI Questionnaire Evaluator": {
"main": [
[
{
"node": "Parse AI Evaluation Results",
"type": "main",
"index": 0
}
]
]
},
"Parse AI Evaluation Results": {
"main": [
[
{
"node": "Lookup Candidate Profile Data",
"type": "main",
"index": 0
}
]
]
},
"Lookup Candidate Profile Data": {
"main": [
[
{
"node": "Calculate Combined Scores",
"type": "main",
"index": 0
}
]
]
},
"Monitor New Questionnaire Responses": {
"main": [
[
{
"node": "AI Questionnaire Evaluator",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 杂项, AI 摘要总结, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI 潜在客户资质判定
使用 Azure GPT-4o-mini 和 Google Sheets 进行 AI 评审分析的潜在客户资质判定
Code
Google Sheets
Agent
+3
10 节点Rahul Joshi
杂项
技能矩阵提取器
使用Google Drive和GPT-4o将技能矩阵提取至Google表格
Code
Google Drive
Google Sheets
+5
17 节点Rahul Joshi
杂项
反馈保存和报告生成
使用Azure OpenAI和Google Sheets分析销售交易结果并生成报告
Set
Code
Email Send
+6
28 节点Rahul Joshi
客户关系管理
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
自动化依赖更新跟踪
使用 GPT-4o、Slack、Jira 和 Google Sheets 进行依赖更新风险分析
If
Set
Code
+8
23 节点Rahul Joshi
开发运维
将服装图片上传到Cloudinary并使用Azure OpenAI (GPT-4o) 记录到工作表
使用GPT-4o、Cloudinary和Google Sheets处理和编目服装图片
Set
Code
Merge
+9
26 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量16
分类3
节点类型7
作者
Rahul Joshi
@rahul08Rahul 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 查看 →
分享此工作流