潜在客户生成系统（模板）
中级
这是一个Sales领域的自动化工作流，包含 7 个节点。主要使用 If, Set, Airtable, HttpRequest, ManualTrigger 等节点。 一键从Apollo获取合格潜在客户并保存到Airtable
前置要求
- •Airtable API Key
- •可能需要目标 API 的认证凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "EWIrJ8e9z7AijmTu",
"meta": {
"instanceId": "e8ec316b54e91908f34cbfdc330e5d1d5e97aa0ea8f7277c00d8a8a3892c9983",
"templateCredsSetupCompleted": true
},
"name": "潜在客户生成系统（模板）",
"tags": [],
"nodes": [
{
"id": "03eabaeb-ad13-4764-98de-183325e32cbd",
"name": "当点击\"测试工作流\"时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
160,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e7df072c-fba8-4dc2-94ce-ae20a135a633",
"name": "获取简报",
"type": "n8n-nodes-base.set",
"position": [
840,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ab7e33d5-986e-4fba-b4d0-bc47bcd1cf82",
"name": "first_name",
"type": "string",
"value": "={{ $json.first_name }}"
},
{
"id": "f29e8cf7-3cd0-4ffc-a071-96be9dd1da50",
"name": "last_name",
"type": "string",
"value": "={{ $json.last_name }}"
},
{
"id": "54ee5cec-ccaf-4f34-8030-d17206abef5d",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "daf1fa7c-a7fc-4b96-8184-a5569b9ab9a0",
"name": "email_status",
"type": "string",
"value": "={{ $json.email_status }}"
},
{
"id": "2c7e31e5-42a2-4295-ae8b-108d8a7d409a",
"name": "linkedin_url",
"type": "string",
"value": "={{ $json.linkedin_url }}"
},
{
"id": "4002f912-0581-4219-8443-96c13133dc76",
"name": "headline",
"type": "string",
"value": "={{ $json.headline }}"
},
{
"id": "fa92887f-fff5-4ee4-9b80-05115b83f718",
"name": "organization",
"type": "string",
"value": "={{ $json.organization_name }}"
},
{
"id": "c274e875-6a53-484a-87b1-3c672101603f",
"name": "organization_website",
"type": "string",
"value": "={{ $json.organization_website_url }}"
},
{
"id": "af6208a2-d064-471b-a417-7d96e9d05803",
"name": "organization_linkedin_url",
"type": "string",
"value": "={{ $json.organization_linkedin_url }}"
},
{
"id": "d61f2ddb-4c50-4548-8a7f-08261c60c429",
"name": "current_job_title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "838c77f2-618e-43b2-9df6-e5e1bde39105",
"name": "country",
"type": "string",
"value": "={{ $json.country }}"
},
{
"id": "9dc784cf-ae01-44e3-afed-16a95192bf71",
"name": "city",
"type": "string",
"value": "={{ $json.city }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3aaa9ea7-0c5d-4ea3-aa10-6cd0125ea91a",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
-280
],
"parameters": {
"color": 5,
"width": 1200,
"height": 520,
"content": "## 潜在客户生成"
},
"typeVersion": 1
},
{
"id": "42e3f6de-4ec4-46a7-a7f9-c028d27a677b",
"name": "抓取潜在客户",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
-80
],
"parameters": {
"url": "=",
"options": {},
"jsonBody": "{\n \"getPersonalEmails\": true,\n \"getWorkEmails\": true,\n \"totalRecords\": 500,\n \"url\": \"\"\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "dfd580f6-99b5-414a-b6f3-77c73edc85ec",
"name": "将潜在客户保存到数据库",
"type": "n8n-nodes-base.airtable",
"position": [
1040,
-80
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appy1hlfTk0UuYwRb",
"cachedResultUrl": "https://airtable.com/appy1hlfTk0UuYwRb",
"cachedResultName": "Lead Gen - Mastersheet"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl0rwfpUYkqMiysR",
"cachedResultUrl": "https://airtable.com/appy1hlfTk0UuYwRb/tbl0rwfpUYkqMiysR",
"cachedResultName": "Leads"
},
"columns": {
"value": {
"city": "={{ $json.city }}",
"country": "={{ $json.country }}",
"headline": "={{ $json.headline }}",
"last_name": "={{ $json.last_name }}",
"first_name": "={{ $json.first_name }}",
"email_status": "={{ $json.email_status }}",
"linkedin_url": "={{ $json.linkedin_url }}",
"email_address": "={{ $json.email }}",
"current_job_title": "={{ $json.current_job_title }}",
"organization_name": "={{ $json.organization }}",
"organization_website": "={{ $json.organization_website }}",
"organization_linkedin_url": "={{ $json.organization_linkedin_url }}"
},
"schema": [
{
"id": "email_address",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "email_address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "headline",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "headline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "organization_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization_website",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "organization_website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "organization_linkedin_url",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "organization_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "current_job_title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "current_job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_status",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "email_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "WKxw33bpSEDiQEaU",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "ff009ef3-c7da-460a-80e5-ba1330631c00",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-280
],
"parameters": {
"color": 3,
"width": 460,
"height": 180,
"content": "## 🚨 首先阅读 🚨"
},
"typeVersion": 1
},
{
"id": "0915cea5-746a-4dde-9208-885e08644ae2",
"name": "过滤无邮箱的潜在客户",
"type": "n8n-nodes-base.if",
"position": [
600,
-80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "231ec40a-bd12-46e2-ab6b-a8c4d6728983",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "f574ed33-bd0a-496b-865e-e6be2c1e3060",
"connections": {
"Edit Fields": {
"main": [
[
{
"node": "Save Leads in database",
"type": "main",
"index": 0
}
]
]
},
"Scrape Leads": {
"main": [
[
{
"node": "Filter leads without email",
"type": "main",
"index": 0
}
]
]
},
"Filter leads without email": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Scrape Leads",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 销售
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
搜索 LinkedIn 公司并将其添加到 Airtable CRM
搜索 LinkedIn 公司并将其添加到 Airtable CRM
If
Set
Airtable
+5
16 节点Matthieu
销售
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
If
Set
Code
+16
45 节点Sam Yassine
销售
高级销售AI代理
AI销售代理：WhatsApp、FB、IG、OpenAI、Airtable、Supabase自动预约
If
Set
Switch
+18
58 节点Sam Yassine
销售
WooCommerce服装目录的AI虚拟试穿
WooCommerce服装目录的AI虚拟试穿自动生成
If
Set
Wait
+7
21 节点Davide
销售
电话销售循环
AI驱动电话销售自动化，集成Vapi.ai、GPT-4o和Google Sheets
If
Set
Wait
+8
38 节点Amit Mehta
销售
废弃购物车恢复邮件自动化工作流
通过Gmail、Google表格和Twilio实现Shopify废弃购物车恢复（无代码）
If
Set
Wait
+10
60 节点Velebit from Innovatio
销售
工作流信息
难度等级
中级
节点数量7
分类1
节点类型6
作者
Not Another Marketer
@notanothermarketerBuilding Badass AI Agents for Marketing. Pre-made, ready-to-use, fully customizable.
外部链接
在 n8n.io 查看 →
分享此工作流