个性化拒绝/下一步邮件
高级
这是一个HR, AI Summarization领域的自动化工作流，包含 38 个节点。主要使用 If, Set, Code, Gmail, ClickUp 等节点。 使用Google Sheets、GPT-4o-mini、Gmail和ClickUp自动化候选人拒绝
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "BykSQdHlk9FP9Bwv",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177"
},
"name": "个性化拒绝/下一步邮件",
"tags": [],
"nodes": [
{
"id": "5e09921b-495b-4051-8e7e-094101b0405b",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-896,
272
],
"parameters": {},
"typeVersion": 4
},
{
"id": "5691d2d0-3a2d-4916-956b-0ba7dc7b0b87",
"name": "当点击\"执行工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1168,
272
],
"parameters": {},
"typeVersion": 1
},
{
"id": "25480bf3-4577-4bca-9a69-af3fe247b6dd",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-144,
272
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ed0faf32-f431-4d7c-812c-eb0d5900dbde",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
384,
272
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "d7aa7e85-fa0b-4297-a41d-4b5c1782dbe9",
"name": "创建任务",
"type": "n8n-nodes-base.clickUp",
"position": [
1360,
384
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0a3a33da-b34f-4a2f-8ebe-5ce83f17a13b",
"name": "代码1",
"type": "n8n-nodes-base.code",
"position": [
1040,
384
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d5f58e01-4ca6-4e7f-8b8b-175f8009f201",
"name": "基础 LLM 链",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1008,
752
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "1d13280a-7c62-4d56-a5c7-60b21f83517a",
"name": "Azure OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
928,
992
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f48cab84-dc10-4d40-a1a0-c4f55e1a6d4f",
"name": "基础 LLM 链1",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1008,
-112
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "40437efb-9de9-4f37-a3c8-05129dfc44f0",
"name": "Azure OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
976,
80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1c8977ed-9e37-4ec9-a96f-b9c32be4a4dc",
"name": "邮件",
"type": "n8n-nodes-base.gmail",
"position": [
1696,
16
],
"webhookId": "86f9bdab-5560-4c7e-bbdd-85291f22843d",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "f774b394-32b9-4a8f-b6ce-c2d39b6da144",
"name": "代码2",
"type": "n8n-nodes-base.code",
"position": [
1456,
-112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "36d19753-aa69-4128-b823-cfa3a805defc",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
1696,
-288
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ed6326c6-5a90-4862-b0a8-247997f946e9",
"name": "创建任务1",
"type": "n8n-nodes-base.clickUp",
"position": [
1952,
-288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b69b047f-661b-4c2d-9521-024a41a247c4",
"name": "代码3",
"type": "n8n-nodes-base.code",
"position": [
1456,
752
],
"parameters": {},
"typeVersion": 2
},
{
"id": "896b7ce1-dc3d-412b-a102-1a1a6a67a204",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1232,
32
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1cb85452-3ffe-467f-a22a-3b5d3ad72463",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a94b4a1b-9826-4425-b74d-83222509b02c",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
576
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2144dd60-1439-43cc-ad5f-2c84ad3a78f3",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
16
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "50700ff2-3f4d-497c-b327-59780c52e734",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-208,
32
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5fe6a5c0-ca69-4c8f-8237-9679d908cc19",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1088,
64
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "153f6322-a7f4-4372-95fb-238c5f78d21c",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-368
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "941e7baa-aac9-4d84-8fd9-eb3f5e542d32",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1344,
-336
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d9f1690f-b845-4331-9cc8-5c134db3d74d",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1632,
-528
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "77ae501d-d973-48b6-9992-c9769e5a90b6",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
2096,
-464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9e872177-fbe3-45de-b984-a62890e1465f",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1824,
128
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ae0c80f9-7de8-4c82-95ae-225d82ee9fa7",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
992,
512
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b481151c-59fb-4f0a-a345-e594fbe113f1",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1488,
480
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5f326d40-38b1-491a-9b7a-58cc8a77374d",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1088,
896
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "10a811f1-82cf-44af-b91f-76f9e49e3ea9",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
1456,
928
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f39d6a97-51a9-4789-b8e7-56a105732c75",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
1952,
768
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6b0c4d6-5ff9-4b7b-94d2-0e5d62b491bb",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
768,
1136
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e5e7f8d3-cbfc-4b62-9271-35a14eda8a26",
"name": "基础 LLM 链2",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
-592,
272
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "25d2de23-9b00-4bee-99e3-ea2e72243451",
"name": "Azure OpenAI 聊天模型2",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
-640,
544
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5927b63e-c1f1-4876-9317-428455239b5a",
"name": "代码4",
"type": "n8n-nodes-base.code",
"position": [
112,
272
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4c314c63-1fec-4d5e-b372-18c55d7c4136",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
304,
32
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3fbc3a95-eacc-4775-8c9b-c503621d2667",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "067dff48-20a6-4463-96b6-2d677bed7e80",
"name": "发送拒绝邮件1",
"type": "n8n-nodes-base.gmail",
"position": [
1744,
752
],
"webhookId": "86f9bdab-5560-4c7e-bbdd-85291f22843d",
"parameters": {},
"typeVersion": 2.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "b0888655-aff8-4cea-9d1b-fa5297ccddc9",
"connections": {
"If": {
"main": [
[
{
"node": "Basic LLM Chain1",
"type": "main",
"index": 0
}
],
[
{
"node": "Code1",
"type": "main",
"index": 0
},
{
"node": "Basic LLM Chain",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Code4",
"type": "main",
"index": 0
}
]
]
},
"Code1": {
"main": [
[
{
"node": "Create a task",
"type": "main",
"index": 0
}
]
]
},
"Code2": {
"main": [
[
{
"node": "email",
"type": "main",
"index": 0
},
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Code3": {
"main": [
[
{
"node": "Send Rejection Email1",
"type": "main",
"index": 0
}
]
]
},
"Code4": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"email": {
"main": [
[]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Create a task1",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain": {
"main": [
[
{
"node": "Code3",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain1": {
"main": [
[
{
"node": "Code2",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain2": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Basic LLM Chain2",
"type": "main",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain1",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Azure OpenAI Chat Model2": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"When clicking ‘Execute workflow’": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人力资源, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
结构化面试反馈收集
使用GPT-4o-mini、Gmail和ClickUp任务跟踪自动化候选人拒绝
If
Code
Gmail
+6
18 节点Rahul Joshi
人力资源
面试官简报包
使用Google表格和GPT-4o从简历生成AI驱动的面试简报
Code
Gmail
Google Drive
+6
16 节点Rahul Joshi
人力资源
API速率限制与认证FAQ测试
使用GPT-4o-mini、Google表格和Slack提醒自动化API常见问题质量测试
If
Set
Code
+7
19 节点Rahul Joshi
文档提取
新开发人员入职自动化
使用 GPT-4o 实现员工入职自动化：Jira、Notion 和 Gmail 集成
If
Set
Code
+9
21 节点Rahul Joshi
人力资源
自动化依赖更新跟踪
使用 GPT-4o、Slack、Jira 和 Google Sheets 进行依赖更新风险分析
If
Set
Code
+8
23 节点Rahul Joshi
开发运维
雇佣后留存跟踪
使用GPT-4o和Gmail摘要生成员工留存分析报告
If
Code
Gmail
+6
19 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量38
分类2
节点类型10
作者
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 查看 →
分享此工作流