基于 SerpAPI、Gemini AI 过滤器和邮件通知的自动化职位爬取
高级
这是一个Personal Productivity, AI Summarization领域的自动化工作流，包含 35 个节点。主要使用 Set, Wait, Merge, Switch, SplitOut 等节点。 基于 SerpAPI、Gemini AI 过滤器和邮件通知的自动化职位爬取
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Gemini API Key
使用的节点 (35)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "dca66bfe20538326afcf0ea9818c4e437640a050446b589da002699d11b2eea7",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "650f7afc-f4f7-42f3-9eb8-0de7403c20c0",
"name": "在工作表1中追加或更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1504,
1056
],
"parameters": {},
"executeOnce": false,
"typeVersion": 4.7
},
{
"id": "85ed38d3-6edc-4bac-af9f-78622fc10162",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-704,
928
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "dc165df2-93bd-44ce-af53-db963e474ba4",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
832,
1056
],
"webhookId": "829fa4d7-f84a-4666-9479-84d1d5fba097",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "7445db62-3077-4e0a-876b-95100dcb78e8",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
-480,
928
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "15330745-329f-4c45-8fc3-936603384748",
"name": "Split Out5",
"type": "n8n-nodes-base.splitOut",
"position": [
112,
1232
],
"parameters": {},
"typeVersion": 1
},
{
"id": "07ea0147-2e49-4e09-8870-fab13fee464a",
"name": "HTTP Request5",
"type": "n8n-nodes-base.httpRequest",
"position": [
-112,
1232
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "4c1ba99f-cca4-487e-bc40-eecbf5375f81",
"name": "Split Out6",
"type": "n8n-nodes-base.splitOut",
"position": [
112,
624
],
"parameters": {},
"typeVersion": 1
},
{
"id": "21950c50-831f-46a1-8c33-775fb951e2a6",
"name": "HTTP 请求6",
"type": "n8n-nodes-base.httpRequest",
"position": [
-112,
624
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "97a8418d-89c5-42b5-83ab-68317850e651",
"name": "HTTP 请求7",
"type": "n8n-nodes-base.httpRequest",
"position": [
-112,
768
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "2d3c54af-6276-40bb-8c55-31e0f4736ede",
"name": "Split Out7",
"type": "n8n-nodes-base.splitOut",
"position": [
112,
768
],
"parameters": {},
"typeVersion": 1
},
{
"id": "26a8790c-d671-4126-a3f7-9c391c8792f5",
"name": "HTTP 请求8",
"type": "n8n-nodes-base.httpRequest",
"position": [
-112,
912
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "517a617d-ab02-4240-9ac7-f812407a7df8",
"name": "Split Out8",
"type": "n8n-nodes-base.splitOut",
"position": [
112,
912
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5acf57d7-df20-4505-84b5-174cae9638f2",
"name": "HTTP 请求9",
"type": "n8n-nodes-base.httpRequest",
"position": [
-112,
1040
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "74ed4234-b86c-45d4-b57b-98e80b1b98e2",
"name": "Split Out9",
"type": "n8n-nodes-base.splitOut",
"position": [
112,
1040
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a906301c-8305-459d-9bb8-1f6b557642ae",
"name": "合并2",
"type": "n8n-nodes-base.merge",
"position": [
336,
832
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "a7b2e517-aa56-4647-b206-cae0aab6bf86",
"name": "Compare Datasets1",
"type": "n8n-nodes-base.compareDatasets",
"position": [
560,
1104
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "67fcf85d-23f4-4e51-a06d-395bb05f7b1c",
"name": "Get row(s) in sheet2",
"type": "n8n-nodes-base.googleSheets",
"position": [
336,
1216
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "d7c39d3f-b21c-4811-a31c-541a99f45f40",
"name": "AI 代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1008,
1056
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "a1fb2d9d-b9b6-4f54-b33c-4a71001051e8",
"name": "Google Gemini 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
1040,
1184
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f56c06db-3a2c-4e6f-b0a3-38c820e6faa8",
"name": "切换",
"type": "n8n-nodes-base.switch",
"position": [
1280,
1056
],
"parameters": {},
"typeVersion": 3.3
},
{
"id": "380cc3c6-22f3-4b80-a7d5-b6783e2b3e05",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-768,
784
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "1c776d8d-b321-4337-8b31-b421f0a52891",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-304,
32
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "107b2649-4c9b-4089-b0cc-19f590d09a8b",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
288,
1104
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "54ed8857-60f0-4617-ab3a-c04b15b26f28",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
928
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "cc087cdc-1651-4d99-b2c3-1cf210225ef0",
"name": "在表格中更新行",
"type": "n8n-nodes-base.googleSheets",
"position": [
32,
1808
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "81e36bfc-9ee0-477e-82ea-b8d22412c90e",
"name": "当被另一个工作流执行时",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
-304,
1584
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "9d31f1e0-caaf-4e5e-a17a-9e0728868324",
"name": "Send a message1",
"type": "n8n-nodes-base.microsoftOutlook",
"position": [
128,
1584
],
"webhookId": "270c33b5-76bc-48d4-a886-6060e00b025b",
"parameters": {},
"typeVersion": 2
},
{
"id": "55e283a5-91a8-4e77-b20d-7c9ca035334e",
"name": "聚合",
"type": "n8n-nodes-base.aggregate",
"position": [
0,
1584
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bd2ba049-10a4-4747-8d1c-0d9bb04af467",
"name": "Get row(s) in sheet3",
"type": "n8n-nodes-base.googleSheets",
"position": [
-160,
1584
],
"parameters": {},
"executeOnce": true,
"typeVersion": 4.7
},
{
"id": "771c250e-28f5-4f5c-93b3-8676f452da60",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-592,
1472
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "63fa240c-8bb5-4124-a8d5-666c64d3f02d",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
512,
928
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "0d86e789-c7b8-49c2-9b44-9172ec0f1381",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-16,
1712
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "26d48f17-87b0-479d-b494-7eda28269a6f",
"name": "Call sub workflow",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1728,
1056
],
"parameters": {},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "70c5aa29-2503-476c-b58f-8d93fa051a6e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
512
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "c957cbba-aafb-47af-ad39-c2fe88e67e44",
"name": "My CTA Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
576
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Wait": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Merge2": {
"main": [
[
{
"node": "Compare Datasets1",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "Append or update row in sheet1",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Aggregate": {
"main": [
[
{
"node": "Send a message1",
"type": "main",
"index": 0
}
]
]
},
"Split Out5": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 4
}
]
]
},
"Split Out6": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 0
}
]
]
},
"Split Out7": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 1
}
]
]
},
"Split Out8": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 2
}
]
]
},
"Split Out9": {
"main": [
[
{
"node": "Merge2",
"type": "main",
"index": 3
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "HTTP Request6",
"type": "main",
"index": 0
},
{
"node": "HTTP Request7",
"type": "main",
"index": 0
},
{
"node": "HTTP Request8",
"type": "main",
"index": 0
},
{
"node": "HTTP Request9",
"type": "main",
"index": 0
},
{
"node": "HTTP Request5",
"type": "main",
"index": 0
},
{
"node": "Get row(s) in sheet2",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request5": {
"main": [
[
{
"node": "Split Out5",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request6": {
"main": [
[
{
"node": "Split Out6",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request7": {
"main": [
[
{
"node": "Split Out7",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request8": {
"main": [
[
{
"node": "Split Out8",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request9": {
"main": [
[
{
"node": "Split Out9",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"Compare Datasets1": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet2": {
"main": [
[
{
"node": "Compare Datasets1",
"type": "main",
"index": 1
}
]
]
},
"Get row(s) in sheet3": {
"main": [
[
{
"node": "Update row in sheet",
"type": "main",
"index": 0
},
{
"node": "Aggregate",
"type": "main",
"index": 0
}
]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Append or update row in sheet1": {
"main": [
[
{
"node": "Call sub workflow",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Get row(s) in sheet3",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 个人效率, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用 Mistral AI、LinkedIn 和 Google Sheets 自动化职位搜索与简历定制
使用 Mistral AI、LinkedIn 和 Google Sheets 自动化职位搜索与简历定制
Set
Code
Html
+18
46 节点Jordan Hoyle
个人效率
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
其他
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
工作流信息
难度等级
高级
节点数量35
分类2
节点类型16
作者
Louis
@louisdl🚀 Business & tech consultant specialized in No Code automation and AI. I help SMEs, startups, and independents save time and cut costs with scalable workflows in n8n and other tools. Passionate about making automation simple, useful, and human-centered. 👉 Also sharing automation insights on YouTube Find all my links here : https://linktr.ee/cashflows.routine And my AI Agency here : https://agence-alain.fr
外部链接
在 n8n.io 查看 →
分享此工作流