TG-Bot-Module-Cross-Platform-Publishing-v1-Database-Sell-Full-Version
Ceci est unSales, Building Blocks, Marketingworkflow d'automatisation du domainecontenant 47 nœuds.Utilise principalement des nœuds comme If, Set, Switch, Postgres, Telegram. Automatiser les publications de canaux Telegram avec Postgres (module "Publication multiplateforme")
- •Informations de connexion à la base de données PostgreSQL
- •Token Bot Telegram
Nœuds utilisés (47)
Catégorie
{
"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": "Initialisation",
"type": "n8n-nodes-base.set",
"position": [
320,
-140
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "0b89e490-8518-471b-aa8c-f097a28ff83d",
"name": "Telegram Déclencheur",
"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": "Sélectionner les chaînes",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
-140
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "1c902af0-1f96-46c0-94db-ece5b937955d",
"name": "Est administrateur ?",
"type": "n8n-nodes-base.if",
"position": [
540,
-140
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "de2d68d1-1c60-4ac6-916d-38a9ea334320",
"name": "Ajouter une chaîne",
"type": "n8n-nodes-base.postgres",
"onError": "continueErrorOutput",
"position": [
1480,
-740
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "cdae9e24-c42f-4f2d-ae30-2c7940031490",
"name": "Obtenir le statut du bot",
"type": "n8n-nodes-base.postgres",
"position": [
760,
-340
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "2cd05fd6-b798-4017-8e36-88fd83143f50",
"name": "Définir le flux",
"type": "n8n-nodes-base.switch",
"position": [
980,
-460
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": false
},
{
"id": "f335a4e1-aa19-4122-abcb-fa2a660c7cdf",
"name": "Commandes",
"type": "n8n-nodes-base.switch",
"position": [
1260,
-1220
],
"parameters": {},
"retryOnFail": false,
"typeVersion": 3.2
},
{
"id": "6682aef5-5b37-4b48-babf-556e582d7101",
"name": "La chaîne 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": "Demande d'ajout de chaîne",
"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": "Demande de suppression de chaîne",
"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": "Nouvelle demande de suppression de chaîne",
"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": "Nouvelle demande d'ajout de chaîne",
"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": "La chaîne n'existe pas",
"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": "Supprimer la chaîne",
"type": "n8n-nodes-base.postgres",
"onError": "continueRegularOutput",
"position": [
1480,
-540
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "e8f24107-14db-4b04-8c4e-84e3cc78ab7e",
"name": "Obtenir les chaînes",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
-1140
],
"parameters": {},
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "ef44ee6a-b8e3-4919-a8ec-048744444b45",
"name": "Ajouter/Séparer les chaînes",
"type": "n8n-nodes-base.summarize",
"position": [
1700,
-1140
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "427f077c-fe69-4b33-867b-657dd60fea18",
"name": "Chaînes",
"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": "Définir le type",
"type": "n8n-nodes-base.switch",
"position": [
540,
-380
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "3a9175c0-ed95-44ff-bd31-ff8413d88d3b",
"name": "Obtenir les chaînes",
"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 statut du bot sur START",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1740
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "d216d87f-6669-4d79-bee1-9798b1e89eb2",
"name": "Boutons",
"type": "n8n-nodes-base.switch",
"position": [
980,
-1940
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": false
},
{
"id": "fea2d8b6-4d06-4c06-96e1-cf9649bad22e",
"name": "Mettre à jour le statut du bot sur AJOUTER CHAÎNE",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1540
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "a27124ca-3270-4fb3-87a6-6a9cacd5a0a0",
"name": "Mettre à jour le statut du bot sur SUPPRIMER CHAÎNE",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1340
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "13d55ebf-5a73-4a02-9ec2-94fb223b2a46",
"name": "Publication envoyée avec succès",
"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": "Mettre à jour le statut du bot sur START",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
-140
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "e5f6c9fa-a040-4f5f-afaf-f6a961d45179",
"name": "Message de bienvenue",
"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": "Mettre à jour le statut du bot sur DEMANDE DE TEXTE DE PUBLICATION",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-1940
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "76242590-48c7-4c30-b022-5c116ae10d9c",
"name": "Demander le texte de la publication",
"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": "Demander l'image et le texte de la publication",
"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": "Mettre à jour le statut du bot sur DEMANDE D'IMAGE DE PUBLICATION - TEXTE",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
-2140
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "4515b82a-e42f-4c36-a808-831702862d0e",
"name": "Mettre à jour le statut du bot sur DEMANDE D'IMAGE DE PUBLICATION - IMAGE",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
60
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "cd08a0b8-1af2-4a16-8859-33408fa41f0d",
"name": "Sélectionner les chaînes",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
260
],
"parameters": {},
"typeVersion": 2.6
},
{
"id": "0b778c0a-0966-4bef-8300-0b50fb608131",
"name": "Demander l'image de la publication",
"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": "Publication d'image envoyée avec succès",
"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": "Mettre à jour le statut du bot sur START",
"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": "Envoyer les publications (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": "Envoyer les publications d'image (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": "Envoyer les publications d'image (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": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-180,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6a100ae0-0f27-4620-9df7-3b7d122b8020",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-420
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36cae884-0392-4ab9-96e2-9b00fdd3c7a5",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
-140
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2b56999f-cacc-49d0-9f1a-6c5f8bb22cc3",
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c8df3d2c-cb65-46e3-b905-8405684ddafd",
"name": "Upsert statut du bot sur START",
"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
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Ventes, Blocs de construction, Marketing
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Partager ce workflow