Calificación automática de leads B2B mediante llamadas de voz (VAPI) y Google Sheets
Este es unLead Generation, AI Chatbotflujo de automatización del dominio deautomatización que contiene 10 nodos.Utiliza principalmente nodos como Webhook, HttpRequest, GoogleSheets, RespondToWebhook, GoogleSheetsTrigger. Calificación de prospectos B2B
- •Punto final de HTTP Webhook (n8n generará automáticamente)
- •Pueden requerirse credenciales de autenticación para la API de destino
- •Credenciales de API de Google Sheets
Nodos utilizados (10)
Categoría
{
"id": "3TgB8gjUez1uQjJw",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Automate B2B Lead Qualification with Voice Calls (VAPI) and Google Sheets",
"tags": [],
"nodes": [
{
"id": "b99be5b1-f4a6-4d0f-af0d-4d2464be11c1",
"name": "Nuevo Lead Capturado",
"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": "Iniciar Llamada de Voz (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": "Guardar Lead Calificado en Hoja 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": "Nota Adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
-680
],
"parameters": {
"color": 3,
"height": 260,
"content": "Triggers on new phone number entry."
},
"typeVersion": 1
},
{
"id": "7843c35f-7957-4285-9726-8bd518065be6",
"name": "Nota Adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
-680
],
"parameters": {
"color": 4,
"width": 220,
"height": 260,
"content": "Captures name, company, challenges via POST."
},
"typeVersion": 1
},
{
"id": "e32182b9-c2b4-4021-b618-cdf961062ce2",
"name": "Nota Adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-400
],
"parameters": {
"color": 5,
"width": 250,
"height": 280,
"content": "Qualifies lead with outbound call.\n"
},
"typeVersion": 1
},
{
"id": "00540380-6c9c-47a5-a322-5d823482f3e7",
"name": "Nota Adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-400
],
"parameters": {
"height": 300,
"content": "Stores data in Google Sheet.\n"
},
"typeVersion": 1
},
{
"id": "beea0df6-d706-4b65-ae44-b78e11adb49a",
"name": "Nota Adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
260,
-400
],
"parameters": {
"color": 6,
"width": 230,
"height": 300,
"content": "Confirms success to VAPI.\n"
},
"typeVersion": 1
},
{
"id": "0e5b636d-c8c4-4102-9c09-6a7373887e58",
"name": "Enviar Acuse de Recibo de Datos de Llamada",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
320,
-320
],
"parameters": {
"options": {}
},
"typeVersion": 1.2
},
{
"id": "3fc02fbd-935c-4c24-aeb8-aac8b3f14efa",
"name": "Recibir Detalles del Lead desde 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": {
"b99be5b1-f4a6-4d0f-af0d-4d2464be11c1": {
"main": [
[
{
"node": "e6efc842-fbb5-4d0d-949f-0b08a2612255",
"type": "main",
"index": 0
}
]
]
},
"3fc02fbd-935c-4c24-aeb8-aac8b3f14efa": {
"main": [
[
{
"node": "d8e5a345-a452-41ca-a7d1-e0d05a1fe565",
"type": "main",
"index": 0
}
]
]
},
"d8e5a345-a452-41ca-a7d1-e0d05a1fe565": {
"main": [
[
{
"node": "0e5b636d-c8c4-4102-9c09-6a7373887e58",
"type": "main",
"index": 0
}
]
]
}
}
}¿Cómo usar este flujo de trabajo?
Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.
¿En qué escenarios es adecuado este flujo de trabajo?
Intermedio - Generación de leads, Chatbot de IA
¿Es de pago?
Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.
Flujos de trabajo relacionados recomendados
Oneclick AI Squad
@oneclick-aiThe 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.
Compartir este flujo de trabajo