恢复收件箱到表格自动化
高级
这是一个HR, AI Summarization领域的自动化工作流，包含 18 个节点。主要使用 Code, Gmail, GoogleDrive, GmailTrigger, GoogleSheets 等节点。 从Gmail解析简历至Google Sheets - 使用Azure OpenAI GPT-4o
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (18)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "9vkTYYMOrjBIOFub",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "恢复收件箱到表格自动化",
"tags": [],
"nodes": [
{
"id": "f17712f0-4ebd-4615-8cab-8a755d085e04",
"name": "Gmail 触发器",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-992,
-272
],
"parameters": {},
"typeVersion": 1
},
{
"id": "22e9642c-79d5-46e8-8f65-628a5e193fee",
"name": "Google Drive 上传",
"type": "n8n-nodes-base.googleDrive",
"position": [
-544,
-272
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f0260967-aeb4-4f45-aafb-acc8cef73f70",
"name": "Google Sheets 追加",
"type": "n8n-nodes-base.googleSheets",
"position": [
752,
-272
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c9bdf639-b158-4ccb-bd97-9c97adc79676",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
128,
-272
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "250b120d-e888-44b2-b151-9a42f5eae6bf",
"name": "Azure OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
176,
-112
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bf330813-ff4e-45e6-a77c-051bf0fd76f6",
"name": "获取附件",
"type": "n8n-nodes-base.gmail",
"position": [
-768,
-272
],
"webhookId": "a9e527d3-a895-419f-ac43-f415a9a056be",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e1a5d0b4-ed80-4871-b545-7d4def965a46",
"name": "下载文件",
"type": "n8n-nodes-base.googleDrive",
"position": [
-320,
-272
],
"parameters": {},
"typeVersion": 3
},
{
"id": "42fe4e70-e92d-4235-b21a-d5659c10a640",
"name": "从文件提取",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-96,
-272
],
"parameters": {},
"typeVersion": 1
},
{
"id": "150fcd9b-d133-4e02-8b09-7bc81f602b28",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
528,
-272
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4831082d-f7cc-48a2-948f-b7419959593a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1120,
-656
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "57d797cf-c9ae-4f1b-bec4-7475619a8f7d",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "27f744cf-1169-404e-b8ad-2e938439b213",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-672
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "43b013a1-900b-4da0-b7d0-c86d9db0fc20",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4e43b6be-0d9a-4e60-80f8-ff26fb92c21c",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
-672
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a5aaf5b4-17a6-4e0b-bc41-ec5c46dc8593",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-672
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a7e9dbb9-7b73-43f7-825e-41577c93696a",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
-16,
32
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a445ade7-476b-4328-a556-df63b307656b",
"name": "## 试试看！",
"type": "n8n-nodes-base.stickyNote",
"position": [
464,
-144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d54ef6a9-e358-4df0-9c5a-be591149911b",
"name": "GET 模型",
"type": "n8n-nodes-base.stickyNote",
"position": [
608,
-720
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "00c3f01a-e35a-4026-b5cf-d79e1b69215b",
"connections": {
"Code": {
"main": [
[
{
"node": "Google Sheets Append",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Download file": {
"main": [
[
{
"node": "Extract from File",
"type": "main",
"index": 0
}
]
]
},
"Gmail Trigger": {
"main": [
[
{
"node": "Get the attahcment",
"type": "main",
"index": 0
}
]
]
},
"Extract from File": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Get the attahcment": {
"main": [
[
{
"node": "Google Drive Upload",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Upload": {
"main": [
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人力资源, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
面试官简报包
使用Google表格和GPT-4o从简历生成AI驱动的面试简报
Code
Gmail
Google Drive
+6
16 节点Rahul Joshi
人力资源
Drive到ClickUp简历自动化
使用GPT-4o和Google表格从Google Drive处理简历到ClickUp
Code
Click Up
Google Drive
+6
16 节点Rahul Joshi
人力资源
JD匹配分数
使用 Google Drive、Google Sheets 和 GPT-4o 评估简历与职位描述的匹配度
Code
Google Drive
Google Sheets
+5
37 节点Rahul Joshi
人力资源
技能矩阵提取器
使用Google Drive和GPT-4o将技能矩阵提取至Google表格
Code
Google Drive
Google Sheets
+5
17 节点Rahul Joshi
杂项
支持收件箱到常见问题解答回填（Gmail/Outlook）
使用GPT-4o、Gmail、Notion和Slack将支持邮件转换为常见问题解答
If
Code
Gmail
+7
21 节点Rahul Joshi
工单管理
结构化面试反馈收集
使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝
If
Code
Gmail
+6
18 节点Rahul Joshi
人力资源
工作流信息
难度等级
高级
节点数量18
分类2
节点类型9
作者
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 查看 →
分享此工作流