候选人评分（已提交）
中级
这是一个自动化工作流，包含 14 个节点。主要使用 If, Gmail, GoogleSheets, JotFormTrigger, Agent 等节点。 使用Jotform和Gemini AI自动化候选人分析与排名
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
分类
-
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "P6NgvqQqtFTVhQ09",
"meta": {
"instanceId": "7f1a0694161455be3a7e71f1e0dea04908b0376a1a81e3a0c1e5ac879d48f83a",
"templateCredsSetupCompleted": true
},
"name": "候选人评分（已提交）",
"tags": [],
"nodes": [
{
"id": "24307a82-75e4-4e51-b888-5be1e8dcf576",
"name": "JotForm 触发器",
"type": "n8n-nodes-base.jotFormTrigger",
"position": [
-1360,
288
],
"webhookId": "YOUR_GENERIC_WEBHOOK_ID",
"parameters": {
"form": "YOUR_JOTFORM_ID_HERE"
},
"credentials": {
"jotFormApi": {
"id": "lJxjts7RyK804JCB",
"name": "JotForm account"
}
},
"typeVersion": 1
},
{
"id": "e970b876-3ba7-4e01-8b24-bec20187e905",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-1088,
288
],
"parameters": {
"text": "=You are a UGC candidate evaluator for [Company Name] skincare campaigns.\n\nRead the candidate form data and calculate a score (0–10) based on these rules:\n+3 if has previous UGC/content experience\n+1 if lives in Helwan\n+1 if age 20–25\n+0.5 if 15–20\n+2 if no kids\n+1 if has child 0–2 years\n+1 if mentions liking or using XQ products\n+0.5 if skin is normal/dry/combination\n+0.5 if not sensitive\n\nReturn only the number — no text, no JSON, no explanation.\n\nCandidate data:\n{{ JSON.stringify($json, null, 2) }}\n",
"options": {},
"promptType": "define"
},
"typeVersion": 2.2
},
{
"id": "e48ba0bd-d476-492a-b215-2722997d3f19",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
-1136,
512
],
"parameters": {
"options": {
"temperature": 0.2
},
"modelName": "models/gemini-2.5-flash-lite"
},
"typeVersion": 1
},
{
"id": "7c9cdf5f-0712-4dad-8e87-3f13aefcaae9",
"name": "在表格中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-352,
160
],
"parameters": {
"columns": {
"value": {
"Age ": "={{ $('JotForm Trigger').item.json['Age From'] }}",
"Kids": "={{ $('JotForm Trigger').item.json['If you a Mother Please choose you child\\'s age '] }}",
"Email": "={{ $('JotForm Trigger').item.json.Email }}",
"Links": "={{ $('JotForm Trigger').item.json['Instagram / Tiktok Links'] }}",
"AI Rate": "={{ $json.output }}",
"Address": "={{ $('JotForm Trigger').item.json.Address }}",
"Work Exp": "={{ $('JotForm Trigger').item.json['Do you have previous similar work experience?'][0] }}",
"Skin Sens": "={{ $('JotForm Trigger').item.json['Is your skin sensitive or not?'] }}",
"Skin Type": "={{ $('JotForm Trigger').item.json['What is your skin type?'] }}",
"Phone Number": "={{ $('JotForm Trigger').item.json['Mobile Number '] }}",
"Candidate Name": "={{ $('JotForm Trigger').item.json['Your Name'] }}",
"التاريخ": "={{$now}}"
},
"schema": [
{
"id": "Candidate Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Candidate Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "التاريخ",
"type": "string",
"display": true,
"required": false,
"displayName": "التاريخ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone Number",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Address",
"type": "string",
"display": true,
"required": false,
"displayName": "Address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Links",
"type": "string",
"display": true,
"required": false,
"displayName": "Links",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skin Type",
"type": "string",
"display": true,
"required": false,
"displayName": "Skin Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Skin Sens",
"type": "string",
"display": true,
"required": false,
"displayName": "Skin Sens",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Age ",
"type": "string",
"display": true,
"required": false,
"displayName": "Age ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Kids",
"type": "string",
"display": true,
"required": false,
"displayName": "Kids",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "AI Rate",
"type": "string",
"display": true,
"required": false,
"displayName": "AI Rate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Work Exp",
"type": "string",
"display": true,
"required": false,
"displayName": "Work Exp",
"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/YOUR_GOOGLE_SHEET_DOCUMENT_ID/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_GOOGLE_SHEET_DOCUMENT_ID",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/YOUR_GOOGLE_SHEET_DOCUMENT_ID/edit?usp=drivesdk",
"cachedResultName": "XQ UGC"
}
},
"typeVersion": 4.7
},
{
"id": "218f82ef-22a9-4b1d-8ddf-d8eceec69f93",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-656,
288
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "ef502dfe-2c19-457e-be7e-b61b80d2324e",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.output }}",
"rightValue": 6
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "9f42af24-db42-4a66-8174-5cb3102e0924",
"name": "发送候选人入围名单邮件",
"type": "n8n-nodes-base.gmail",
"position": [
-32,
-64
],
"webhookId": "YOUR_GENERIC_WEBHOOK_ID_2",
"parameters": {
"sendTo": "={{ $json.Email }}",
"options": {}
},
"typeVersion": 2.1
},
{
"id": "6abfc3d9-2a0c-495c-b958-b710df7188b8",
"name": "通知HR入围名单",
"type": "n8n-nodes-base.gmail",
"position": [
-48,
240
],
"webhookId": "YOUR_GENERIC_WEBHOOK_ID_3",
"parameters": {
"sendTo": "Marketing@yourcompany.com",
"options": {}
},
"credentials": {
"gmailOAuth2": {
"id": "OVQrwg5oLZomwQcs",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "ad9c4f6f-1072-488e-b534-d634ced1a0e9",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1456,
208
],
"parameters": {
"color": 3,
"width": 256,
"height": 208,
"content": "在表单提交时启动工作流。它捕获所有候选人的资格和个人数据。"
},
"typeVersion": 1
},
{
"id": "e95fce78-dd45-460b-b03c-b0ed5ea07558",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1168,
208
],
"parameters": {
"color": 6,
"width": 368,
"content": "根据输入数据中的预定义规则计算数字化的UGC候选人分数（0-10）。它使用Gemini Chat Model进行评估。"
},
"typeVersion": 1
},
{
"id": "2d24b424-d383-440f-a870-97ed9ac62a67",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-784,
208
],
"parameters": {
"color": 4,
"width": 256,
"content": "一个条件门，只允许AI评分达到6分及以上的候选人继续执行工作流的其余部分。"
},
"typeVersion": 1
},
{
"id": "2de88f97-dd75-494c-8358-274566a239a2",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-432,
64
],
"parameters": {
"color": 5,
"content": "将候选人的完整数据及其计算的AI评分添加到Google Sheet。它使用电子邮件来防止重复条目。"
},
"typeVersion": 1
},
{
"id": "f3af5415-27be-4580-8178-16f5bf12db3c",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-128,
-160
],
"parameters": {
"color": 4,
"content": "向候选人的邮箱发送定制邮件，通知他们因其高分已入围。"
},
"typeVersion": 1
},
{
"id": "f2b14e62-bf51-4cf6-9a71-22f2278b5456",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-144,
160
],
"parameters": {
"color": 4,
"width": 320,
"content": "向HR联系人（Marketingr@yourcompany.com）发送内部邮件，包含入围候选人的姓名和分数以便快速跟进。"
},
"typeVersion": 1
},
{
"id": "51d91032-c735-497c-acc9-b393203696c5",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1552,
-624
],
"parameters": {
"width": 1024,
"height": 736,
"content": "# JotForm 设置指南"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "63943148-66f8-4b6c-8ad7-13b994ff669d",
"connections": {
"If": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"JotForm Trigger": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Send Candidate Shortlist Email",
"type": "main",
"index": 0
},
{
"node": "Notify HR of Shortlist",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
JotForm 返现（模板）
使用 JotForm、Gemini 2.5 和 Notion 的自动化返现收据处理
If
Code
Gmail
+8
25 节点Abdullah Alshiekh
HR简历筛选
使用Telegram、Gemini AI和Google Workspace自动化简历筛选与分析
If
Set
Merge
+9
23 节点Abdullah Alshiekh
人力资源
JotForm到Zoho潜在客户自动化（已提交）
使用JotForm、Google表格和Gemini AI到Zoho CRM自动化房地产潜在客户匹配
Set
Gmail
Zoho Crm
+6
15 节点Abdullah Alshiekh
AI医疗报告生成器
使用Gemini AI和Google Workspace从电子邮件生成医疗报告
Set
Code
Gmail
+8
21 节点Abdullah Alshiekh
文档提取
使用Jotform和Gemini自动化自由职业项目接收
使用Jotform和Gemini自动化自由职业项目接收与定制提案
If
Gmail
Google Sheets
+6
9 节点iamvaar
使用 Jotform、Gemini AI 和 Google Sheets 自动化内部投诉处理
通过 Jotform、Gemini AI 和 Google Sheets 实现内部投诉处理的自动化
If
Gmail
Google Sheets
+7
22 节点iamvaar
工单管理
工作流信息
难度等级
中级
节点数量14
分类-
节点类型7
作者
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 查看 →
分享此工作流