AI驱动的校园招聘面试准备系统
高级
这是一个Other, AI领域的自动化工作流，包含 21 个节点。主要使用 Code, Merge, EmailSend, FormTrigger, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 基于AI的面试准备系统，使用本地LLM为校园招聘服务
前置要求
- •Google Sheets API 凭证
使用的节点 (21)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "473ff4054f1a6c3ed6f17a2b4a2e55676fe5b921cceb87b2256e6c416c158559",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "560190c8-819d-47f0-9dc2-6d3ae8a2307e",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
220,
20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "6ec524e2-79ea-4b78-8898-f77466983039",
"name": "## 🧠 LLM 总结",
"type": "@n8n/n8n-nodes-langchain.lmChatOllama",
"position": [
860,
180
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1ccf58c5-d386-4b6f-b783-baeb2fa0a62e",
"name": "合并1",
"type": "n8n-nodes-base.merge",
"position": [
1660,
20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "2286cab3-f9cc-446a-b679-8f30bc0b9d95",
"name": "Ollama 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOllama",
"position": [
1140,
-100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f79fd009-809a-4402-bd02-4c917b6d96db",
"name": "Gemini 搜索工具",
"type": "n8n-nodes-gemini-search.geminiSearchToolTool",
"position": [
1000,
200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d3d80933-7175-40fb-a241-1528011657aa",
"name": "合并2",
"type": "n8n-nodes-base.merge",
"position": [
1660,
-100
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "c000c8e3-eb04-47b6-8faa-be77d67a931c",
"name": "合并 3",
"type": "n8n-nodes-base.merge",
"position": [
1900,
-20
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "780f7857-ceb9-4838-b57e-420c2025bfa6",
"name": "解析上传的候选人 CSV 文件",
"type": "n8n-nodes-base.formTrigger",
"position": [
-420,
20
],
"webhookId": "9efa65f7-1717-4009-abbd-9a7c9ac3d858",
"parameters": {},
"typeVersion": 2.2
},
{
"id": "bd8a55e4-a326-4eb6-96a0-8ec079fa1552",
"name": "在 Google 电子表格中创建工作表",
"type": "n8n-nodes-base.googleSheets",
"position": [
0,
-80
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "ada077d0-98b8-4a60-b27d-00dd07e42e4c",
"name": "提取 CSV 数据",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-60,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8419db80-d996-4adc-bac1-92bbf3c06ac2",
"name": "将 CSV 数据添加到 Google 电子表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
0
],
"parameters": {},
"executeOnce": false,
"retryOnFail": false,
"typeVersion": 4.6,
"alwaysOutputData": false,
"waitBetweenTries": 2000
},
{
"id": "bf878d70-ef89-498f-88a4-eb7cbfd3362d",
"name": "根据选定列选择首行",
"type": "n8n-nodes-base.googleSheets",
"position": [
660,
0
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7fc67f04-72bd-410b-a31e-001421769a9f",
"name": "工作面试准备助手",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
840,
0
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "4cddb198-e2f9-40ab-919e-9c4e0f8e49d6",
"name": "将项目名称更改为 Markdown 格式",
"type": "n8n-nodes-base.code",
"position": [
1180,
60
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d1ed328c-cd29-4333-bbfe-b836db04b10d",
"name": "创建 PDF 文件",
"type": "n8n-nodes-base.apiTemplateIo",
"position": [
1360,
20
],
"parameters": {},
"typeVersion": 1
},
{
"id": "38b1c4c0-0fc8-410c-915e-84fb74653688",
"name": "邮件提示助手",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
860,
-220
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "7691b5db-1ed0-47cb-9d1e-d92d71bbdc10",
"name": "发送带 PDF 的邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1600,
200
],
"webhookId": "3df365d5-ba8d-4174-bf74-28b2cecb8cec",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "6e1fa2e2-c749-42ce-a50d-0780badb59c9",
"name": "将选定列更新到电子表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
1760,
200
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "7e1dcf30-6dfc-4587-abb1-1380c7c8ac0b",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "53d1fd01-ae33-4639-9f75-6a5e0ba92d37",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "45353064-233f-42d3-939c-2835b3abfb92",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
-240
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Merge": {
"main": [
[
{
"node": "Add csv data to google spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Merge1": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 1
}
]
]
},
"Merge2": {
"main": [
[
{
"node": "Merge3",
"type": "main",
"index": 0
}
]
]
},
"Merge3": {
"main": [
[
{
"node": "Send Email with PDF",
"type": "main",
"index": 0
}
]
]
},
"Create PDF files": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 1
},
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"extract csv data": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Ollama Chat Model": {
"ai_languageModel": [
[
{
"node": "Job Interview Preparation Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Email prompt Agent": {
"main": [
[
{
"node": "Merge1",
"type": "main",
"index": 0
},
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Gemini Search Tool": {
"ai_tool": [
[
{
"node": "Job Interview Preparation Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Ollama Chat Model1": {
"ai_languageModel": [
[
{
"node": "Email prompt Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Send Email with PDF": {
"main": [
[
{
"node": "Update the selected column to spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"change item name to markdown": {
"main": [
[
{
"node": "Create PDF files",
"type": "main",
"index": 0
}
]
]
},
"Job Interview Preparation Agent": {
"main": [
[
{
"node": "change item name to markdown",
"type": "main",
"index": 0
}
]
]
},
"Parse Uploaded CSV of Candidates": {
"main": [
[
{
"node": "extract csv data",
"type": "main",
"index": 0
},
{
"node": "create a sheet in google spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Add csv data to google spreadsheet": {
"main": [
[
{
"node": "Select first row based on selected column",
"type": "main",
"index": 0
}
]
]
},
"create a sheet in google spreadsheet": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Select first row based on selected column": {
"main": [
[
{
"node": "Job Interview Preparation Agent",
"type": "main",
"index": 0
},
{
"node": "Email prompt Agent",
"type": "main",
"index": 0
}
]
]
},
"Update the selected column to spreadsheet": {
"main": [
[
{
"node": "Select first row based on selected column",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 其他, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
自动帖子生成
使用Ollama、图像创建和Gmail交付生成AI驱动的LinkedIn帖子
Linked In
Email Send
Form Trigger
+7
21 节点Aashit Sharma
设计
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
使用Ollama LLMs和Google Sheets生成并优化品牌故事
使用Ollama LLMs和Google Sheets生成并优化品牌故事
If
Set
Google Sheets
+4
13 节点Aashit Sharma
人工智能
测验短视频生成器
使用Sonnet 3.5、Pinecone和Creatomate生成谜语短视频并发布到YouTube
If
Code
Wait
+13
32 节点Joseph
其他
智能面试助手：基于简历、职位描述和轮次的定制问题
基于简历、职位描述和轮次使用GPT-4生成定制面试问题
Set
Code
Merge
+10
26 节点Trung Tran
人力资源
AI营销代理：Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理：通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+12
23 节点Ari Nakos
销售
工作流信息
难度等级
高级
节点数量21
分类2
节点类型11
作者
Aashit Sharma
@aashitsharmaWith a strong background in AI agent systems, RAG pipelines, and open-source automation tools like n8n, LangChain, and Ollama, Aashit specializes in crafting end-to-end solutions that merge intelligence with efficiency. He has developed multiple production-ready n8n templates — from personalized interview prep systems and document generators to AI-powered support agents — all designed to empower teams with scalable, low-code automation.
外部链接
在 n8n.io 查看 →
分享此工作流