使用 Gemini AI、Google Sheets 和 Apps Script 匿名化和重新格式化简历
高级
这是一个HR, AI领域的自动化工作流，包含 18 个节点。主要使用 Code, GoogleDrive, HttpRequest, GoogleSheets, SplitInBatches 等节点，结合人工智能技术实现智能自动化。 使用 Gemini AI、Google Sheets 和 Apps Script 匿名化和重新格式化简历
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "68ab2fc38a2cc97b15d1ba880cb72d72238eae5b4218b86b5ebb74c36e6b712f",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "af8c5794-092e-4ad4-95a9-e1925ffe230a",
"name": "比较数据集",
"type": "n8n-nodes-base.compareDatasets",
"position": [
-480,
24
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "09c69c98-d663-4c5f-9acf-7990307f5107",
"name": "Google Drive",
"type": "n8n-nodes-base.googleDrive",
"position": [
-200,
40
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3814fbaa-4107-47b2-8029-b84e1250f249",
"name": "从文件中提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-20,
40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "73e58014-0646-4d22-a761-367af5621411",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
640,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "07889e21-d9f2-4e11-8e11-b0c1019154a0",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
240,
40
],
"parameters": {},
"typeVersion": 3
},
{
"id": "3f2c758c-c309-4d32-9092-3dc943a9986e",
"name": "更新简历字段",
"type": "n8n-nodes-base.googleSheets",
"position": [
1160,
-80
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "1367384a-fba8-40e8-80c3-3817030f408c",
"name": "清理输出",
"type": "n8n-nodes-base.code",
"position": [
940,
-80
],
"parameters": {},
"typeVersion": 2
},
{
"id": "853cb321-9822-47da-a7a2-7b10be2825d9",
"name": "记录文档处理过程",
"type": "n8n-nodes-base.googleSheets",
"position": [
1360,
60
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ea6e2058-dd6b-4fdd-a03d-b8efa4f62a8a",
"name": "清理输出",
"type": "n8n-nodes-base.code",
"position": [
-700,
-55
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d0e2c477-21c5-4fa0-aa75-469a94e746b2",
"name": "获取 PDF 文件列表",
"type": "n8n-nodes-base.httpRequest",
"position": [
-920,
-55
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7ef3be8f-ec44-458b-8f18-407918e55192",
"name": "读取已处理文档",
"type": "n8n-nodes-base.googleSheets",
"position": [
-800,
100
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "24184f2a-203c-4a7e-9afa-581b7dfcd73a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-980,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ba91f3d2-2702-49dc-93d2-a81e511b01a2",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-280,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "01fe0834-6818-44ca-a03a-69f6cc8eee63",
"name": "AI Agent - 从文本中获取目标元素",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
580,
-80
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "c61c9a31-f508-454c-ba0c-dd825b1433cb",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a27542cf-7065-4449-bee8-2d5e697e6350",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
520,
-380
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.2
},
{
"id": "2008e58f-4c0b-4738-a18a-56c470594d2c",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
-580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "116cf775-e28b-405d-bea5-6970e517caf3",
"name": "Google Drive 触发器",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-1220,
20
],
"parameters": {},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Clean output": {
"main": [
[
{
"node": "Update CV Fields",
"type": "main",
"index": 0
}
]
]
},
"Google Drive": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Cleans output": {
"main": [
[
{
"node": "Compare Datasets",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
],
[
{
"node": "AI Agent - get targeted elements from text",
"type": "main",
"index": 0
}
]
]
},
"Compare Datasets": {
"main": [
[
{
"node": "Google Drive",
"type": "main",
"index": 0
}
],
[],
[],
[]
]
},
"Update CV Fields": {
"main": [
[
{
"node": "Log the processing of the doc",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Read processed docs": {
"main": [
[
{
"node": "Compare Datasets",
"type": "main",
"index": 1
}
]
]
},
"Google Drive Trigger": {
"main": [
[
{
"node": "Get list of pdf files",
"type": "main",
"index": 0
},
{
"node": "Read processed docs",
"type": "main",
"index": 0
}
]
]
},
"Get list of pdf files": {
"main": [
[
{
"node": "Cleans output",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent - get targeted elements from text",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Log the processing of the doc": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"AI Agent - get targeted elements from text": {
"main": [
[
{
"node": "Clean output",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人力资源, 人工智能
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Gemini AI从PDF提取发票数据到Google Sheets 📄
使用Gemini AI从PDF提取发票数据到Google Sheets 📄
Code
Gmail
Limit
+11
28 节点Louis
内容创作
第一轮 Telegram 和 LinkedIn 快速通道 AI 招聘助手
AI候选人筛选流程：LinkedIn到Telegram，集成Gemini与Apify
If
Set
Code
+15
55 节点Dean Pike
人力资源
宠物店 4
🐶 宠物店预约 AI 代理
If
Set
Code
+41
187 节点Bruno Dias
人工智能
使用 Google Gemini AI 生成财经新闻摘要并发送至 Outlook 邮箱
通过 Google Gemini AI 生成财经新闻摘要并发送至 Outlook 邮箱
Set
Code
Aggregate
+9
18 节点Louis
财务
使用 Gemini、Elevenlabs 和 Notion ATS 恢复筛选与行为面试 副本
简历筛选与行为面试，使用Gemini、Elevenlabs和Notion ATS
Set
Wait
Merge
+16
67 节点Brian Coyle
人力资源
AI驱动的RAG文档处理与聊天机器人 - Google Drive、Supabase、OpenAI
基于Google Drive、Supabase和OpenAI的AI驱动RAG文档处理与聊天机器人
Set
Code
Limit
+19
35 节点Billy Christi
人工智能
