完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
高级
这是一个Content Creation、Multimodal AI领域的自动化工作流，包含 116 个节点。主要使用 If、Set、Code、Sort、Wait 等节点。 完整的 B2B 销售流程：Apollo 潜在客户生成、Mailgun 外展和 AI 回复管理
前置要求
- •Google 账号和 Gmail API 凭证
- •PostgreSQL 数据库连接信息
- •Supabase URL 和 API Key
- •Telegram Bot Token
- •OpenAI API Key
- •Anthropic API Key
使用的节点 (116 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "e7ccf4281d5afb175c79c02db95b45f15d5b53862cb6bc357c5e5bc26567f35c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "27d3a434-861b-42ad-9afa-702185011fdb",
"name": "限制",
"type": "n8n-nodes-base.limit",
"position": [
-4976,
-1888
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bc817fb8-404f-4482-b41b-f0b538bc4ff1",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
-3168,
-1904
],
"parameters": {},
"typeVersion": 3.1
},
{
"id": "6eb543e3-64c7-4298-bf1d-d726dcfdc718",
"name": "时区",
"type": "n8n-nodes-base.code",
"position": [
-3040,
-1904
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ea3d549c-b95f-4258-8a66-4d72fd1a43e7",
"name": "发件人邮箱",
"type": "n8n-nodes-base.code",
"position": [
-2896,
-1904
],
"parameters": {},
"typeVersion": 2
},
{
"id": "54ac11cc-f759-483d-8bf0-d2ccdff434d2",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
-5024,
-960
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "eda2f699-87e3-47e4-8f9f-35a3e0f5fc19",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4816,
-1232
],
"parameters": {},
"typeVersion": 3
},
{
"id": "e2714426-3da1-46ce-a6fa-66ef4aaca18b",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
-4368,
-1168
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "9df2eb32-4b8c-450b-9c78-2c2daa8350d4",
"name": "遍历项目1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-4816,
-736
],
"parameters": {},
"typeVersion": 3
},
{
"id": "154308b4-4316-4592-a483-14e4e4301ecf",
"name": "等待1",
"type": "n8n-nodes-base.wait",
"position": [
-4368,
-672
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "3e5e8520-853e-4f46-8b52-192336c52fdb",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-5904,
-848
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b98f7986-16a6-49e4-b301-cd86781c7a94",
"name": "如果3",
"type": "n8n-nodes-base.if",
"position": [
-5344,
-1856
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "996e5962-a515-4052-b6d0-e703e2efefff",
"name": "Mailgun",
"type": "n8n-nodes-base.mailgun",
"onError": "continueRegularOutput",
"position": [
-4592,
-688
],
"parameters": {},
"typeVersion": 1
},
{
"id": "69d5fd6f-d628-4412-9d0c-cfdd4587e49f",
"name": "Mailgun1",
"type": "n8n-nodes-base.mailgun",
"onError": "continueRegularOutput",
"position": [
-4592,
-1200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c4699a8f-80da-40ba-bc94-eb10f44910c3",
"name": "通用分析",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-4400,
-2064
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "35873420-4131-4138-858e-463dee9925e2",
"name": "限制1",
"type": "n8n-nodes-base.limit",
"position": [
-5248,
-960
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2b768d85-ead6-42c2-ae25-ba1358265ef8",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-3872,
-2160
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "292d0b42-39d3-4a0a-9aab-33cd784863df",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5920,
-1392
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "fd6d0b46-e334-4122-9458-65fc751fab3e",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5920,
-2416
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "92fce186-0d0d-4c29-af5b-43436367e4f7",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
-4896,
-1680
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1d94f67a-5481-40b1-a023-c72440f2eced",
"name": "Supabase2",
"type": "n8n-nodes-base.supabase",
"position": [
-5728,
-848
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bc8a4879-e9fc-4076-831c-c64540334526",
"name": "如果2",
"type": "n8n-nodes-base.if",
"position": [
-5456,
-848
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "95713afb-6b8e-40bd-a1f1-2204df391e20",
"name": "无操作，不执行任何操作2",
"type": "n8n-nodes-base.noOp",
"position": [
-5248,
-752
],
"parameters": {},
"typeVersion": 1
},
{
"id": "693a65b1-40ea-4eab-8f34-c38651d0ec1c",
"name": "Supabase3",
"type": "n8n-nodes-base.supabase",
"position": [
-4592,
-1408
],
"parameters": {},
"typeVersion": 1
},
{
"id": "62e2b07a-fcb7-4a10-a124-775a2fd7ae07",
"name": "Supabase4",
"type": "n8n-nodes-base.supabase",
"position": [
-4592,
-848
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a07358ac-2062-411e-b581-aab3f66529ff",
"name": "多表：您可以连接多个表以实现有组织的数据结构",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"disabled": true,
"position": [
-3648,
-2048
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e3b55fe8-e670-421f-848c-ab4b85d8021a",
"name": "代码",
"type": "n8n-nodes-base.code",
"position": [
-3456,
-2320
],
"parameters": {},
"typeVersion": 2
},
{
"id": "f22a857d-0e66-4eb5-9471-ad37325c8885",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4064,
-1408
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "298eadec-4cb4-43c8-83bb-69b4fde051e4",
"name": "计划触发器3",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-5808,
-1856
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "cf82532f-5757-4802-8eee-57ff328fd187",
"name": "Supabase11",
"type": "n8n-nodes-base.supabase",
"position": [
-3888,
-784
],
"parameters": {},
"typeVersion": 1
},
{
"id": "79436ed4-c6e9-4743-9d77-ff909a68851f",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
-3600,
-784
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "0b986d68-7396-4f1c-915c-bc1bd32d41bc",
"name": "评估邮件发送时间",
"type": "n8n-nodes-base.code",
"position": [
-3744,
-784
],
"parameters": {},
"typeVersion": 2
},
{
"id": "b423eb64-3947-4663-8a0c-edb47d457242",
"name": "排序",
"type": "n8n-nodes-base.sort",
"position": [
-3408,
-880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f405336d-2832-4d29-9a7d-7f2cade23dbd",
"name": "排序1",
"type": "n8n-nodes-base.sort",
"position": [
-5152,
-1888
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e83b6aee-8f9e-4bf4-b4a2-b39de6223e02",
"name": "排序2",
"type": "n8n-nodes-base.sort",
"position": [
-5584,
-848
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ab93c74b-1a5c-41ff-a618-a7699dbfef74",
"name": "限制2",
"type": "n8n-nodes-base.limit",
"position": [
-3248,
-880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "b2a7a07b-cce5-41af-95d2-9b192e7f399e",
"name": "条件判断5",
"type": "n8n-nodes-base.switch",
"position": [
-3120,
-880
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "b9c899a3-f99c-44b0-ae45-9857da1d4ee5",
"name": "遍历项目7",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-2896,
-1152
],
"parameters": {},
"typeVersion": 3
},
{
"id": "43a5a2ed-dd44-44f4-abf3-a0e9b85997fd",
"name": "等待7",
"type": "n8n-nodes-base.wait",
"position": [
-2464,
-1104
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "3f2722af-7d15-4bd5-a328-4d6a118617d2",
"name": "遍历项目10",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-2896,
-656
],
"parameters": {},
"typeVersion": 3
},
{
"id": "dec76f0f-f222-42cb-8165-5e6584ad584e",
"name": "等待10",
"type": "n8n-nodes-base.wait",
"position": [
-2464,
-592
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c1bd8891-cbd6-44f5-8594-f206fc2529af",
"name": "Mailgun6",
"type": "n8n-nodes-base.mailgun",
"onError": "continueRegularOutput",
"position": [
-2672,
-640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "13f186e5-a58c-458f-b374-dcb35004ecdd",
"name": "Mailgun7",
"type": "n8n-nodes-base.mailgun",
"onError": "continueRegularOutput",
"position": [
-2672,
-1136
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3cd89f07-ce84-41af-a4b8-04d262de3283",
"name": "Supabase12",
"type": "n8n-nodes-base.supabase",
"position": [
-2672,
-1344
],
"parameters": {},
"typeVersion": 1
},
{
"id": "98364fb0-f5d7-451f-83f9-57bc61c69f60",
"name": "Supabase14",
"type": "n8n-nodes-base.supabase",
"position": [
-2672,
-832
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6224874f-8032-4cb3-8d1a-3176e6449a6b",
"name": "定时触发器4",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-4016,
-784
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b6c62bcc-6000-4539-95e0-5209bd8f7aa9",
"name": "无操作，不执行任何操作1",
"type": "n8n-nodes-base.noOp",
"position": [
-3360,
-688
],
"parameters": {},
"typeVersion": 1
},
{
"id": "53b4c414-5f98-40dc-82d8-eb3cd1e46eba",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5216,
-304
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "2c143a9c-c11c-4a59-bc1a-ad331eaee0f0",
"name": "Supabase13",
"type": "n8n-nodes-base.supabase",
"position": [
-4960,
304
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6c0384cf-9efa-4e67-a2c3-65cfc35e0b29",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-4528,
304
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c806c9fa-78ae-4048-9b71-e38d8d3e1cad",
"name": "评估邮件发送时间1",
"type": "n8n-nodes-base.code",
"position": [
-4752,
304
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4895418b-4719-4caa-9a97-fd9f7740ca79",
"name": "排序3",
"type": "n8n-nodes-base.sort",
"position": [
-4304,
192
],
"parameters": {},
"typeVersion": 1
},
{
"id": "462e9de3-04d2-4912-9591-6f960c8098e0",
"name": "限制4",
"type": "n8n-nodes-base.limit",
"position": [
-4080,
192
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0b71716b-a831-40e5-bee5-5c17bc364805",
"name": "条件判断6",
"type": "n8n-nodes-base.switch",
"position": [
-3872,
192
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "5e9516b4-c7de-4d76-8bee-e381aef2901c",
"name": "遍历项目8",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-3648,
-80
],
"parameters": {},
"typeVersion": 3
},
{
"id": "1aac4984-b38c-4b13-b731-a2ca248d2692",
"name": "等待8",
"type": "n8n-nodes-base.wait",
"position": [
-3200,
-16
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "fa219c52-49e8-44a9-a7e4-92b82ef5aa21",
"name": "遍历项目11",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-3648,
416
],
"parameters": {},
"typeVersion": 3
},
{
"id": "7bc06c36-3cbf-4f23-ae9b-6b04ddc32743",
"name": "等待11",
"type": "n8n-nodes-base.wait",
"position": [
-3200,
480
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "10464b78-de8d-465b-9a0b-6e7ea7131b4e",
"name": "Mailgun8",
"type": "n8n-nodes-base.mailgun",
"onError": "continueRegularOutput",
"position": [
-3424,
432
],
"parameters": {},
"typeVersion": 1
},
{
"id": "350ad0cc-1cf8-44d9-8f8d-34012e1e628f",
"name": "Mailgun9",
"type": "n8n-nodes-base.mailgun",
"onError": "continueRegularOutput",
"position": [
-3424,
-64
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a645f4e2-2d3c-4f8c-89f0-e76cb1b0cf14",
"name": "Supabase15",
"type": "n8n-nodes-base.supabase",
"position": [
-3424,
-256
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f2370654-43d8-4439-9ebb-da9bc2ec7a42",
"name": "Supabase16",
"type": "n8n-nodes-base.supabase",
"position": [
-3424,
240
],
"parameters": {},
"typeVersion": 1
},
{
"id": "982c24ce-1400-40ae-a11a-a70d6fbb5b85",
"name": "定时触发器6",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-5184,
304
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "b4ba3e67-60ed-496a-a1c4-66baa9635aab",
"name": "无操作，不执行任何操作4",
"type": "n8n-nodes-base.noOp",
"position": [
-4304,
400
],
"parameters": {},
"typeVersion": 1
},
{
"id": "18e79c15-0748-409b-b647-370c9b7593b8",
"name": "公司调研",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-4752,
-2064
],
"parameters": {},
"typeVersion": 1.8
},
{
"id": "b24bc973-200a-49bd-97d1-58d2db879b33",
"name": "创建邮件序列",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-3840,
-2320
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "5543bf2a-9e91-47a1-b586-e4b66bcec89c",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5632,
-1920
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "7177ce06-3c5e-43ba-b141-206d25bf669f",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5392,
-1936
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "f8cc5364-71b9-44a6-8eb8-605804dad620",
"name": "获取多行数据",
"type": "n8n-nodes-base.supabase",
"position": [
-5552,
-1856
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9adc90f6-2479-418c-b5cb-4eba356acede",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7280,
-2512
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "d1570a31-9d06-47e4-9791-55280e7798d9",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4864,
-2384
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "61ae9ad6-f2de-4199-9965-bc7e2ace6d76",
"name": "您的潜在客户表",
"type": "n8n-nodes-base.supabase",
"position": [
-2736,
-1904
],
"parameters": {},
"typeVersion": 1
},
{
"id": "03d21779-7f18-4cb1-ab04-fd6a695dd766",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6608,
-880
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "ebb6493c-e681-495f-98c1-690880159ccf",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5104,
-1024
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "d21016ea-777e-4862-8baf-dd0f26eeedb1",
"name": "创建 URL",
"type": "n8n-nodes-base.code",
"position": [
-5744,
-3200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3bffc950-5178-4af2-9853-5d95901f8de0",
"name": "提取信息",
"type": "n8n-nodes-base.set",
"position": [
-5312,
-3200
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "f0f12623-7d98-47b5-b1f2-580103feee74",
"name": "仅保留已验证邮箱",
"type": "n8n-nodes-base.filter",
"position": [
-5088,
-3200
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "85af7df6-72cb-4c37-9f1e-823792a1e594",
"name": "下载文件1",
"type": "n8n-nodes-base.telegram",
"position": [
-6832,
-3376
],
"webhookId": "00c7755c-cd84-4aa4-89fe-c56f1f0cb50d",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "5677f6d9-749f-4178-898f-9a966e999d9e",
"name": "转录1",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-6608,
-3376
],
"parameters": {},
"typeVersion": 1.6
},
{
"id": "a5f48820-3b89-41dd-bc51-95df7b6bdd4d",
"name": "文本1",
"type": "n8n-nodes-base.set",
"position": [
-6704,
-3120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2dcf8460-8cec-4932-8e13-338ea0a24ab6",
"name": "语音或文本1",
"type": "n8n-nodes-base.switch",
"position": [
-7056,
-3280
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "4821533b-1056-4729-a7ff-c8557f04804c",
"name": "OpenAI 聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-6384,
-3056
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "3d1d5934-c038-4125-8660-bfc19ec82fec",
"name": "简单记忆",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
-6272,
-3056
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "1e43401d-840c-4b0b-8622-86b87eff0899",
"name": "选择已爬取的邮件",
"type": "n8n-nodes-base.postgres",
"position": [
-5552,
-3472
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "effac512-1d23-4f77-824b-684ab6d6ae67",
"name": "仅保留新潜在客户",
"type": "n8n-nodes-base.compareDatasets",
"position": [
-4848,
-3232
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "065abd0f-f89e-41e0-a0a3-b89de0c0c3f9",
"name": "已爬取",
"type": "n8n-nodes-base.noOp",
"position": [
-4512,
-3328
],
"parameters": {},
"typeVersion": 1
},
{
"id": "29855d01-8dde-47db-940a-86e4ab15a978",
"name": "创建新潜在客户行",
"type": "n8n-nodes-base.supabase",
"position": [
-4576,
-3120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "59aa91ac-0b96-4482-bc6c-14b806ff757d",
"name": "设置 Telegram 消息",
"type": "n8n-nodes-base.set",
"position": [
-4368,
-3120
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7ddea704-eb2d-4e36-90bf-75513091ad1a",
"name": "确认消息",
"type": "n8n-nodes-base.telegram",
"position": [
-3952,
-3120
],
"webhookId": "20bb0a77-76bc-4d9a-bdb4-f5e53a80d299",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e904c3b0-9b3c-4873-92e1-1347e8d3e758",
"name": "用户消息",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-7264,
-3280
],
"webhookId": "75096a78-a466-4f4e-bc0d-f68e9e952231",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "2d00609e-95b8-4666-b6d4-35c778f5383d",
"name": "生成查询载荷",
"type": "n8n-nodes-base.set",
"position": [
-5952,
-3168
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c51252a6-2817-4855-8d32-56c7e2d91351",
"name": "爬虫代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-6352,
-3280
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "ed383907-566b-4fae-888a-de38bcdb3856",
"name": "运行执行器",
"type": "@apify/n8n-nodes-apify.apify",
"position": [
-5536,
-3200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "26d46432-be31-4792-8515-53040306add5",
"name": "限制3",
"type": "n8n-nodes-base.limit",
"position": [
-4176,
-3120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "59a8c411-abd0-4b83-8594-23376ccf23ce",
"name": "结构化输出解析器1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-6144,
-3056
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6ee9e2d6-c430-4858-ad40-e9e5d8f729dc",
"name": "便签 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7296,
-3520
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "cf24f6b6-2398-4d75-b595-fce8d61d1d60",
"name": "便签 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-6416,
-3520
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "89e277d9-7b51-4e01-8141-2611bbe044dd",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3696,
-3776
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "2d94af3c-a246-4459-ae17-c21947ea4c55",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-5792,
-3280
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "d3291018-9215-443b-8ad8-ab0816daaeae",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4608,
-2960
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "8cfa4530-62e7-4340-806c-01c248e092b6",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7296,
-3760
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "866fa84c-00ab-4745-aede-3ded4b880441",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7328,
-4176
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "653974ca-d528-496d-a958-c2d575352819",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7328,
-2624
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "74b58187-e74e-4b0b-ac24-94b39861a9b7",
"name": "便签18",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4656,
-1296
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "eb8f62f4-8567-483f-b19c-d466302f5f32",
"name": "Gmail 触发器",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
-7248,
1040
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "92e86738-14d5-4fdf-8f73-09ab97d2befb",
"name": "便签19",
"type": "n8n-nodes-base.stickyNote",
"position": [
-7344,
768
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "f65fbc0b-42e9-47ec-8e9a-e845b3985782",
"name": "获取消息",
"type": "n8n-nodes-base.gmail",
"position": [
-5904,
1040
],
"webhookId": "[REDACTED_WEBHOOK_ID]",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "375296cc-124c-4163-855a-60929bed682a",
"name": "执行 SQL 查询",
"type": "n8n-nodes-base.postgres",
"position": [
-6752,
1040
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "3d2f76ee-0922-405f-874c-6f64887e0352",
"name": "设置已回复 = 是",
"type": "n8n-nodes-base.postgres",
"position": [
-6352,
1040
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "a9ccdd68-100a-4e48-938b-7fdf860b5b69",
"name": "仅来自邮件营销活动",
"type": "n8n-nodes-base.filter",
"position": [
-6560,
1040
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "aec108fb-5c14-4fa6-9d69-c8f86eb5e711",
"name": "提取邮箱",
"type": "n8n-nodes-base.code",
"position": [
-6992,
1040
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0f1ef5e9-bec2-40d7-8cb5-1f82d45a299c",
"name": "获取邮件历史",
"type": "n8n-nodes-base.gmailTool",
"position": [
-5152,
1328
],
"webhookId": "REPLACE_WITH_WEBHOOK_ID",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "841a0797-e933-4a34-a627-6da450fbe931",
"name": "检查发送历史",
"type": "n8n-nodes-base.gmailTool",
"position": [
-5296,
1328
],
"webhookId": "REPLACE_WITH_WEBHOOK_ID",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "5fcdfd0a-6f2c-4400-9f01-df19f6f2036b",
"name": "邮件响应解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-4944,
1296
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "4d3eab59-2bc6-4f20-89f8-99d0f4e38816",
"name": "专业邮件响应代理",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-5408,
1024
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "d1a2d49e-dfd7-4241-ba8c-543ebb928ce4",
"name": "创建草稿回复",
"type": "n8n-nodes-base.gmail",
"position": [
-4688,
1024
],
"webhookId": "REPLACE_WITH_WEBHOOK_ID",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "4985bfb6-4a23-404b-9072-70bf6b78fb04",
"name": "Anthropic聊天模型1",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
-5552,
1264
],
"parameters": {},
"typeVersion": 1.3
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[
{
"node": "Sort3",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing4",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Sort",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing1",
"type": "main",
"index": 0
}
]
]
},
"If2": {
"main": [
[
{
"node": "Limit1",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing2",
"type": "main",
"index": 0
}
]
]
},
"If3": {
"main": [
[
{
"node": "Sort1",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Sort": {
"main": [
[
{
"node": "Limit2",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
},
{
"node": "research about company",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Time Zone",
"type": "main",
"index": 0
}
]
]
},
"Sort1": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Sort2": {
"main": [
[
{
"node": "If2",
"type": "main",
"index": 0
}
]
]
},
"Sort3": {
"main": [
[
{
"node": "Limit4",
"type": "main",
"index": 0
}
]
]
},
"Text1": {
"main": [
[
{
"node": "Scraper agent",
"type": "main",
"index": 0
}
]
]
},
"Wait1": {
"main": [
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Wait7": {
"main": [
[
{
"node": "Loop Over Items7",
"type": "main",
"index": 0
}
]
]
},
"Wait8": {
"main": [
[
{
"node": "Loop Over Items8",
"type": "main",
"index": 0
}
]
]
},
"Limit1": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"Limit2": {
"main": [
[
{
"node": "Switch5",
"type": "main",
"index": 0
}
]
]
},
"Limit3": {
"main": [
[
{
"node": "Confirmation message",
"type": "main",
"index": 0
}
]
]
},
"Limit4": {
"main": [
[
{
"node": "Switch6",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items1",
"type": "main",
"index": 0
}
]
]
},
"Wait10": {
"main": [
[
{
"node": "Loop Over Items10",
"type": "main",
"index": 0
}
]
]
},
"Wait11": {
"main": [
[
{
"node": "Loop Over Items11",
"type": "main",
"index": 0
}
]
]
},
"Mailgun": {
"main": [
[
{
"node": "Wait1",
"type": "main",
"index": 0
}
]
]
},
"Switch5": {
"main": [
[
{
"node": "Loop Over Items7",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items10",
"type": "main",
"index": 0
}
]
]
},
"Switch6": {
"main": [
[
{
"node": "Loop Over Items8",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items11",
"type": "main",
"index": 0
}
]
]
},
"Mailgun1": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Mailgun6": {
"main": [
[
{
"node": "Wait10",
"type": "main",
"index": 0
}
]
]
},
"Mailgun7": {
"main": [
[
{
"node": "Wait7",
"type": "main",
"index": 0
}
]
]
},
"Mailgun8": {
"main": [
[
{
"node": "Wait11",
"type": "main",
"index": 0
}
]
]
},
"Mailgun9": {
"main": [
[
{
"node": "Wait8",
"type": "main",
"index": 0
}
]
]
},
"Supabase2": {
"main": [
[
{
"node": "Sort2",
"type": "main",
"index": 0
}
]
]
},
"Time Zone": {
"main": [
[
{
"node": "Sender Email",
"type": "main",
"index": 0
}
]
]
},
"Create URL": {
"main": [
[
{
"node": "Run an Actor",
"type": "main",
"index": 0
}
]
]
},
"Supabase11": {
"main": [
[
{
"node": "Evualute when the mail was sent",
"type": "main",
"index": 0
}
]
]
},
"Supabase13": {
"main": [
[
{
"node": "Evualute when the mail was sent1",
"type": "main",
"index": 0
}
]
]
},
"Transcribe1": {
"main": [
[
{
"node": "Scraper agent",
"type": "main",
"index": 0
}
]
]
},
"Extract Info": {
"main": [
[
{
"node": "Only Keep Verified Emails ",
"type": "main",
"index": 0
}
]
]
},
"Run an Actor": {
"main": [
[
{
"node": "Extract Info",
"type": "main",
"index": 0
}
]
]
},
"Sender Email": {
"main": [
[
{
"node": "Your leads table",
"type": "main",
"index": 0
}
]
]
},
"User message": {
"main": [
[
{
"node": "Voice or Text1",
"type": "main",
"index": 0
}
]
]
},
"Get a message": {
"main": [
[
{
"node": "Professional Email Response Agent",
"type": "main",
"index": 0
}
]
]
},
"Get many rows": {
"main": [
[
{
"node": "If3",
"type": "main",
"index": 0
}
]
]
},
"Gmail Trigger": {
"main": [
[
{
"node": "extract email",
"type": "main",
"index": 0
}
]
]
},
"Scraper agent": {
"main": [
[
{
"node": "Generate query payload",
"type": "main",
"index": 0
},
{
"node": "Select already scraped mails",
"type": "main",
"index": 0
}
]
]
},
"Simple Memory": {
"ai_memory": [
[
{
"node": "Scraper agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"extract email": {
"main": [
[
{
"node": "Execute a SQL query",
"type": "main",
"index": 0
}
]
]
},
"Download File1": {
"main": [
[
{
"node": "Transcribe1",
"type": "main",
"index": 0
}
]
]
},
"Voice or Text1": {
"main": [
[
{
"node": "Download File1",
"type": "main",
"index": 0
}
],
[
{
"node": "Text1",
"type": "main",
"index": 0
}
]
]
},
"General anlysis": {
"main": [
[
{
"node": "create email sequence",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "Supabase3",
"type": "main",
"index": 0
}
],
[
{
"node": "Mailgun1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items1": {
"main": [
[
{
"node": "Supabase4",
"type": "main",
"index": 0
}
],
[
{
"node": "Mailgun",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items7": {
"main": [
[
{
"node": "Supabase12",
"type": "main",
"index": 0
}
],
[
{
"node": "Mailgun7",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items8": {
"main": [
[
{
"node": "Supabase15",
"type": "main",
"index": 0
}
],
[
{
"node": "Mailgun9",
"type": "main",
"index": 0
}
]
]
},
"Get Email History": {
"ai_tool": [
[
{
"node": "Professional Email Response Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"Loop Over Items10": {
"main": [
[
{
"node": "Supabase14",
"type": "main",
"index": 0
}
],
[
{
"node": "Mailgun6",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items11": {
"main": [
[
{
"node": "Supabase16",
"type": "main",
"index": 0
}
],
[
{
"node": "Mailgun8",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "create email sequence",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Supabase2",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger3": {
"main": [
[
{
"node": "Get many rows",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger4": {
"main": [
[
{
"node": "Supabase11",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger6": {
"main": [
[
{
"node": "Supabase13",
"type": "main",
"index": 0
}
]
]
},
"Check Sent History": {
"ai_tool": [
[
{
"node": "Professional Email Response Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Scraper agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Set replied = Yes ": {
"main": [
[
{
"node": "Get a message",
"type": "main",
"index": 0
}
]
]
},
"Execute a SQL query": {
"main": [
[
{
"node": "Only from email campaigns",
"type": "main",
"index": 0
}
]
]
},
"Set Telegram message": {
"main": [
[
{
"node": "Limit3",
"type": "main",
"index": 0
}
]
]
},
"Anthropic Chat Model1": {
"ai_languageModel": [
[
{
"node": "Professional Email Response Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Email Response Parser": {
"ai_outputParser": [
[
{
"node": "Professional Email Response Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"create email sequence": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Generate query payload": {
"main": [
[
{
"node": "Create URL",
"type": "main",
"index": 0
}
]
]
},
"research about company": {
"main": [
[
{
"node": "General anlysis",
"type": "main",
"index": 0
}
]
]
},
"Keep only the new leads": {
"main": [
[
{
"node": "Already scraped",
"type": "main",
"index": 0
}
],
[
{
"node": "Already scraped",
"type": "main",
"index": 0
}
],
[
{
"node": "Already scraped",
"type": "main",
"index": 0
}
],
[
{
"node": "Create rows with new leads",
"type": "main",
"index": 0
}
]
]
},
"Only from email campaigns": {
"main": [
[
{
"node": "Set replied = Yes ",
"type": "main",
"index": 0
}
]
]
},
"Structured Output Parser1": {
"ai_outputParser": [
[
{
"node": "Scraper agent",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Create rows with new leads": {
"main": [
[
{
"node": "Set Telegram message",
"type": "main",
"index": 0
}
]
]
},
"Only Keep Verified Emails ": {
"main": [
[
{
"node": "Keep only the new leads",
"type": "main",
"index": 1
}
]
]
},
"Select already scraped mails": {
"main": [
[
{
"node": "Keep only the new leads",
"type": "main",
"index": 0
}
]
]
},
"Evualute when the mail was sent": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Evualute when the mail was sent1": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Professional Email Response Agent": {
"main": [
[
{
"node": "Create Draft Response",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Content Creation、Multimodal AI等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
GPT-4驱动的冷邮件工作流，包含完全定制的3封邮件跟进
使用GPT-4、Mailgun和Supabase自动化个性化冷邮件序列
If
Set
Code
+22
100 节点Paul
Lead Nurturing
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
使用Apollo、GPT-4和Telegram的AI驱动潜在客户生成至数据库
基于AI的潜在客户生成：使用Apollo、GPT-4和Telegram输出到数据库
Set
Code
Limit
+15
26 节点Paul
Lead Generation
使用GPT-5和fal.ai图像从关键词到WordPress自动化SEO博客流程
使用GPT-5和fal.ai图像从关键词到WordPress自动化SEO博客流程
Set
Code
Wait
+20
96 节点Paul
Content Creation
使用Perplexity和GPT为WordPress创建SEO优化博客，包含关键词和媒体
使用Perplexity和GPT为WordPress创建SEO优化博客，包含关键词和媒体
Set
Code
Limit
+22
124 节点Paul
Content Creation
使用特定工具为WordPress创建SEO优化博客
使用特定工具为WordPress创建SEO优化博客
Set
Code
Limit
+22
124 节点Paul
Content Creation
工作流信息
难度等级
高级
节点数量116
分类2
节点类型29
作者
Paul
@diagoplAutomation expert & n8n power user. I build advanced workflows combining AI, outbound, and business logic. Grab my templates or reach out for custom builds.
外部链接
在 n8n.io 上查看 →
分享此工作流