TG-Bot-Module-Cross-Platform-Publishing-v1-Database-Sell-Full
Este es unSales, Building Blocks, Marketingflujo de automatización del dominio deautomatización que contiene 47 nodos.Utiliza principalmente nodos como If, Set, Switch, Postgres, Telegram. Automatizar publicaciones en canales de Telegram usando Postgres (módulo "Publicación multiplataforma")
- •Información de conexión de la base de datos PostgreSQL
- •Bot Token de Telegram
Nodos utilizados (47)
{
"id": "3m4RmGRaROTWw0HS",
"meta": {
"instanceId": "888b5b52ac2aa3f8f1bab6800cae8fce6f3d7947e840e64245b5198449908655",
"templateCredsSetupCompleted": true
},
"name": "TG-Bot-Module-Cross_Posting-v1-db-sell-full",
"tags": [
{
"id": "EwFGeL3ePPNgm0R7",
"name": "telegram",
"createdAt": "2025-02-10T18:10:47.435Z",
"updatedAt": "2025-02-10T18:10:47.435Z"
},
{
"id": "XPad0ERjSdqfxG52",
"name": "module",
"createdAt": "2025-03-31T08:11:00.151Z",
"updatedAt": "2025-03-31T08:11:00.151Z"
},
{
"id": "2ocrWSzdKoCOU2AC",
"name": "sell",
"createdAt": "2025-04-19T15:39:51.859Z",
"updatedAt": "2025-04-19T15:39:51.859Z"
}
],
"nodes": [
{
"id": "a7bca41e-ffae-4fbb-99ed-1326834ddd5d",
"name": "Variables TG",
"type": "n8n-nodes-base.set",
"position": [
80,
-140
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "61767f36-0f76-4a96-ab15-56aa3bc37881",
"name": "Inicialización",
"type": "n8n-nodes-base.set",
"position": [
320,
-140
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "0b89e490-8518-471b-aa8c-f097a28ff83d",
"name": "Telegram Disparador",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-140,
-140
],
"webhookId": "562c7311-5b7c-4a45-b743-04a46d760873",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "0bc07dff-a624-4c29-8327-0b7bff57c150",
"name": "Seleccionar Canales",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
-140
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "1c902af0-1f96-46c0-94db-ece5b937955d",
"name": "¿Es Administrador?",
"type": "n8n-nodes-base.if",
"position": [
540,
-140
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "de2d68d1-1c60-4ac6-916d-38a9ea334320",
"name": "Agregar Canal",
"type": "n8n-nodes-base.postgres",
"onError": "continueErrorOutput",
"position": [
1480,
-740
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "cdae9e24-c42f-4f2d-ae30-2c7940031490",
"name": "Obtener Estado del Bot",
"type": "n8n-nodes-base.postgres",
"position": [
760,
-340
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "2cd05fd6-b798-4017-8e36-88fd83143f50",
"name": "Definir flujo",
"type": "n8n-nodes-base.switch",
"position": [
980,
-460
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": false
},
{
"id": "f335a4e1-aa19-4122-abcb-fa2a660c7cdf",
"name": "Comandos",
"type": "n8n-nodes-base.switch",
"position": [
1260,
-1220
],
"parameters": {},
"retryOnFail": false,
"typeVersion": 3.2
},
{
"id": "6682aef5-5b37-4b48-babf-556e582d7101",
"name": "Canal Existe",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-740
],
"webhookId": "2fa81265-abbd-46bb-8f15-51cd9605376f",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7a36302d-4a37-49e2-82d6-7e2bcb6f38d2",
"name": "Solicitar Agregar Canal",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-1540
],
"webhookId": "57fa4033-f28c-4224-86a3-75df85cf87e5",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "c72ed6b3-8d6b-4b48-a97a-7dad06d18682",
"name": "Solicitar Eliminar Canal",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-1340
],
"webhookId": "ac025c14-b675-42c2-b9c1-12f924066114",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "2757870e-e7fe-4c7c-9fe6-97cc56155ec4",
"name": "Solicitar Nueva Eliminación de Canal",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-540
],
"webhookId": "d7cde909-a6a9-4c36-95cb-39fe1f33a76e",
"parameters": {},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "e93c1544-670d-4334-a32f-cde3fb323b33",
"name": "Solicitar Nuevo Agregar Canal",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-940
],
"webhookId": "1f6f57f4-bfca-47f9-9877-627b6a7e3738",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6ee36bc2-8cf2-41ee-a7f6-5e1b49c7ea4f",
"name": "Canal No Existe",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-340
],
"webhookId": "925adc00-3c0a-4f02-bdd3-28546097d3c5",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "83fcaa57-ed1b-4aa7-99e3-f81d7226e4d3",
"name": "Eliminar Canal",
"type": "n8n-nodes-base.postgres",
"onError": "continueRegularOutput",
"position": [
1480,
-540
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "e8f24107-14db-4b04-8c4e-84e3cc78ab7e",
"name": "Obtener Canales",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
-1140
],
"parameters": {},
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "ef44ee6a-b8e3-4919-a8ec-048744444b45",
"name": "Agregar Dividir Canales",
"type": "n8n-nodes-base.summarize",
"position": [
1700,
-1140
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "427f077c-fe69-4b33-867b-657dd60fea18",
"name": "Canales",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-1140
],
"webhookId": "c95be6d1-ed84-48c2-8f69-48c1ac652710",
"parameters": {},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "d660dfa0-a708-45ba-ad02-a3984015a2c6",
"name": "Definir Tipo",
"type": "n8n-nodes-base.switch",
"position": [
540,
-380
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "3a9175c0-ed95-44ff-bd31-ff8413d88d3b",
"name": "Obtener Canales",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
-340
],
"parameters": {},
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "13e83abd-4baf-4ab7-b07b-85120bda8939",
"name": "Si",
"type": "n8n-nodes-base.if",
"position": [
1480,
-340
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "b89da002-4ddc-4518-8211-ebf0ad69f197",
"name": "Upsert estado del bot en INICIO",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1740
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "d216d87f-6669-4d79-bee1-9798b1e89eb2",
"name": "Botones",
"type": "n8n-nodes-base.switch",
"position": [
980,
-1940
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": false
},
{
"id": "fea2d8b6-4d06-4c06-96e1-cf9649bad22e",
"name": "Actualizar estado del bot en AGREGAR CANAL",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1540
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "a27124ca-3270-4fb3-87a6-6a9cacd5a0a0",
"name": "Actualizar estado del bot en ELIMINAR CANAL",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1340
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "13d55ebf-5a73-4a02-9ec2-94fb223b2a46",
"name": "Publicación Enviada con Éxito",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-140
],
"webhookId": "2b427835-021b-4641-9967-541579d14013",
"parameters": {},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "1ed13ae9-6aff-4b5a-8350-115ba6f7d067",
"name": "Actualizar estado del bot en INICIO",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
-140
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "e5f6c9fa-a040-4f5f-afaf-f6a961d45179",
"name": "Mensaje de Bienvenida",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-1740
],
"webhookId": "984e7085-9223-46ca-b1c3-336bc3f576fd",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "2fcc98fc-a040-4687-ba65-3ce4a633b287",
"name": "Actualizar estado del bot en SOLICITUD DE TEXTO DE PUBLICACIÓN",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1940
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "76242590-48c7-4c30-b022-5c116ae10d9c",
"name": "Solicitar Texto de Publicación",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-1940
],
"webhookId": "113a42b1-9b96-4756-99fd-7fe90e73859b",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "5fc877af-d50e-4125-a880-deaa77b5dc34",
"name": "Solicitar Texto de Imagen de Publicación",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
-2140
],
"webhookId": "d47f6817-462c-474b-80ac-77c24fda0057",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "7ffa1597-50a0-4cb6-bedf-f364fb3c6ac9",
"name": "Actualizar estado del bot en SOLICITUD DE TEXTO DE IMAGEN DE PUBLICACIÓN",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-2140
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "4515b82a-e42f-4c36-a808-831702862d0e",
"name": "Actualizar estado del bot en SOLICITUD DE IMAGEN DE IMAGEN DE PUBLICACIÓN",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
60
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "cd08a0b8-1af2-4a16-8859-33408fa41f0d",
"name": "Seleccionar Canales",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
260
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "0b778c0a-0966-4bef-8300-0b50fb608131",
"name": "Solicitar Imagen de Publicación de Imagen",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
60
],
"webhookId": "1be72d6c-af3d-4426-b665-607bc48321e9",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "d3edced1-3957-49ab-a844-e1b5d267a3fb",
"name": "Publicación de Imagen Enviada con Éxito",
"type": "n8n-nodes-base.telegram",
"position": [
2140,
260
],
"webhookId": "1add9ac7-b8c8-41a9-86d1-488cd656087e",
"parameters": {},
"executeOnce": true,
"typeVersion": 1.2
},
{
"id": "ce28cb11-8ffe-490d-9ec0-0a22c4556172",
"name": "Actualizar estado del bot en INICIO",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
260
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "ff3156da-186e-4799-91fc-19707648112a",
"name": "Si1",
"type": "n8n-nodes-base.if",
"position": [
1700,
260
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "4b4d39fb-ff75-47cf-ac6d-f4e655568bf7",
"name": "Enviar Publicaciones (4922)",
"type": "n8n-nodes-base.telegram",
"position": [
1700,
-140
],
"webhookId": "4a35dabe-a97c-4338-b023-bc5afa2001ee",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "91146a01-ffe7-4df1-8929-5158623c91f0",
"name": "Enviar Publicaciones de Imagen (4922)",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
260
],
"webhookId": "993e2cf3-0b82-4015-9841-8795636f2b86",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "6f13b321-742c-467e-957f-d3e69cd43c2c",
"name": "Enviar Publicaciones de Imagen (4922)",
"type": "n8n-nodes-base.telegram",
"position": [
1920,
460
],
"webhookId": "4d0c8d50-036e-497c-b009-22c5c840754f",
"parameters": {},
"typeVersion": 1.2
},
{
"id": "14b56b60-90ab-4acc-8641-b3ef0a7a1014",
"name": "Nota Adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-180,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6a100ae0-0f27-4620-9df7-3b7d122b8020",
"name": "Nota Adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-420
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36cae884-0392-4ab9-96e2-9b00fdd3c7a5",
"name": "Nota Adhesiva5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2b56999f-cacc-49d0-9f1a-6c5f8bb22cc3",
"name": "Nota Adhesiva6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c8df3d2c-cb65-46e3-b905-8405684ddafd",
"name": "Upsert estado del bot en INICIO",
"type": "n8n-nodes-base.postgres",
"position": [
1920,
-2320
],
"parameters": {},
"typeVersion": 2.5
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "744c1004-cb2f-4097-80be-76a6768db0f6",
"connections": {
"13e83abd-4baf-4ab7-b07b-85120bda8939": {
"main": [
[
{
"node": "83fcaa57-ed1b-4aa7-99e3-f81d7226e4d3",
"type": "main",
"index": 0
}
],
[
{
"node": "6ee36bc2-8cf2-41ee-a7f6-5e1b49c7ea4f",
"type": "main",
"index": 0
}
]
]
},
"ff3156da-186e-4799-91fc-19707648112a": {
"main": [
[
{
"node": "6f13b321-742c-467e-957f-d3e69cd43c2c",
"type": "main",
"index": 0
}
],
[
{
"node": "6f13b321-742c-467e-957f-d3e69cd43c2c",
"type": "main",
"index": 0
}
]
]
},
"d216d87f-6669-4d79-bee1-9798b1e89eb2": {
"main": [
[
{
"node": "c8df3d2c-cb65-46e3-b905-8405684ddafd",
"type": "main",
"index": 0
}
],
[
{
"node": "5fc877af-d50e-4125-a880-deaa77b5dc34",
"type": "main",
"index": 0
}
],
[
{
"node": "76242590-48c7-4c30-b022-5c116ae10d9c",
"type": "main",
"index": 0
}
]
]
},
"f335a4e1-aa19-4122-abcb-fa2a660c7cdf": {
"main": [
[],
[
{
"node": "e5f6c9fa-a040-4f5f-afaf-f6a961d45179",
"type": "main",
"index": 0
}
],
[
{
"node": "7a36302d-4a37-49e2-82d6-7e2bcb6f38d2",
"type": "main",
"index": 0
}
],
[
{
"node": "c72ed6b3-8d6b-4b48-a97a-7dad06d18682",
"type": "main",
"index": 0
}
],
[
{
"node": "3a9175c0-ed95-44ff-bd31-ff8413d88d3b",
"type": "main",
"index": 0
}
]
]
},
"1c902af0-1f96-46c0-94db-ece5b937955d": {
"main": [
[
{
"node": "d660dfa0-a708-45ba-ad02-a3984015a2c6",
"type": "main",
"index": 0
}
]
]
},
"de2d68d1-1c60-4ac6-916d-38a9ea334320": {
"main": [
[
{
"node": "e93c1544-670d-4334-a32f-cde3fb323b33",
"type": "main",
"index": 0
}
],
[
{
"node": "6682aef5-5b37-4b48-babf-556e582d7101",
"type": "main",
"index": 0
}
]
]
},
"d660dfa0-a708-45ba-ad02-a3984015a2c6": {
"main": [
[
{
"node": "cdae9e24-c42f-4f2d-ae30-2c7940031490",
"type": "main",
"index": 0
}
],
[
{
"node": "d216d87f-6669-4d79-bee1-9798b1e89eb2",
"type": "main",
"index": 0
}
],
[],
[
{
"node": "cdae9e24-c42f-4f2d-ae30-2c7940031490",
"type": "main",
"index": 0
}
]
]
},
"2cd05fd6-b798-4017-8e36-88fd83143f50": {
"main": [
[
{
"node": "f335a4e1-aa19-4122-abcb-fa2a660c7cdf",
"type": "main",
"index": 0
}
],
[
{
"node": "de2d68d1-1c60-4ac6-916d-38a9ea334320",
"type": "main",
"index": 0
}
],
[
{
"node": "3a9175c0-ed95-44ff-bd31-ff8413d88d3b",
"type": "main",
"index": 0
}
],
[
{
"node": "ce28cb11-8ffe-490d-9ec0-0a22c4556172",
"type": "main",
"index": 0
}
],
[
{
"node": "4515b82a-e42f-4c36-a808-831702862d0e",
"type": "main",
"index": 0
}
],
[
{
"node": "ce28cb11-8ffe-490d-9ec0-0a22c4556172",
"type": "main",
"index": 0
}
]
]
},
"a7bca41e-ffae-4fbb-99ed-1326834ddd5d": {
"main": [
[
{
"node": "61767f36-0f76-4a96-ab15-56aa3bc37881",
"type": "main",
"index": 0
}
]
]
},
"3a9175c0-ed95-44ff-bd31-ff8413d88d3b": {
"main": [
[
{
"node": "13e83abd-4baf-4ab7-b07b-85120bda8939",
"type": "main",
"index": 0
}
]
]
},
"83fcaa57-ed1b-4aa7-99e3-f81d7226e4d3": {
"main": [
[
{
"node": "2757870e-e7fe-4c7c-9fe6-97cc56155ec4",
"type": "main",
"index": 0
}
]
]
},
"cdae9e24-c42f-4f2d-ae30-2c7940031490": {
"main": [
[
{
"node": "2cd05fd6-b798-4017-8e36-88fd83143f50",
"type": "main",
"index": 0
}
]
]
},
"61767f36-0f76-4a96-ab15-56aa3bc37881": {
"main": [
[
{
"node": "1c902af0-1f96-46c0-94db-ece5b937955d",
"type": "main",
"index": 0
}
]
]
},
"cd08a0b8-1af2-4a16-8859-33408fa41f0d": {
"main": [
[
{
"node": "ff3156da-186e-4799-91fc-19707648112a",
"type": "main",
"index": 0
}
]
]
},
"e5f6c9fa-a040-4f5f-afaf-f6a961d45179": {
"main": [
[
{
"node": "c8df3d2c-cb65-46e3-b905-8405684ddafd",
"type": "main",
"index": 0
}
]
]
},
"0b89e490-8518-471b-aa8c-f097a28ff83d": {
"main": [
[
{
"node": "a7bca41e-ffae-4fbb-99ed-1326834ddd5d",
"type": "main",
"index": 0
}
]
]
},
"76242590-48c7-4c30-b022-5c116ae10d9c": {
"main": [
[
{
"node": "2fcc98fc-a040-4687-ba65-3ce4a633b287",
"type": "main",
"index": 0
}
]
]
},
"4b4d39fb-ff75-47cf-ac6d-f4e655568bf7": {
"main": [
[
{
"node": "13d55ebf-5a73-4a02-9ec2-94fb223b2a46",
"type": "main",
"index": 0
}
]
]
},
"ef44ee6a-b8e3-4919-a8ec-048744444b45": {
"main": [
[
{
"node": "427f077c-fe69-4b33-867b-657dd60fea18",
"type": "main",
"index": 0
}
]
]
},
"7a36302d-4a37-49e2-82d6-7e2bcb6f38d2": {
"main": [
[
{
"node": "fea2d8b6-4d06-4c06-96e1-cf9649bad22e",
"type": "main",
"index": 0
}
]
]
},
"c72ed6b3-8d6b-4b48-a97a-7dad06d18682": {
"main": [
[
{
"node": "a27124ca-3270-4fb3-87a6-6a9cacd5a0a0",
"type": "main",
"index": 0
}
]
]
},
"5fc877af-d50e-4125-a880-deaa77b5dc34": {
"main": [
[
{
"node": "7ffa1597-50a0-4cb6-bedf-f364fb3c6ac9",
"type": "main",
"index": 0
}
]
]
},
"6f13b321-742c-467e-957f-d3e69cd43c2c": {
"main": [
[
{
"node": "d3edced1-3957-49ab-a844-e1b5d267a3fb",
"type": "main",
"index": 0
}
]
]
},
"ce28cb11-8ffe-490d-9ec0-0a22c4556172": {
"main": [
[
{
"node": "cd08a0b8-1af2-4a16-8859-33408fa41f0d",
"type": "main",
"index": 0
}
]
]
},
"4515b82a-e42f-4c36-a808-831702862d0e": {
"main": [
[
{
"node": "0b778c0a-0966-4bef-8300-0b50fb608131",
"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, Bloques de construcción, 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