n8n-vapi潜在客户验证器最终版 V140525.8
高级
这是一个Sales, AI, Marketing领域的自动化工作流,包含 26 个节点。主要使用 If, Set, Code, Wait, Slack 等节点,结合人工智能技术实现智能自动化。 使用OpenAI、Twilio和Vapi自动化潜在客户呼叫AI助手
前置要求
- •Slack Bot Token 或 Webhook URL
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"id": "2S5igjYpOufVq1JG",
"meta": {
"instanceId": "0c91cd2a3133931f13781d4dcd6db321515413596b36e6bddb494176726841a7"
},
"name": "n8n-vapi-lead-verifier-final V140525.8",
"tags": [
{
"id": "a6b41kNUtX65uzIo",
"name": "tuguidragos.com",
"createdAt": "2025-05-14T18:52:56.055Z",
"updatedAt": "2025-05-14T18:52:56.055Z"
}
],
"nodes": [
{
"id": "5b5b34b0-3f13-4cfc-a840-8a8ccbb13675",
"name": "步骤 1 - 创建客户",
"type": "n8n-nodes-base.httpRequest",
"position": [
-480,
380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "7582ac6e-3889-4304-87f4-4ba441981e9f",
"name": "步骤 2 - 发起呼叫",
"type": "n8n-nodes-base.httpRequest",
"position": [
-300,
180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8878a9b9-5277-4e7b-b0c2-b4e8766306f2",
"name": "步骤 3 - 获取呼叫数据",
"type": "n8n-nodes-base.httpRequest",
"position": [
120,
620
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8a6d0f05-c980-4d72-979a-cad626977680",
"name": "步骤 4 - 设置(解析呼叫结果)",
"type": "n8n-nodes-base.set",
"position": [
320,
620
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2933b043-9652-4524-8183-9c8e6223597f",
"name": "步骤 5 - 如果(呼叫已接听?)",
"type": "n8n-nodes-base.if",
"position": [
500,
620
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "1dbc81ea-928e-4ed1-b6b9-8a865ed8e6fa",
"name": "步骤 5.2 - 通知 Slack(未接听)",
"type": "n8n-nodes-base.slack",
"position": [
1080,
460
],
"webhookId": "8f9d1ea8-de8c-42c0-92cd-da4b356c27bb",
"parameters": {},
"typeVersion": 2.3
},
{
"id": "40506826-48db-480e-ae93-2c66c5688d07",
"name": "步骤 5.1.1- 提取电子邮件(正则表达式)",
"type": "n8n-nodes-base.code",
"position": [
860,
780
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1f39c551-dd7c-4a72-b80d-946349f310ee",
"name": "步骤 5.1.3 - 通知 Slack(潜在客户成功)",
"type": "n8n-nodes-base.slack",
"position": [
1300,
780
],
"webhookId": "cd2bc6c7-3f50-47fb-9c84-e2743a355877",
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.3
},
{
"id": "6995a5c9-766d-4c90-bc41-8e0674af9369",
"name": "设置尝试次数 + 初始状态",
"type": "n8n-nodes-base.code",
"position": [
120,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "79867b7b-166f-4b5d-84f7-aac352868c3e",
"name": "从 VAPI 获取呼叫状态",
"type": "n8n-nodes-base.httpRequest",
"position": [
360,
180
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f4cecdc2-4ddc-420d-bb73-359095f03b72",
"name": "检查最终状态 + shouldContinue 逻辑",
"type": "n8n-nodes-base.code",
"position": [
560,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "3ebcf937-73ff-425d-bc2b-1da7d1210ee1",
"name": "准备循环负载",
"type": "n8n-nodes-base.set",
"position": [
1240,
160
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "431a2339-0353-4781-bc65-1ffbe7a780e1",
"name": "是否继续循环?",
"type": "n8n-nodes-base.if",
"position": [
760,
180
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c880979d-0342-4f39-ae01-d0a58341d744",
"name": "重试前等待",
"type": "n8n-nodes-base.wait",
"position": [
1060,
160
],
"webhookId": "25a8962b-38d1-4283-be7d-c7e6240e78e3",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "b69746b3-9939-4899-bb32-3430906597a8",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"content": "确保您的表名与实际知识库结构匹配"
},
"typeVersion": 1
},
{
"id": "a7ed8451-f066-492b-bf0f-405e9c27fd6b",
"name": "清理电话号码",
"type": "n8n-nodes-base.code",
"position": [
-640,
180
],
"parameters": {},
"typeVersion": 2
},
{
"id": "0f80b64d-73af-4af0-8d9e-cf709b6d55cb",
"name": "步骤 5.1 - 更新潜在客户(未接听)",
"type": "n8n-nodes-base.googleSheets",
"position": [
860,
460
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "f62ecc21-326c-4fc1-b201-4e05c6bcb23f",
"name": "步骤 5.1.2 - 更新潜在客户(已完成)",
"type": "n8n-nodes-base.googleSheets",
"position": [
1080,
780
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "7c861b96-832e-4fe1-a4a0-de39cf5b54a6",
"name": "筛选有效潜在客户",
"type": "n8n-nodes-base.code",
"position": [
-1060,
400
],
"parameters": {},
"typeVersion": 2
},
{
"id": "d96cc9e9-1310-4018-814f-e53f8d68b73e",
"name": "是否有要处理的潜在客户?",
"type": "n8n-nodes-base.if",
"position": [
-860,
400
],
"parameters": {},
"executeOnce": false,
"typeVersion": 2.2,
"alwaysOutputData": false
},
{
"id": "3b53b21d-0ca0-4660-862d-4d593519ee95",
"name": "Slack - 全部完成",
"type": "n8n-nodes-base.slack",
"position": [
-640,
620
],
"webhookId": "ea864253-cffd-4a16-8c58-8f6a79f20f84",
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.3
},
{
"id": "fb6f369d-2602-4e18-9895-224e9161146f",
"name": "同步更新的表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
800,
1040
],
"parameters": {},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "6ab553de-73bf-4924-8d08-95d93bf36be3",
"name": "加载潜在客户表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1240,
600
],
"parameters": {},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "3d41c6d4-8ff4-4767-8a3c-443fc328b7f1",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1420,
600
],
"parameters": {},
"typeVersion": 1
},
{
"id": "53326fbe-0529-434f-a2f8-a65c70681cc5",
"name": "循环设置变量",
"type": "n8n-nodes-base.set",
"position": [
-140,
400
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "02ed9c39-93bb-45b1-b6b7-0a7df8249da6",
"name": "表格刷新前等待",
"type": "n8n-nodes-base.wait",
"position": [
580,
1040
],
"webhookId": "3371d280-de4b-4c6f-b272-ff54f061ab27",
"parameters": {},
"executeOnce": false,
"typeVersion": 1.1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "252425b9-6480-4af9-9a96-2d52e07f7101",
"connections": {
"Manual Trigger": {
"main": [
[
{
"node": "Load Lead Sheet",
"type": "main",
"index": 0
}
]
]
},
"Load Lead Sheet": {
"main": [
[
{
"node": "Filter Valid Leads",
"type": "main",
"index": 0
}
]
]
},
"Wait Before Retry": {
"main": [
[
{
"node": "Prepare Loop Payload",
"type": "main",
"index": 0
}
]
]
},
"Clean Phone Number": {
"main": [
[
{
"node": "Step 1 - Create Customer",
"type": "main",
"index": 0
}
]
]
},
"Filter Valid Leads": {
"main": [
[
{
"node": "Has Leads to Process?",
"type": "main",
"index": 0
}
]
]
},
"Sync Updated Sheet": {
"main": [
[
{
"node": "Load Lead Sheet",
"type": "main",
"index": 0
}
]
]
},
"Loop Setup Variables": {
"main": [
[
{
"node": "Set Attempt Count + Init Status",
"type": "main",
"index": 0
}
]
]
},
"Prepare Loop Payload": {
"main": [
[
{
"node": "Set Attempt Count + Init Status",
"type": "main",
"index": 0
}
]
]
},
"Has Leads to Process?": {
"main": [
[
{
"node": "Clean Phone Number",
"type": "main",
"index": 0
}
],
[
{
"node": "Slack - All Done",
"type": "main",
"index": 0
}
]
]
},
"Should Continue Loop?": {
"main": [
[
{
"node": "Wait Before Retry",
"type": "main",
"index": 0
}
],
[
{
"node": "Step 3 - Get Call Data",
"type": "main",
"index": 0
}
]
]
},
"Step 2 - Initiate Call": {
"main": [
[
{
"node": "Loop Setup Variables",
"type": "main",
"index": 0
}
]
]
},
"Step 3 - Get Call Data": {
"main": [
[
{
"node": "Step 4 - Set (Parse Call Result)",
"type": "main",
"index": 0
}
]
]
},
"Step 1 - Create Customer": {
"main": [
[
{
"node": "Step 2 - Initiate Call",
"type": "main",
"index": 0
}
]
]
},
"Get Call Status from VAPI": {
"main": [
[
{
"node": "Check Final Status + shouldContinue Logic",
"type": "main",
"index": 0
}
]
]
},
"Wait Before Sheet Refresh": {
"main": [
[
{
"node": "Sync Updated Sheet",
"type": "main",
"index": 0
}
]
]
},
"Step 5 - If (Call Answered?)": {
"main": [
[
{
"node": "Wait Before Sheet Refresh",
"type": "main",
"index": 0
},
{
"node": "Step 5.1 - Update Lead (No Answer)",
"type": "main",
"index": 0
}
],
[
{
"node": "Step 5.1.1- Extract Email (Regex)",
"type": "main",
"index": 0
}
]
]
},
"Set Attempt Count + Init Status": {
"main": [
[
{
"node": "Get Call Status from VAPI",
"type": "main",
"index": 0
}
]
]
},
"Step 4 - Set (Parse Call Result)": {
"main": [
[
{
"node": "Step 5 - If (Call Answered?)",
"type": "main",
"index": 0
}
]
]
},
"Step 5.1.1- Extract Email (Regex)": {
"main": [
[
{
"node": "Step 5.1.2 - Update Lead (Completed)",
"type": "main",
"index": 0
}
]
]
},
"Step 5.1 - Update Lead (No Answer)": {
"main": [
[
{
"node": "Step 5.2 - Notify Slack (No Answer)",
"type": "main",
"index": 0
}
]
]
},
"Step 5.1.2 - Update Lead (Completed)": {
"main": [
[
{
"node": "Wait Before Sheet Refresh",
"type": "main",
"index": 0
},
{
"node": "Step 5.1.3 - Notify Slack (Lead Success)",
"type": "main",
"index": 0
}
]
]
},
"Check Final Status + shouldContinue Logic": {
"main": [
[
{
"node": "Should Continue Loop?",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
高级 - 销售, 人工智能, 营销
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
使用 OpenAI、Google Sheets、Jina AI 和 Slack 的 AI 驱动信息监控
基于AI的信息监控,集成OpenAI、Google Sheets、Jina AI和Slack
If
Set
Code
+10
31 节点Dataki
销售
使用Bright Data和LLMs自动化大规模超个性化外联
通过Bright Data和大语言模型实现大规模超个性化外联自动化
If
Set
Wait
+8
21 节点Yaron Been
销售
潜在客户研究员LinkedIn
自动化潜在客户研究 - 从LinkedIn到可发送报告
If
Set
Wait
+10
36 节点LukaszB
销售
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成(未完成)
If
Set
Code
+9
37 节点Matthieu
销售
搜索 LinkedIn 公司,通过 AI 评分并添加到 Google Sheet CRM
搜索 LinkedIn 公司,通过 AI 评分并添加到 Google Sheet CRM
If
Set
Wait
+7
18 节点Matthieu
销售
电话销售循环
AI驱动电话销售自动化,集成Vapi.ai、GPT-4o和Google Sheets
If
Set
Wait
+8
38 节点Amit Mehta
销售
工作流信息
难度等级
高级
节点数量26
分类3
节点类型9
作者
Țugui Dragoș
@tuguidragosI create no-code workflows that feel human, think smart, and close leads automatically.
外部链接
在 n8n.io 查看 →
分享此工作流