Módulo de robot WA - Cita - v1 - Base de datos - Ventas - Versión completa
Este es unSales, Support, Marketingflujo de automatización del dominio deautomatización que contiene 49 nodos.Utiliza principalmente nodos como If, Set, Merge, Switch, Postgres. Citas de clientes automatizadas a través de Telegram y PostgreSQL (módulo "Citas")
- •Información de conexión de la base de datos PostgreSQL
Nodos utilizados (49)
{
"id": "AJTY10KEqzGWzQ8p",
"meta": {
"instanceId": "888b5b52ac2aa3f8f1bab6800cae8fce6f3d7947e840e64245b5198449908655"
},
"name": "WA-Bot-Module-Booking-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": "49db5bb8-bcae-44c1-a215-5d8d1c125f5e",
"name": "Nota Adhesiva10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b7d46289-6bfd-4639-acb9-951969bd88e7",
"name": "Nota Adhesiva11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3c4778a1-6806-442d-a50a-de0e87089169",
"name": "Nota Adhesiva6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1800,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6c2acf36-0c01-4984-ac42-662f4f6ea072",
"name": "Actualizar Nombre",
"type": "n8n-nodes-base.postgres",
"position": [
2300,
1240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "2ac3bcd1-a090-48fd-a133-ffd1c7c6b889",
"name": "Actualizar Hora",
"type": "n8n-nodes-base.postgres",
"position": [
2300,
640
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "ee24c24c-5083-49bd-8e0c-cfee8ef6c760",
"name": "Obtener Horas Laborales",
"type": "n8n-nodes-base.postgres",
"position": [
2740,
240
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "8d602e70-38e7-4639-9cec-b45e4ac46c68",
"name": "Obtener Días Laborales",
"type": "n8n-nodes-base.postgres",
"position": [
1860,
-20
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "32910627-3e1f-45dd-a4ec-63132762215c",
"name": "Actualizar estado del bot en START",
"type": "n8n-nodes-base.postgres",
"position": [
1860,
-280
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "d1a8ef06-6507-4e90-8f97-0d28f3abe94a",
"name": "¿Es correcta la fecha?",
"type": "n8n-nodes-base.if",
"position": [
2060,
-20
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "22fa9829-ef33-4a20-a6c9-a03442c0dbab",
"name": "Comandos",
"type": "n8n-nodes-base.switch",
"position": [
1360,
-80
],
"parameters": {},
"retryOnFail": false,
"typeVersion": 3.2
},
{
"id": "fca9aaf7-53cb-4c5d-91d2-2cb1a8591c2f",
"name": "Nota Adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "62ea839f-f934-4862-8709-a08d1a9d5e5c",
"name": "Inicios",
"type": "n8n-nodes-base.whatsApp",
"position": [
860,
-280
],
"webhookId": "aa26d2a0-99da-4d11-8504-89acaafbb0c5",
"parameters": {},
"typeVersion": 1
},
{
"id": "946b34a4-b9b4-4dc0-884c-d897f4f0987b",
"name": "Obtener Estado del Bot",
"type": "n8n-nodes-base.postgres",
"position": [
860,
-80
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "491739c5-8dff-489a-9565-02fc4f5edf7e",
"name": "Upsert Estado del Bot en START",
"type": "n8n-nodes-base.postgres",
"position": [
1080,
-280
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "33d1bfa8-a7f1-4d28-8178-765436763a25",
"name": "WhatsApp Trigger",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
420,
-80
],
"webhookId": "8defa4ea-11c0-4ab9-9228-0bef6ffd00ad",
"parameters": {},
"typeVersion": 1
},
{
"id": "8e174865-d332-4e16-a0a0-25723635de87",
"name": "Definir Flujo",
"type": "n8n-nodes-base.switch",
"position": [
1080,
-80
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "d6bc1318-df4c-4ef6-b830-66540720df6a",
"name": "Inicialización",
"type": "n8n-nodes-base.set",
"position": [
640,
-80
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "ec733a20-b9f0-4039-8514-8217ca491b9b",
"name": "Obtener Reserva",
"type": "n8n-nodes-base.postgres",
"position": [
1360,
640
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "d98b2950-df1f-4fc1-b18c-2290b7bf621e",
"name": "Menú Principal",
"type": "n8n-nodes-base.whatsApp",
"position": [
1640,
-80
],
"webhookId": "41c4e076-3618-44f5-bf0e-96ace7b28fb0",
"parameters": {},
"typeVersion": 1
},
{
"id": "bd5ebe69-cd98-4c2c-8a5b-ea8114a4a5a4",
"name": "Solicitar Fecha",
"type": "n8n-nodes-base.whatsApp",
"position": [
2740,
-20
],
"webhookId": "03f0e01e-8493-40c0-b4dc-5c1b79006757",
"parameters": {},
"typeVersion": 1
},
{
"id": "f36f3c9d-4bd6-409d-b7af-9d96b5c03075",
"name": "Unir Número con Pregunta",
"type": "n8n-nodes-base.set",
"position": [
2300,
-20
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "c8e08639-5b3c-4552-af2e-b0ad0d6c89f3",
"name": "Unir Lista",
"type": "n8n-nodes-base.summarize",
"position": [
2520,
-20
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "c2c75379-cec2-43c4-88c4-bc63bd1cde1e",
"name": "Actualizar estado del bot en BOOKING",
"type": "n8n-nodes-base.postgres",
"position": [
2960,
-20
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "fca3d8b1-b320-41ed-9b42-c236679e1e6a",
"name": "¿Primera Pregunta?",
"type": "n8n-nodes-base.if",
"position": [
1860,
240
],
"parameters": {},
"executeOnce": false,
"typeVersion": 2.2
},
{
"id": "553efef6-2dd3-40c1-86ca-df2c513dd3bf",
"name": "Obtener Días Laborales",
"type": "n8n-nodes-base.postgres",
"position": [
2060,
420
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "fa7159a9-57fd-4f35-8c53-9fde5289a23e",
"name": "Agregar Reserva",
"type": "n8n-nodes-base.postgres",
"position": [
2060,
240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "85885381-f773-4f8d-8b68-241822d8cd05",
"name": "Combinar1",
"type": "n8n-nodes-base.merge",
"position": [
2300,
240
],
"parameters": {},
"executeOnce": false,
"typeVersion": 3
},
{
"id": "ad5bed52-c4c1-4e52-8321-e0ba884ca77d",
"name": "Unir Número con Pregunta1",
"type": "n8n-nodes-base.set",
"position": [
2960,
240
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "7a58c044-0d1f-470b-894b-5e0f994f9b5c",
"name": "Unir Lista1",
"type": "n8n-nodes-base.summarize",
"position": [
3180,
240
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "7c7298b5-7f78-40e0-ab66-4966bf56e9ee",
"name": "Combinar",
"type": "n8n-nodes-base.merge",
"position": [
1640,
440
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "e227110c-53de-443b-ad3d-1a8157f80938",
"name": "Editar Campos",
"type": "n8n-nodes-base.set",
"position": [
1360,
440
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "9795ad35-d291-4e82-b2ee-0f898843a535",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
2060,
640
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "de7099bd-e95f-4c09-b4a2-a0e8708f86b1",
"name": "Actualizar Fecha Y Estado",
"type": "n8n-nodes-base.postgres",
"position": [
2520,
240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "f7c5056a-c6b7-4c61-a0f1-d116754a70aa",
"name": "Validación de Teléfono1",
"type": "n8n-nodes-base.if",
"position": [
2300,
840
],
"parameters": {},
"executeOnce": false,
"typeVersion": 2.2
},
{
"id": "f8a30b0c-9b25-433c-8da1-30b25af14c34",
"name": "Solicitar Teléfono",
"type": "n8n-nodes-base.whatsApp",
"position": [
2740,
640
],
"webhookId": "b1232b40-8742-48b3-b117-db915f25cf58",
"parameters": {},
"typeVersion": 1
},
{
"id": "8173128a-5c21-40c0-a394-abe62b3b30b8",
"name": "Solicitar Nombre",
"type": "n8n-nodes-base.whatsApp",
"position": [
2740,
840
],
"webhookId": "0ba29b47-cbb5-4d87-9813-a5778291c943",
"parameters": {},
"executeOnce": true,
"typeVersion": 1
},
{
"id": "7b392a56-df82-43fb-9fa3-a7acb1df79e8",
"name": "Error de Teléfono",
"type": "n8n-nodes-base.whatsApp",
"position": [
2740,
1040
],
"webhookId": "ae89b4aa-8718-4030-b75d-fc65911f7953",
"parameters": {},
"typeVersion": 1
},
{
"id": "1deb7b7c-07df-414a-ba7d-c421e15ce979",
"name": "página de reserva exitosa",
"type": "n8n-nodes-base.whatsApp",
"position": [
2740,
1240
],
"webhookId": "610074a5-5439-4662-8080-408cceb93796",
"parameters": {},
"typeVersion": 1
},
{
"id": "d07a6f69-2c2f-4655-8d3a-8b93c25ef911",
"name": "Actualizar estado en BOOKED",
"type": "n8n-nodes-base.postgres",
"position": [
2960,
1240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "d994f535-8b42-4ea5-8466-98ecd0988b0e",
"name": "Actualizar Teléfono",
"type": "n8n-nodes-base.postgres",
"position": [
2520,
840
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "4913b0e5-ff41-40d0-adc8-5593d2ae7614",
"name": "Pagos",
"type": "n8n-nodes-base.whatsApp",
"position": [
1640,
-280
],
"webhookId": "4248cc84-3c81-4fc4-a65c-a71281595da8",
"parameters": {},
"typeVersion": 1
},
{
"id": "5219aa55-5017-4182-bc1a-7f65a6229ac9",
"name": "Actualizar estado del bot en PAYMENTS",
"type": "n8n-nodes-base.postgres",
"position": [
3180,
1240
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "3a9dd518-b8a1-4503-b6bb-5345bf14ab75",
"name": "Nota Adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "76705120-761e-45f2-b027-028ba9a88875",
"name": "Nota Adhesiva8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "146316c0-6f31-4701-a3ba-63ddd87e741b",
"name": "Solicitar Hora",
"type": "n8n-nodes-base.whatsApp",
"position": [
3400,
240
],
"webhookId": "e89c3c22-f3cf-483c-9ad9-c58149c19b18",
"parameters": {},
"typeVersion": 1
},
{
"id": "d14141f8-5f5c-4f08-9e45-72831e44a01a",
"name": "Nota Adhesiva12",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3bd6b336-c195-4aa2-adea-7176222ab22a",
"name": "Nota Adhesiva13",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "717ed12c-9495-4ed9-9b81-e89f254bb38c",
"name": "Nota Adhesiva14",
"type": "n8n-nodes-base.stickyNote",
"position": [
-20,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a15078a1-f6be-4dcd-b0f8-1eb43a22bdab",
"name": "Nota Adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"timezone": "Asia/Almaty",
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1"
},
"versionId": "e32a293f-ae93-4c83-ad8d-5c9e685c75a8",
"connections": {
"7c7298b5-7f78-40e0-ab66-4966bf56e9ee": {
"main": [
[
{
"node": "fca3d8b1-b320-41ed-9b42-c236679e1e6a",
"type": "main",
"index": 0
}
]
]
},
"85885381-f773-4f8d-8b68-241822d8cd05": {
"main": [
[
{
"node": "de7099bd-e95f-4c09-b4a2-a0e8708f86b1",
"type": "main",
"index": 0
}
]
]
},
"62ea839f-f934-4862-8709-a08d1a9d5e5c": {
"main": [
[
{
"node": "491739c5-8dff-489a-9565-02fc4f5edf7e",
"type": "main",
"index": 0
}
]
]
},
"9795ad35-d291-4e82-b2ee-0f898843a535": {
"main": [
[
{
"node": "2ac3bcd1-a090-48fd-a133-ffd1c7c6b889",
"type": "main",
"index": 0
}
],
[
{
"node": "f7c5056a-c6b7-4c61-a0f1-d116754a70aa",
"type": "main",
"index": 0
}
],
[
{
"node": "6c2acf36-0c01-4984-ac42-662f4f6ea072",
"type": "main",
"index": 0
}
]
]
},
"fa7159a9-57fd-4f35-8c53-9fde5289a23e": {
"main": [
[
{
"node": "85885381-f773-4f8d-8b68-241822d8cd05",
"type": "main",
"index": 1
}
]
]
},
"22fa9829-ef33-4a20-a6c9-a03442c0dbab": {
"main": [
[
{
"node": "d98b2950-df1f-4fc1-b18c-2290b7bf621e",
"type": "main",
"index": 0
}
],
[
{
"node": "553efef6-2dd3-40c1-86ca-df2c513dd3bf",
"type": "main",
"index": 0
}
]
]
},
"ec733a20-b9f0-4039-8514-8217ca491b9b": {
"main": [
[
{
"node": "7c7298b5-7f78-40e0-ab66-4966bf56e9ee",
"type": "main",
"index": 1
}
]
]
},
"4913b0e5-ff41-40d0-adc8-5593d2ae7614": {
"main": [
[
{
"node": "32910627-3e1f-45dd-a4ec-63132762215c",
"type": "main",
"index": 0
}
]
]
},
"d98b2950-df1f-4fc1-b18c-2290b7bf621e": {
"main": [
[
{
"node": "32910627-3e1f-45dd-a4ec-63132762215c",
"type": "main",
"index": 0
}
]
]
},
"c8e08639-5b3c-4552-af2e-b0ad0d6c89f3": {
"main": [
[
{
"node": "bd5ebe69-cd98-4c2c-8a5b-ea8114a4a5a4",
"type": "main",
"index": 0
}
]
]
},
"8e174865-d332-4e16-a0a0-25723635de87": {
"main": [
[
{
"node": "62ea839f-f934-4862-8709-a08d1a9d5e5c",
"type": "main",
"index": 0
}
],
[
{
"node": "22fa9829-ef33-4a20-a6c9-a03442c0dbab",
"type": "main",
"index": 0
}
],
[
{
"node": "ec733a20-b9f0-4039-8514-8217ca491b9b",
"type": "main",
"index": 0
},
{
"node": "e227110c-53de-443b-ad3d-1a8157f80938",
"type": "main",
"index": 0
}
],
[
{
"node": "4913b0e5-ff41-40d0-adc8-5593d2ae7614",
"type": "main",
"index": 0
}
]
]
},
"e227110c-53de-443b-ad3d-1a8157f80938": {
"main": [
[
{
"node": "7c7298b5-7f78-40e0-ab66-4966bf56e9ee",
"type": "main",
"index": 0
}
]
]
},
"7a58c044-0d1f-470b-894b-5e0f994f9b5c": {
"main": [
[
{
"node": "146316c0-6f31-4701-a3ba-63ddd87e741b",
"type": "main",
"index": 0
}
]
]
},
"2ac3bcd1-a090-48fd-a133-ffd1c7c6b889": {
"main": [
[
{
"node": "f8a30b0c-9b25-433c-8da1-30b25af14c34",
"type": "main",
"index": 0
}
]
]
},
"6c2acf36-0c01-4984-ac42-662f4f6ea072": {
"main": [
[
{
"node": "1deb7b7c-07df-414a-ba7d-c421e15ce979",
"type": "main",
"index": 0
}
]
]
},
"bd5ebe69-cd98-4c2c-8a5b-ea8114a4a5a4": {
"main": [
[
{
"node": "c2c75379-cec2-43c4-88c4-bc63bd1cde1e",
"type": "main",
"index": 0
}
]
]
},
"d994f535-8b42-4ea5-8466-98ecd0988b0e": {
"main": [
[
{
"node": "8173128a-5c21-40c0-a394-abe62b3b30b8",
"type": "main",
"index": 0
}
]
]
},
"553efef6-2dd3-40c1-86ca-df2c513dd3bf": {
"main": [
[
{
"node": "85885381-f773-4f8d-8b68-241822d8cd05",
"type": "main",
"index": 2
}
]
]
},
"946b34a4-b9b4-4dc0-884c-d897f4f0987b": {
"main": [
[
{
"node": "8e174865-d332-4e16-a0a0-25723635de87",
"type": "main",
"index": 0
}
]
]
},
"ee24c24c-5083-49bd-8e0c-cfee8ef6c760": {
"main": [
[
{
"node": "ad5bed52-c4c1-4e52-8321-e0ba884ca77d",
"type": "main",
"index": 0
}
]
]
},
"d6bc1318-df4c-4ef6-b830-66540720df6a": {
"main": [
[
{
"node": "946b34a4-b9b4-4dc0-884c-d897f4f0987b",
"type": "main",
"index": 0
}
]
]
},
"fca3d8b1-b320-41ed-9b42-c236679e1e6a": {
"main": [
[
{
"node": "fa7159a9-57fd-4f35-8c53-9fde5289a23e",
"type": "main",
"index": 0
},
{
"node": "553efef6-2dd3-40c1-86ca-df2c513dd3bf",
"type": "main",
"index": 0
},
{
"node": "85885381-f773-4f8d-8b68-241822d8cd05",
"type": "main",
"index": 0
}
],
[
{
"node": "9795ad35-d291-4e82-b2ee-0f898843a535",
"type": "main",
"index": 0
}
]
]
},
"d1a8ef06-6507-4e90-8f97-0d28f3abe94a": {
"main": [
[
{
"node": "f36f3c9d-4bd6-409d-b7af-9d96b5c03075",
"type": "main",
"index": 0
}
]
]
},
"33d1bfa8-a7f1-4d28-8178-765436763a25": {
"main": [
[
{
"node": "d6bc1318-df4c-4ef6-b830-66540720df6a",
"type": "main",
"index": 0
}
]
]
},
"f7c5056a-c6b7-4c61-a0f1-d116754a70aa": {
"main": [
[
{
"node": "d994f535-8b42-4ea5-8466-98ecd0988b0e",
"type": "main",
"index": 0
}
],
[
{
"node": "7b392a56-df82-43fb-9fa3-a7acb1df79e8",
"type": "main",
"index": 0
}
]
]
},
"1deb7b7c-07df-414a-ba7d-c421e15ce979": {
"main": [
[
{
"node": "d07a6f69-2c2f-4655-8d3a-8b93c25ef911",
"type": "main",
"index": 0
}
]
]
},
"de7099bd-e95f-4c09-b4a2-a0e8708f86b1": {
"main": [
[
{
"node": "ee24c24c-5083-49bd-8e0c-cfee8ef6c760",
"type": "main",
"index": 0
}
]
]
},
"d07a6f69-2c2f-4655-8d3a-8b93c25ef911": {
"main": [
[
{
"node": "5219aa55-5017-4182-bc1a-7f65a6229ac9",
"type": "main",
"index": 0
}
]
]
},
"f36f3c9d-4bd6-409d-b7af-9d96b5c03075": {
"main": [
[
{
"node": "c8e08639-5b3c-4552-af2e-b0ad0d6c89f3",
"type": "main",
"index": 0
}
]
]
},
"ad5bed52-c4c1-4e52-8321-e0ba884ca77d": {
"main": [
[
{
"node": "7a58c044-0d1f-470b-894b-5e0f994f9b5c",
"type": "main",
"index": 0
}
]
]
},
"5219aa55-5017-4182-bc1a-7f65a6229ac9": {
"main": [
[
{
"node": "4913b0e5-ff41-40d0-adc8-5593d2ae7614",
"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?
Avanzado - Ventas, Soporte, 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
Compartir este flujo de trabajo