8
n8n 中文网amn8n.com

使用语音通话 (VAPI) 和 Google Sheets 自动化 B2B 潜在客户资格认证

中级

这是一个Lead Generation, AI Chatbot领域的自动化工作流，包含 10 个节点。主要使用 Webhook, HttpRequest, GoogleSheets, RespondToWebhook, GoogleSheetsTrigger 等节点。 B2B 潜在客户资格认证

前置要求
  • •HTTP Webhook 端点（n8n 会自动生成）
  • •可能需要目标 API 的认证凭证
  • •Google Sheets API 凭证

使用的节点 (10)

Webhook
StickyNote
HttpRequest
GoogleSheets
RespondToWebhook
GoogleSheetsTrigger

分类

潜在客户开发
AI 聊天机器人
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "3TgB8gjUez1uQjJw",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "使用语音通话 (VAPI) 和 Google Sheets 自动化 B2B 潜在客户资格认证",
  "tags": [],
  "nodes": [
    {
      "id": "b99be5b1-f4a6-4d0f-af0d-4d2464be11c1",
      "name": "捕获新潜在客户",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -320,
        -580
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1562885128,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o/edit#gid=1562885128",
          "cachedResultName": "phone_number"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o/edit?usp=drivesdk",
          "cachedResultName": "Outter calls list"
        }
      },
      "credentials": {
        "googleSheetsTriggerOAuth2Api": {
          "id": "BoDTTv5L67GVL3Fi",
          "name": "Google Sheets  - test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e6efc842-fbb5-4d0d-949f-0b08a2612255",
      "name": "发起语音通话 (VAPI)",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        120,
        -580
      ],
      "parameters": {
        "url": "https://api.vapi.ai/call",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n  \"assistantId\": \"add_id_here\",\n  \"phoneNumberId\": \"add_phone_number_id_here\",\n  \"customers\": [\n    {\n      \"number\": \"add_vapi_agent_phonenumber_here\"\n    }\n  ]\n}",
        "sendBody": true,
        "sendHeaders": true,
        "specifyBody": "json",
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "add_authorization_token_here"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "d8e5a345-a452-41ca-a7d1-e0d05a1fe565",
      "name": "将合格潜在客户保存到 CRM 表格",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -100,
        -320
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name ": "={{ $json.body.message.toolCallList[0].function.arguments.name }}",
            "Company name": "={{ $json.body.message.toolCallList[0].function.arguments.company_name }}",
            "Company size": "={{ $json.body.message.toolCallList[0].function.arguments.company_size }}"
          },
          "schema": [
            {
              "id": "Name ",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Name ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Company name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company size",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Company size",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Name "
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o/edit?usp=drivesdk",
          "cachedResultName": "Outter calls list"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "1b365b16-e3d3-41ee-99fd-e92d26de2b1e",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -380,
        -680
      ],
      "parameters": {
        "color": 3,
        "height": 260,
        "content": "在新电话号码输入时触发。"
      },
      "typeVersion": 1
    },
    {
      "id": "7843c35f-7957-4285-9726-8bd518065be6",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        60,
        -680
      ],
      "parameters": {
        "color": 4,
        "width": 220,
        "height": 260,
        "content": "通过 POST 捕获姓名、公司、挑战。"
      },
      "typeVersion": 1
    },
    {
      "id": "e32182b9-c2b4-4021-b618-cdf961062ce2",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        -400
      ],
      "parameters": {
        "color": 5,
        "width": 250,
        "height": 280,
        "content": "通过外呼对潜在客户进行资格认证。"
      },
      "typeVersion": 1
    },
    {
      "id": "00540380-6c9c-47a5-a322-5d823482f3e7",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        -400
      ],
      "parameters": {
        "height": 300,
        "content": "将数据存储在 Google Sheet 中。"
      },
      "typeVersion": 1
    },
    {
      "id": "beea0df6-d706-4b65-ae44-b78e11adb49a",
      "name": "便签说明4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        260,
        -400
      ],
      "parameters": {
        "color": 6,
        "width": 230,
        "height": 300,
        "content": "向 VAPI 确认成功。"
      },
      "typeVersion": 1
    },
    {
      "id": "0e5b636d-c8c4-4102-9c09-6a7373887e58",
      "name": "发送通话数据确认",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        320,
        -320
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "3fc02fbd-935c-4c24-aeb8-aac8b3f14efa",
      "name": "从 VAPI 接收潜在客户详情",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -460,
        -320
      ],
      "webhookId": "60d5fdeb-b5d8-4e71-90d0-182acc695404",
      "parameters": {
        "path": "60d5fdeb-b5d8-4e71-90d0-182acc695404",
        "options": {},
        "httpMethod": "POST",
        "responseMode": "responseNode"
      },
      "typeVersion": 2
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "timezone": "Asia/Kolkata",
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1"
  },
  "versionId": "efedae37-b126-49fe-a641-1ca005bd26a8",
  "connections": {
    "New Lead Captured": {
      "main": [
        [
          {
            "node": "Initiate Voice Call (VAPI)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Receive Lead Details from VAPI": {
      "main": [
        [
          {
            "node": "Save Qualified Lead to CRM Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Qualified Lead to CRM Sheet": {
      "main": [
        [
          {
            "node": "Send Call Data Acknowledgement",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景？

中级 - 潜在客户开发, AI 聊天机器人

需要付费吗？

本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。

相关工作流推荐

通过Excel和VAPI语音助手实现餐厅营销与预订自动化
使用Excel、VAPI语音助手和日历自动化餐厅营销与预订
Set
Code
Webhook
+7
11 节点Oneclick AI Squad
客户培育
通过AI潜在客户生成的智能房地产电子邮件和电话营销
使用Llama AI、VAPI呼叫和Gmail营销活动自动化房地产营销
Code
Wait
Gmail
+8
23 节点Oneclick AI Squad
客户培育
完整旅行电话管理系统 - 呼叫跟踪、行程预订与营销
使用Postgres、Google Sheets和语音API自动化旅行业务运营
Set
Webhook
Postgres
+5
16 节点Oneclick AI Squad
客户关系管理
航空公司常见问题解答机器人
使用GPT-4和问题分类自动化航空公司客户支持
If
Code
Merge
+4
27 节点Oneclick AI Squad
客服机器人
对话式旅行预订器：使用 AI 自动化航班和酒店预订
对话式旅行预订器：使用 GPT-3.5 自动化航班和酒店预订
Code
Open Ai
Switch
+5
21 节点Oneclick AI Squad
客服机器人
AI驱动的演讲者与场次推荐引擎
使用Claude AI和Google Sheets生成活动演讲者推荐
If
Code
Webhook
+5
20 节点Oneclick AI Squad
杂项
工作流信息
难度等级
中级
节点数量10
分类2
节点类型6
难度说明

适合有一定经验的用户，包含 6-15 个节点的中等复杂度工作流

作者
Oneclick AI Squad

Oneclick AI Squad

@oneclick-ai

The AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.

外部链接
在 n8n.io 查看 →

分享此工作流