Módulo de robot de WA - Prueba - v1 - Base de datos de ventas completa
Avanzado
Este es unSales, Marketingflujo de automatización del dominio deautomatización que contiene 39 nodos.Utiliza principalmente nodos como If, Set, Sort, Switch, Postgres. Automatización de cuestionarios y clasificación de resultados de WhatsApp con PostgreSQL ("Módulo de cuestionario")
Requisitos previos
- •Información de conexión de la base de datos PostgreSQL
Nodos utilizados (39)
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
"id": "QTuJfyY6vm7iEIH6",
"meta": {
"instanceId": "888b5b52ac2aa3f8f1bab6800cae8fce6f3d7947e840e64245b5198449908655",
"templateCredsSetupCompleted": true
},
"name": "WA-Bot-Module-Quiz-v1-db-sell-full",
"tags": [
{
"id": "XPad0ERjSdqfxG52",
"name": "module",
"createdAt": "2025-03-31T08:11:00.151Z",
"updatedAt": "2025-03-31T08:11:00.151Z"
},
{
"id": "NeRMkUNq0sRVlL99",
"name": "whatsapp",
"createdAt": "2025-03-10T18:20:40.864Z",
"updatedAt": "2025-03-10T18:20:40.864Z"
},
{
"id": "2ocrWSzdKoCOU2AC",
"name": "sell",
"createdAt": "2025-04-19T15:39:51.859Z",
"updatedAt": "2025-04-19T15:39:51.859Z"
}
],
"nodes": [
{
"id": "6eb96949-f6bc-4044-b0cf-7bac329ce722",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "42f5adf9-8663-44f7-a2da-20631d01dc0f",
"name": "Nota adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2e406d54-a333-4767-a1bb-e2c61d60c5b6",
"name": "Inicia",
"type": "n8n-nodes-base.whatsApp",
"position": [
480,
560
],
"webhookId": "c9e66b18-77be-4d85-94f5-11824c2ce53c",
"parameters": {},
"typeVersion": 1
},
{
"id": "7d6e48cb-6154-48a5-97c5-aef2bfcffc58",
"name": "Obtener estado del bot",
"type": "n8n-nodes-base.postgres",
"position": [
480,
760
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "a998e1fe-c919-4b61-a051-17afa7f14c0e",
"name": "Nota adhesiva5",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ed48b30-5737-4d84-bceb-a8046c950fe6",
"name": "Comandos",
"type": "n8n-nodes-base.switch",
"position": [
980,
760
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "0039047d-110f-4726-a29d-2d1035e924ec",
"name": "Menú principal",
"type": "n8n-nodes-base.whatsApp",
"position": [
1260,
560
],
"webhookId": "4ab7201b-786d-4004-96ec-e0a4c7105ed1",
"parameters": {},
"typeVersion": 1
},
{
"id": "53c8427c-a23d-4818-a2d5-f8ad3cd78816",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
2960,
940
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "743ef248-8f5c-444b-91c9-07249ae98540",
"name": "Definir flujo",
"type": "n8n-nodes-base.switch",
"position": [
700,
760
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "68ae7054-369d-4b61-ad76-eeba27d8fc98",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1220,
740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "988f33f4-a8d9-44d9-ac2c-3ad00c64217f",
"name": "Upsert estado del bot en START",
"type": "n8n-nodes-base.postgres",
"position": [
700,
560
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "719d9e1d-61e1-44de-8cfc-bc28b8e5f53c",
"name": "Inicialización",
"type": "n8n-nodes-base.set",
"position": [
240,
760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2908320f-4f14-4d9a-9896-72b4187f8217",
"name": "Actualizar estado del bot en START",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
560
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "ef1d9288-56f0-41ce-81a3-c3452e6ac86a",
"name": "Actualizar estado del bot en TEST",
"type": "n8n-nodes-base.postgres",
"position": [
3020,
960
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "a42629ec-0966-4e63-b863-a0f541003171",
"name": "Aleatorizar preguntas",
"type": "n8n-nodes-base.sort",
"position": [
2360,
960
],
"parameters": {},
"executeOnce": false,
"typeVersion": 1
},
{
"id": "08429844-5483-44d7-8a5c-4e9e0f6f120e",
"name": "¿Hay preguntas?",
"type": "n8n-nodes-base.if",
"position": [
2140,
1160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c2fe1635-6536-4895-9842-a815eb7902aa",
"name": "Actualizar respuesta",
"type": "n8n-nodes-base.postgres",
"position": [
1700,
1160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "ea2fe4f7-1cd3-41a8-a1b1-1fe94e416a5f",
"name": "Obtener preguntas no respondidas",
"type": "n8n-nodes-base.postgres",
"position": [
1920,
1160
],
"parameters": {},
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "3000d5c8-a99c-4d1d-b6ff-a49ec1ea73c2",
"name": "Obtener tests",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
760
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "118fe642-e11f-4f1d-ab38-34f9b4b3e329",
"name": "Unir número con pregunta",
"type": "n8n-nodes-base.set",
"position": [
1700,
760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "aa592693-5434-44e8-8e90-00887b261b1f",
"name": "Unir lista",
"type": "n8n-nodes-base.summarize",
"position": [
1920,
760
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "fcac55cc-3ce0-4f2c-8d36-605927fce0fb",
"name": "Calcular respuestas",
"type": "n8n-nodes-base.postgres",
"position": [
2360,
1160
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "c03e0632-74ea-471a-a0d4-7f754d062db4",
"name": "WhatsApp Disparador",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
20,
760
],
"webhookId": "314e7a55-d4ca-4514-9d28-0b41c7d64945",
"parameters": {},
"typeVersion": 1
},
{
"id": "726f6b67-542f-4a11-aa48-e1427be1074e",
"name": "Listar tests",
"type": "n8n-nodes-base.whatsApp",
"position": [
2140,
760
],
"webhookId": "d7d17714-5fe6-4d42-82a0-23590e4cf957",
"parameters": {},
"typeVersion": 1
},
{
"id": "c365a231-8572-4a40-8c07-21000690e9af",
"name": "¿Listar?",
"type": "n8n-nodes-base.if",
"position": [
1260,
760
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "94d08401-dc68-4979-b94e-600e79000679",
"name": "Obtener test",
"type": "n8n-nodes-base.postgres",
"position": [
1700,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"name": "Obtener tests",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "66608e4e-2771-4210-aee8-f1fcb3453cef",
"name": "Test",
"type": "n8n-nodes-base.whatsApp",
"position": [
1920,
960
],
"webhookId": "0e07e27a-bce0-4c89-8b7a-afad148361ca",
"parameters": {},
"typeVersion": 1
},
{
"id": "3e36fbcd-fbe7-4343-8eb7-2ee0c2bac223",
"name": "Obtener preguntas Y respuestas",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "78efdb33-a094-4a36-98f8-30de68292d4c",
"name": "Upsert respuesta pred",
"type": "n8n-nodes-base.postgres",
"position": [
2580,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "6ff36dd2-b8b0-4f45-997a-7d098f9eb56f",
"name": "Solicitar respuesta",
"type": "n8n-nodes-base.whatsApp",
"position": [
2800,
960
],
"webhookId": "4e533cdd-57de-43b6-8b24-36b93013fb01",
"parameters": {},
"typeVersion": 1
},
{
"id": "75937466-26c4-424b-ae46-54890d044c12",
"name": "Obtener respuesta",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
1160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "9638190f-351e-40ee-8708-20231701c650",
"name": "Resultado",
"type": "n8n-nodes-base.whatsApp",
"position": [
2580,
1160
],
"webhookId": "5869922e-9e0e-4482-9637-21e753689c22",
"parameters": {},
"typeVersion": 1
},
{
"id": "65c40000-24b8-4317-a3f8-99cf8618b508",
"name": "Obtener variantes de pregunta",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
1160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "a082da78-ab1a-4e61-8d6b-cb24ffb3ed9d",
"name": "Actualizar estado del bot en START",
"type": "n8n-nodes-base.postgres",
"position": [
2800,
1160
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "1ea5577a-5ac6-4884-9ec3-f20bc17c33e4",
"name": "Nota adhesiva7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0cc3c717-85c3-4cb0-8526-4f4e6b6a54dd",
"name": "Nota adhesiva8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "08ed150c-151c-42f9-9f72-cf46b2791011",
"name": "Nota adhesiva9",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f31fa5b3-0c9d-4479-8026-70fc779ed579",
"name": "Nota adhesiva6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ddae069a-aa64-4421-9090-01171c60d0d0",
"connections": {
"66608e4e-2771-4210-aee8-f1fcb3453cef": {
"main": [
[
{
"node": "3e36fbcd-fbe7-4343-8eb7-2ee0c2bac223",
"type": "main",
"index": 0
}
]
]
},
"c365a231-8572-4a40-8c07-21000690e9af": {
"main": [
[
{
"node": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"type": "main",
"index": 0
}
],
[
{
"node": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"type": "main",
"index": 0
}
]
]
},
"9638190f-351e-40ee-8708-20231701c650": {
"main": [
[
{
"node": "a082da78-ab1a-4e61-8d6b-cb24ffb3ed9d",
"type": "main",
"index": 0
}
]
]
},
"2e406d54-a333-4767-a1bb-e2c61d60c5b6": {
"main": [
[
{
"node": "988f33f4-a8d9-44d9-ac2c-3ad00c64217f",
"type": "main",
"index": 0
}
]
]
},
"2ed48b30-5737-4d84-bceb-a8046c950fe6": {
"main": [
[
{
"node": "0039047d-110f-4726-a29d-2d1035e924ec",
"type": "main",
"index": 0
}
],
[
{
"node": "c365a231-8572-4a40-8c07-21000690e9af",
"type": "main",
"index": 0
}
]
]
},
"94d08401-dc68-4979-b94e-600e79000679": {
"main": [
[
{
"node": "66608e4e-2771-4210-aee8-f1fcb3453cef",
"type": "main",
"index": 0
}
]
]
},
"ff451553-cae3-450d-8f0c-ae4a89f146d8": {
"main": [
[
{
"node": "94d08401-dc68-4979-b94e-600e79000679",
"type": "main",
"index": 0
}
]
]
},
"0039047d-110f-4726-a29d-2d1035e924ec": {
"main": [
[
{
"node": "a082da78-ab1a-4e61-8d6b-cb24ffb3ed9d",
"type": "main",
"index": 0
}
]
]
},
"75937466-26c4-424b-ae46-54890d044c12": {
"main": [
[
{
"node": "65c40000-24b8-4317-a3f8-99cf8618b508",
"type": "main",
"index": 0
}
]
]
},
"aa592693-5434-44e8-8e90-00887b261b1f": {
"main": [
[
{
"node": "726f6b67-542f-4a11-aa48-e1427be1074e",
"type": "main",
"index": 0
}
]
]
},
"743ef248-8f5c-444b-91c9-07249ae98540": {
"main": [
[
{
"node": "2e406d54-a333-4767-a1bb-e2c61d60c5b6",
"type": "main",
"index": 0
}
],
[
{
"node": "2ed48b30-5737-4d84-bceb-a8046c950fe6",
"type": "main",
"index": 0
}
],
[
{
"node": "75937466-26c4-424b-ae46-54890d044c12",
"type": "main",
"index": 0
}
]
]
},
"c2fe1635-6536-4895-9842-a815eb7902aa": {
"main": [
[
{
"node": "ea2fe4f7-1cd3-41a8-a1b1-1fe94e416a5f",
"type": "main",
"index": 0
}
]
]
},
"08429844-5483-44d7-8a5c-4e9e0f6f120e": {
"main": [
[
{
"node": "a42629ec-0966-4e63-b863-a0f541003171",
"type": "main",
"index": 0
}
],
[
{
"node": "fcac55cc-3ce0-4f2c-8d36-605927fce0fb",
"type": "main",
"index": 0
}
]
]
},
"7d6e48cb-6154-48a5-97c5-aef2bfcffc58": {
"main": [
[
{
"node": "743ef248-8f5c-444b-91c9-07249ae98540",
"type": "main",
"index": 0
}
]
]
},
"719d9e1d-61e1-44de-8cfc-bc28b8e5f53c": {
"main": [
[
{
"node": "7d6e48cb-6154-48a5-97c5-aef2bfcffc58",
"type": "main",
"index": 0
}
]
]
},
"6ff36dd2-b8b0-4f45-997a-7d098f9eb56f": {
"main": [
[
{
"node": "ef1d9288-56f0-41ce-81a3-c3452e6ac86a",
"type": "main",
"index": 0
}
]
]
},
"c03e0632-74ea-471a-a0d4-7f754d062db4": {
"main": [
[
{
"node": "719d9e1d-61e1-44de-8cfc-bc28b8e5f53c",
"type": "main",
"index": 0
}
]
]
},
"fcac55cc-3ce0-4f2c-8d36-605927fce0fb": {
"main": [
[
{
"node": "9638190f-351e-40ee-8708-20231701c650",
"type": "main",
"index": 0
}
]
]
},
"78efdb33-a094-4a36-98f8-30de68292d4c": {
"main": [
[
{
"node": "6ff36dd2-b8b0-4f45-997a-7d098f9eb56f",
"type": "main",
"index": 0
}
]
]
},
"a42629ec-0966-4e63-b863-a0f541003171": {
"main": [
[
{
"node": "78efdb33-a094-4a36-98f8-30de68292d4c",
"type": "main",
"index": 0
}
]
]
},
"65c40000-24b8-4317-a3f8-99cf8618b508": {
"main": [
[
{
"node": "c2fe1635-6536-4895-9842-a815eb7902aa",
"type": "main",
"index": 0
}
]
]
},
"3e36fbcd-fbe7-4343-8eb7-2ee0c2bac223": {
"main": [
[
{
"node": "a42629ec-0966-4e63-b863-a0f541003171",
"type": "main",
"index": 0
}
]
]
},
"ea2fe4f7-1cd3-41a8-a1b1-1fe94e416a5f": {
"main": [
[
{
"node": "08429844-5483-44d7-8a5c-4e9e0f6f120e",
"type": "main",
"index": 0
}
]
]
},
"118fe642-e11f-4f1d-ab38-34f9b4b3e329": {
"main": [
[
{
"node": "aa592693-5434-44e8-8e90-00887b261b1f",
"type": "main",
"index": 0
}
]
]
}
}
}Preguntas frecuentes
¿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?
Avanzado - Ventas, Marketing
¿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
Módulo de robot WA - Cita - v1 - Base de datos - Ventas - Versión completa
Citas de clientes automatizadas a través de Telegram y PostgreSQL (módulo "Citas")
If
Set
Merge
+
If
Set
Merge
49 NodosAndrew
Ventas
TG-Bot-Module-Quiz-v4-db-sell-full
Automatizar pruebas y recopilación de respuestas en Postgres a través de Telegram (módulo "Encuestas")
If
Set
Code
+
If
Set
Code
36 NodosAndrew
Ventas
WA-robot-module-survey-v1-database-sales-full-version
Recolección de respuestas a encuestas de WhatsApp en Postgres (módulo "Anketa")
If
Set
Switch
+
If
Set
Switch
32 NodosAndrew
Ventas
TG-Bot-Module-Cross-Platform-Publishing-v1-Database-Sell-Full
Automatizar publicaciones en canales de Telegram usando Postgres (módulo "Publicación multiplataforma")
If
Set
Switch
+
If
Set
Switch
47 NodosAndrew
Ventas
Agente de ventas multiplataforma automatizado
Agente de ventas multiplataforma usando RAG, CRM y procesamiento de pagos
If
Set
Switch
+
If
Set
Switch
83 NodosElectrabot
Ventas
Enriquecer datos de vendedores mediante búsqueda por correo electrónico y dominio con Bright Data y Google Search
usoBright DatayGooglebúsquedaa través de邮箱y域名查找丰富卖家datos
If
Set
Code
+
If
Set
Code
32 NodosCyril Nicko Gaspar
Ventas
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos39
Categoría2
Tipos de nodos9
Descripción de la dificultad
Autor
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo