Insérer des rapports de contacts Brevo dans NocoDB
Avancé
Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 26 nœuds.Utilise principalement des nœuds comme If, Set, Code, Merge, Filter. Insérer le rapport des contacts Brevo dans NocoDB
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
Nœuds utilisés (26)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"id": "RVpmgXJQMYQlZLVC",
"meta": {
"instanceId": "c24388df44432e8ff2c4acecd7ab0dd2faec628bd83c70beb384cea105f7a50a",
"templateCredsSetupCompleted": true
},
"name": "Insert Brevo Contact Report into NocoDB",
"tags": [
{
"id": "RhAmCaLYc9EkF42I",
"name": "n8n",
"createdAt": "2025-08-24T08:04:35.027Z",
"updatedAt": "2025-08-24T08:04:35.027Z"
}
],
"nodes": [
{
"id": "f1bdd937-0007-4634-8c4e-9e823278101d",
"name": "Obtenir le rapport de contacts Brevo",
"type": "n8n-nodes-base.httpRequest",
"position": [
420,
200
],
"parameters": {
"url": "=https://api.brevo.com/v3/contacts/{{ $json.email }}",
"options": {},
"sendHeaders": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"headerParameters": {
"parameters": [
{
"name": "accept",
"value": "application/json"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "34IHLVlnrWdwmmdn",
"name": "Brevo - R1"
}
},
"typeVersion": 4.2
},
{
"id": "b7c783a8-8633-41ba-a4a9-f34c4d119076",
"name": "Diviser - messagesSent",
"type": "n8n-nodes-base.splitOut",
"position": [
900,
0
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "statistics.messagesSent",
"fieldsToInclude": "email"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "e412c15b-cef6-4e9d-8818-e60ed237363e",
"name": "Diviser - delivered",
"type": "n8n-nodes-base.splitOut",
"position": [
900,
200
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "statistics.delivered",
"fieldsToInclude": "email"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "91be2b24-b8e6-46a6-8f79-96c98095cf9c",
"name": "Diviser - opened",
"type": "n8n-nodes-base.splitOut",
"position": [
900,
420
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "statistics.opened",
"fieldsToInclude": "email"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "7b611c7e-e07c-4e60-8ead-37c36a19c23b",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
1340,
0
],
"parameters": {
"jsCode": "const items = $input.all();\n\n// Group by email\nconst grouped = {};\n\nfor (const item of items) {\n const { email, campaignId, NocoDB_id } = item.json;\n\n if (!grouped[email]) {\n grouped[email] = {\n email,\n NocoDB_id,\n messagesSent: []\n };\n }\n\n grouped[email].messagesSent.push(campaignId);\n}\n\n// Convert grouped object to array\nreturn Object.values(grouped).map(entry => ({\n json: {\n email: entry.email,\n NocoDB_id: entry.NocoDB_id,\n messagesSent: entry.messagesSent.join(', ')\n }\n}));\n"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "c0b9ffb3-ea28-4ea4-8390-2d30c6d888e2",
"name": "Modifier les champs",
"type": "n8n-nodes-base.set",
"position": [
1120,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bc6db831-cee5-46ec-8630-2770239bbcc4",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "462fd57f-98c8-423b-b274-d57458d62f0d",
"name": "campaignId",
"type": "string",
"value": "={{ $json[\"statistics.messagesSent\"].campaignId }}"
},
{
"id": "5f04ebf3-1334-46a4-93da-10f9e8443c0d",
"name": "NocoDB_id",
"type": "string",
"value": "={{ $('Insert Emails from NocoDB').item.json.Id }}"
}
]
}
},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "6ddaf8a4-9240-4f67-a361-8058e2d94598",
"name": "Code1",
"type": "n8n-nodes-base.code",
"position": [
1340,
200
],
"parameters": {
"jsCode": "const items = $input.all();\n\n// Group by email\nconst grouped = {};\n\nfor (const item of items) {\n const { email, campaignId, NocoDB_id } = item.json;\n\n if (!grouped[email]) {\n grouped[email] = {\n email,\n NocoDB_id,\n delivered: []\n };\n }\n\n grouped[email].delivered.push(campaignId);\n}\n\n// Convert grouped object to array\nreturn Object.values(grouped).map(entry => ({\n json: {\n email: entry.email,\n NocoDB_id: entry.NocoDB_id,\n delivered: entry.delivered.join(', ')\n }\n}));\n\n"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "be90e0d6-71da-43ea-9a90-17785b7cb0b3",
"name": "Modifier les champs2",
"type": "n8n-nodes-base.set",
"position": [
1120,
200
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bc6db831-cee5-46ec-8630-2770239bbcc4",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "462fd57f-98c8-423b-b274-d57458d62f0d",
"name": "campaignId",
"type": "string",
"value": "={{ $json[\"statistics.delivered\"].campaignId }}"
},
{
"id": "55231970-3c3a-444c-9bdd-13e187baeb46",
"name": "NocoDB_id",
"type": "string",
"value": "={{ $('Insert Emails from NocoDB').item.json.Id }}"
}
]
}
},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "290f453a-cd1c-4fd1-8761-57e97ee3d371",
"name": "Code2",
"type": "n8n-nodes-base.code",
"position": [
1340,
420
],
"parameters": {
"jsCode": "const items = $input.all();\n\n// Group by email\nconst grouped = {};\n\nfor (const item of items) {\n const { email, campaignId, NocoDB_id } = item.json;\n\n if (!grouped[email]) {\n grouped[email] = {\n email,\n NocoDB_id,\n opened: []\n };\n }\n\n grouped[email].opened.push(campaignId);\n}\n\n// Convert grouped object to array\nreturn Object.values(grouped).map(entry => ({\n json: {\n email: entry.email,\n NocoDB_id: entry.NocoDB_id,\n opened: entry.opened.join(', ')\n }\n}));"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "4b0ed3c4-df99-4a79-9a7e-c9cb04e64afa",
"name": "Modifier les champs3",
"type": "n8n-nodes-base.set",
"position": [
1120,
420
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bc6db831-cee5-46ec-8630-2770239bbcc4",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "462fd57f-98c8-423b-b274-d57458d62f0d",
"name": "campaignId",
"type": "string",
"value": "={{ $json[\"statistics.opened\"].campaignId }}"
},
{
"id": "b5a653f8-4a79-487d-8535-4734a7403637",
"name": "NocoDB_id",
"type": "string",
"value": "={{ $('Insert Emails from NocoDB').item.json.Id }}"
}
]
}
},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "ebec351f-92a5-46a7-9c2f-e456efcea05c",
"name": "Code3",
"type": "n8n-nodes-base.code",
"position": [
1340,
620
],
"parameters": {
"jsCode": "const items = $input.all();\n\n// Group by email\nconst grouped = {};\n\nfor (const item of items) {\n const { email, campaignId, NocoDB_id } = item.json;\n\n if (!grouped[email]) {\n grouped[email] = {\n email,\n NocoDB_id,\n clicked: []\n };\n }\n\n grouped[email].clicked.push(campaignId);\n}\n\n// Convert grouped object to array\nreturn Object.values(grouped).map(entry => ({\n json: {\n email: entry.email,\n NocoDB_id: entry.NocoDB_id,\n clicked: entry.clicked.join(', ')\n }\n}));"
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "da04ac69-9aaa-40dd-931b-50af87b9c7d2",
"name": "Modifier les champs4",
"type": "n8n-nodes-base.set",
"position": [
1120,
620
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "bc6db831-cee5-46ec-8630-2770239bbcc4",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
},
{
"id": "462fd57f-98c8-423b-b274-d57458d62f0d",
"name": "campaignId",
"type": "string",
"value": "={{ $json[\"statistics.clicked\"].campaignId }}"
},
{
"id": "b5a653f8-4a79-487d-8535-4734a7403637",
"name": "NocoDB_id",
"type": "string",
"value": "={{ $('Insert Emails from NocoDB').item.json.Id }}"
}
]
}
},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "8a274188-01b8-4f7b-b198-c30f718d7f7a",
"name": "Déclencheur planifié",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-640,
200
],
"parameters": {
"rule": {
"interval": [
{
"field": "seconds",
"secondsInterval": 2
}
]
}
},
"typeVersion": 1.2
},
{
"id": "392bc93d-c0b7-4b60-9a70-b7f72b384190",
"name": "Diviser - clicked",
"type": "n8n-nodes-base.splitOut",
"position": [
900,
620
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "statistics.clicked",
"fieldsToInclude": "email"
},
"typeVersion": 1,
"alwaysOutputData": true
},
{
"id": "4a346547-a479-4c00-bc53-7a772c64817d",
"name": "Vérifier si l'email est déjà inséré",
"type": "n8n-nodes-base.filter",
"position": [
-100,
200
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3db8b002-7c4b-466b-aad5-2a54061a13c4",
"operator": {
"type": "string",
"operation": "notEquals"
},
"leftValue": "={{ $json.done }}",
"rightValue": "1"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "710df017-88a4-4745-b1c3-5e719c863618",
"name": "Fusionner",
"type": "n8n-nodes-base.merge",
"position": [
1700,
240
],
"parameters": {
"numberInputs": 4
},
"typeVersion": 3.1
},
{
"id": "3b978621-20e0-4704-8b9f-2ea846a51970",
"name": "Supprimer les valeurs nulles",
"type": "n8n-nodes-base.code",
"position": [
1920,
260
],
"parameters": {
"jsCode": "const items = $input.all();\n\n// Group by email\nconst grouped = {};\n\nfor (const item of items) {\n const { email, NocoDB_id, messagesSent, delivered, opened, clicked } = item.json;\n\n if (!grouped[email]) {\n grouped[email] = {\n email,\n NocoDB_id,\n messagesSent: [],\n delivered: [],\n opened: [],\n clicked: []\n };\n }\n\n if (messagesSent) grouped[email].messagesSent.push(messagesSent);\n if (delivered) grouped[email].delivered.push(delivered);\n if (opened) grouped[email].opened.push(opened);\n if (clicked) grouped[email].clicked.push(clicked);\n}\n\n// Merge arrays and clean duplicates if needed\nreturn Object.values(grouped).map(entry => ({\n json: {\n email: entry.email,\n NocoDB_id: entry.NocoDB_id,\n messagesSent: entry.messagesSent.join(', '),\n delivered: entry.delivered.join(', '),\n opened: entry.opened.join(', '),\n clicked: entry.clicked.join(', ')\n }\n}));\n"
},
"typeVersion": 2
},
{
"id": "3679a580-22c5-4e15-a80f-cca5adec92e6",
"name": "Mettre à jour NocoDB",
"type": "n8n-nodes-base.nocoDb",
"position": [
2160,
260
],
"parameters": {
"table": "mz06ar1jy2ca287",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "=id",
"fieldValue": "={{ $json.NocoDB_id }}"
},
{
"fieldName": "messagesSent",
"fieldValue": "={{ $json.messagesSent }}"
},
{
"fieldName": "delivered",
"fieldValue": "={{ $json.delivered }}"
},
{
"fieldName": "opened",
"fieldValue": "={{ $json.opened }}"
},
{
"fieldName": "clicked",
"fieldValue": "={{ $json.clicked }}"
},
{
"fieldName": "done",
"fieldValue": "1"
}
]
},
"operation": "update",
"projectId": "px9vf43y9cqtdog",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "e5afe8d6-2c68-424b-af72-705c780b9540",
"name": "Si email blacklisté",
"type": "n8n-nodes-base.if",
"position": [
620,
200
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "876210df-2bd6-4d0d-88e0-81bda85d2bbe",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.emailBlacklisted }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "0381c270-7dfe-4924-be5c-d89830f15a83",
"name": "Boucle",
"type": "n8n-nodes-base.splitInBatches",
"position": [
160,
200
],
"parameters": {
"options": {},
"batchSize": 10
},
"typeVersion": 3
},
{
"id": "150da896-16ec-49d6-8680-50fde2aabaab",
"name": "Mettre à jour NocoDB - blacklisted",
"type": "n8n-nodes-base.nocoDb",
"position": [
900,
940
],
"parameters": {
"table": "mz06ar1jy2ca287",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "=id",
"fieldValue": "={{ $('Loop').item.json.Id }}"
},
{
"fieldName": "blacklisted",
"fieldValue": "=1"
},
{
"fieldName": "done",
"fieldValue": "1"
}
]
},
"operation": "update",
"projectId": "px9vf43y9cqtdog",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "554932b4-e8be-4aed-8dec-6324ee6e4303",
"name": "Insérer les emails depuis NocoDB",
"type": "n8n-nodes-base.nocoDb",
"position": [
-360,
200
],
"parameters": {
"table": "mz06ar1jy2ca287",
"options": {},
"operation": "getAll",
"projectId": "px9vf43y9cqtdog",
"returnAll": true,
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "548a4011-00df-4ea0-b1a6-6f6e98428756",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
-180
],
"parameters": {
"color": 5,
"height": 560,
"content": "## **Insert Emails from NocoDB**\n\nThis node retrieves email data from your **NocoDB** table. \nIt collects the following fields:\n\n- **email** \n- **messagesSent** \n- **delivered** \n- **opened** \n- **clicked** \n- **done** \n- **blacklisted**"
},
"typeVersion": 1
},
{
"id": "be3d163d-95df-4248-bbdd-8f8b00ead6e7",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
-180
],
"parameters": {
"color": 5,
"height": 560,
"content": "## **Get Brevo Contact Report**\n\nThis node connects to the **Brevo API** to retrieve detailed contact engagement reports. \nIt fetches activity data for each email, including:\n\n- **messagesSent** \n- **delivered** \n- **opened** \n- **clicked** \n- **blacklisted**"
},
"typeVersion": 1
},
{
"id": "4ffd304f-6f3a-42d8-8ae8-72e0fa9c9624",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
-280
],
"parameters": {
"color": 5,
"height": 1080,
"content": "## **Split Out Nodes**\n\nThis section splits the **Brevo contact report data** into separate branches. \nEach branch processes a specific type of result before updating records in **NocoDB**.\n"
},
"typeVersion": 1
},
{
"id": "83e22d4b-64de-4e68-99e7-034429813769",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-280
],
"parameters": {
"color": 5,
"height": 1080,
"content": "## **Code Nodes**\n\nThese nodes use JavaScript to **group and organize Brevo contact data** by email. \nThey combine multiple campaign records into a single entry for each contact, preparing the data for insertion into **NocoDB**."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Get Brevo Contact Report": [
{
"json": {
"id": 222683,
"email": "nimasalimi42@gmail.com",
"listIds": [
15,
138,
163,
150,
149,
153,
178,
181,
182,
187
],
"createdAt": "2024-03-18T10:02:10.584+03:30",
"attributes": {
"SMS": "989939116065",
"LASTNAME": "Salimi",
"FIRSTNAME": "Nima Salimi",
"SIGNUP_DATE": "2024-03-08",
"CONTRACT_NUMBER": "2024-03-08"
},
"modifiedAt": "2025-09-25T08:30:05.415+03:30",
"statistics": {
"opened": [
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-10-05T01:25:30.837+03:30",
"campaignId": 201
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-10-05T01:25:20.615+03:30",
"campaignId": 197
},
{
"ip": "213.32.72.225",
"count": 3,
"eventTime": "2025-09-02T08:33:56.380+03:30",
"campaignId": 452
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-26T20:43:41.178+03:30",
"campaignId": 488
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-16T10:11:06.934+03:30",
"campaignId": 466
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-15T16:26:03.461+03:30",
"campaignId": 464
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-15T14:28:47.115+03:30",
"campaignId": 467
},
{
"ip": "213.32.72.225",
"count": 3,
"eventTime": "2025-08-30T17:09:04.573+03:30",
"campaignId": 451
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-08-21T03:03:54.974+03:30",
"campaignId": 445
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-08-02T12:02:46.910+03:30",
"campaignId": 427
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-07-29T14:12:04.266+03:30",
"campaignId": 424
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-07-27T14:59:27.048+03:30",
"campaignId": 421
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-07-22T15:57:04.210+03:30",
"campaignId": 417
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-07-16T01:34:30.129+03:30",
"campaignId": 419
},
{
"ip": "213.32.72.225",
"count": 2,
"eventTime": "2025-07-13T17:27:20.755+03:30",
"campaignId": 416
}
],
"clicked": [
{
"links": [
{
"ip": "213.32.72.225",
"url": "https://arvancloud.porsline.ir/s/3fYwicb",
"count": 1,
"eventTime": "2025-08-21T03:03:58.152+03:30"
}
],
"campaignId": 445
},
{
"links": [
{
"ip": "213.32.72.225",
"url": "https://academy.arvancloud.ir/courses/professional-cloud-architect/?utm_source=brevo&utm_campaign=Academy-advance-courses-published&utm_medium=email",
"count": 1,
"eventTime": "2025-08-02T12:03:18.092+03:30"
},
{
"ip": "213.32.72.225",
"url": "https://academy.arvancloud.ir/courses/expert-devops-engineer/?utm_source=brevo&utm_campaign=Academy-advance-courses-published&utm_medium=email",
"count": 1,
"eventTime": "2025-08-02T12:03:05.973+03:30"
},
{
"ip": "213.32.72.225",
"url": "https://academy.arvancloud.ir/?utm_source=brevo&utm_campaign=Academy-advance-courses-published&utm_medium=email",
"count": 2,
"eventTime": "2025-08-02T12:03:00.763+03:30"
}
],
"campaignId": 427
}
],
"delivered": [
{
"eventTime": "2025-09-25T08:30:12.287+03:30",
"campaignId": 488
},
{
"eventTime": "2025-09-16T10:10:49.863+03:30",
"campaignId": 466
},
{
"eventTime": "2025-09-15T11:38:11.379+03:30",
"campaignId": 467
},
{
"eventTime": "2025-09-13T11:36:44.627+03:30",
"campaignId": 464
},
{
"eventTime": "2025-09-02T08:33:28.607+03:30",
"campaignId": 452
},
{
"eventTime": "2025-08-30T14:36:30.188+03:30",
"campaignId": 451
},
{
"eventTime": "2025-08-20T12:36:20.277+03:30",
"campaignId": 445
},
{
"eventTime": "2025-08-02T11:24:54.085+03:30",
"campaignId": 427
},
{
"eventTime": "2025-07-29T13:46:33.238+03:30",
"campaignId": 424
},
{
"eventTime": "2025-07-27T12:03:02.137+03:30",
"campaignId": 421
},
{
"eventTime": "2025-07-22T13:35:38.311+03:30",
"campaignId": 417
},
{
"eventTime": "2025-07-15T12:37:27.123+03:30",
"campaignId": 419
},
{
"eventTime": "2025-07-13T11:48:57.976+03:30",
"campaignId": 416
}
],
"messagesSent": [
{
"eventTime": "2025-09-25T08:30:05.355+03:30",
"campaignId": 488
},
{
"eventTime": "2025-09-16T10:01:43.465+03:30",
"campaignId": 466
},
{
"eventTime": "2025-09-15T11:33:29.495+03:30",
"campaignId": 467
},
{
"eventTime": "2025-09-13T11:32:18.287+03:30",
"campaignId": 464
},
{
"eventTime": "2025-09-02T08:30:36.082+03:30",
"campaignId": 452
},
{
"eventTime": "2025-08-30T14:33:10.606+03:30",
"campaignId": 451
},
{
"eventTime": "2025-08-20T12:35:18.227+03:30",
"campaignId": 445
},
{
"eventTime": "2025-08-02T11:16:29.133+03:30",
"campaignId": 427
},
{
"eventTime": "2025-07-29T11:46:22.433+03:30",
"campaignId": 424
},
{
"eventTime": "2025-07-27T12:02:59.183+03:30",
"campaignId": 421
},
{
"eventTime": "2025-07-22T13:32:38.477+03:30",
"campaignId": 417
},
{
"eventTime": "2025-07-15T12:37:08.756+03:30",
"campaignId": 419
},
{
"eventTime": "2025-07-13T11:48:41.345+03:30",
"campaignId": 416
}
]
},
"smsBlacklisted": false,
"emailBlacklisted": false
}
},
{
"json": {
"id": 229467,
"email": "nima.r1cloud@gmail.com",
"listIds": [
15
],
"createdAt": "2024-06-11T13:26:56.723+03:30",
"attributes": {
"FIRSTNAME": "نیما آروان",
"SIGNUP_DATE": "2024-05-24"
},
"modifiedAt": "2025-09-24T12:46:09.936+03:30",
"statistics": {
"opened": [
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-10-05T01:26:35.245+03:30",
"campaignId": 369
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-10-05T01:26:21.639+03:30",
"campaignId": 316
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-24T14:11:16.981+03:30",
"campaignId": 487
},
{
"ip": "213.32.72.225",
"count": 3,
"eventTime": "2025-09-16T18:16:02.910+03:30",
"campaignId": 424
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-16T18:16:13.758+03:30",
"campaignId": 430
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-15T13:18:01.766+03:30",
"campaignId": 467
},
{
"ip": "213.32.72.225",
"count": 1,
"eventTime": "2025-09-06T12:44:12.488+03:30",
"campaignId": 458
}
],
"clicked": [
{
"links": [
{
"ip": "213.32.72.225",
"url": "https://try.arvancloud.ir/fa/elecomp?utm_source=brevo&utm_campaign=Elecomp 1404_Fixed&utm_medium=email",
"count": 1,
"eventTime": "2025-09-24T14:11:53.716+03:30"
}
],
"campaignId": 487
},
{
"links": [
{
"ip": "213.32.72.225",
"url": "https://www.arvancloud.ir/fa/devops?utm_source=brevo&utm_campaign=implementing infrastructure projects with ArvanCloud DevOps&utm_medium=email",
"count": 2,
"eventTime": "2025-09-21T18:56:19.519+03:30"
}
],
"campaignId": 424
}
],
"delivered": [
{
"eventTime": "2025-09-24T12:47:32.055+03:30",
"campaignId": 487
},
{
"eventTime": "2025-09-15T11:44:06.257+03:30",
"campaignId": 467
},
{
"eventTime": "2025-09-06T08:36:09.528+03:30",
"campaignId": 458
},
{
"eventTime": "2025-08-30T14:34:22.044+03:30",
"campaignId": 451
},
{
"eventTime": "2025-08-02T16:05:54.796+03:30",
"campaignId": 430
},
{
"eventTime": "2025-07-29T12:04:30.371+03:30",
"campaignId": 424
}
],
"messagesSent": [
{
"eventTime": "2025-09-24T12:46:09.914+03:30",
"campaignId": 487
},
{
"eventTime": "2025-09-15T11:33:29.565+03:30",
"campaignId": 467
},
{
"eventTime": "2025-09-06T07:30:39.781+03:30",
"campaignId": 458
},
{
"eventTime": "2025-08-30T14:33:12.453+03:30",
"campaignId": 451
},
{
"eventTime": "2025-08-02T16:04:34.417+03:30",
"campaignId": 430
},
{
"eventTime": "2025-07-29T12:01:58.253+03:30",
"campaignId": 424
}
]
},
"smsBlacklisted": false,
"emailBlacklisted": false
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "2a211b45-06c9-4f7c-be20-af3d49727a20",
"connections": {
"7b611c7e-e07c-4e60-8ead-37c36a19c23b": {
"main": [
[
{
"node": "710df017-88a4-4745-b1c3-5e719c863618",
"type": "main",
"index": 0
}
]
]
},
"0381c270-7dfe-4924-be5c-d89830f15a83": {
"main": [
[],
[
{
"node": "f1bdd937-0007-4634-8c4e-9e823278101d",
"type": "main",
"index": 0
}
]
]
},
"6ddaf8a4-9240-4f67-a361-8058e2d94598": {
"main": [
[
{
"node": "710df017-88a4-4745-b1c3-5e719c863618",
"type": "main",
"index": 1
}
]
]
},
"290f453a-cd1c-4fd1-8761-57e97ee3d371": {
"main": [
[
{
"node": "710df017-88a4-4745-b1c3-5e719c863618",
"type": "main",
"index": 2
}
]
]
},
"ebec351f-92a5-46a7-9c2f-e456efcea05c": {
"main": [
[
{
"node": "710df017-88a4-4745-b1c3-5e719c863618",
"type": "main",
"index": 3
}
]
]
},
"710df017-88a4-4745-b1c3-5e719c863618": {
"main": [
[
{
"node": "3b978621-20e0-4704-8b9f-2ea846a51970",
"type": "main",
"index": 0
}
]
]
},
"c0b9ffb3-ea28-4ea4-8390-2d30c6d888e2": {
"main": [
[
{
"node": "7b611c7e-e07c-4e60-8ead-37c36a19c23b",
"type": "main",
"index": 0
}
]
]
},
"3b978621-20e0-4704-8b9f-2ea846a51970": {
"main": [
[
{
"node": "3679a580-22c5-4e15-a80f-cca5adec92e6",
"type": "main",
"index": 0
}
]
]
},
"be90e0d6-71da-43ea-9a90-17785b7cb0b3": {
"main": [
[
{
"node": "6ddaf8a4-9240-4f67-a361-8058e2d94598",
"type": "main",
"index": 0
}
]
]
},
"4b0ed3c4-df99-4a79-9a7e-c9cb04e64afa": {
"main": [
[
{
"node": "290f453a-cd1c-4fd1-8761-57e97ee3d371",
"type": "main",
"index": 0
}
]
]
},
"da04ac69-9aaa-40dd-931b-50af87b9c7d2": {
"main": [
[
{
"node": "ebec351f-92a5-46a7-9c2f-e456efcea05c",
"type": "main",
"index": 0
}
]
]
},
"3679a580-22c5-4e15-a80f-cca5adec92e6": {
"main": [
[
{
"node": "0381c270-7dfe-4924-be5c-d89830f15a83",
"type": "main",
"index": 0
}
]
]
},
"8a274188-01b8-4f7b-b198-c30f718d7f7a": {
"main": [
[
{
"node": "554932b4-e8be-4aed-8dec-6324ee6e4303",
"type": "main",
"index": 0
}
]
]
},
"91be2b24-b8e6-46a6-8f79-96c98095cf9c": {
"main": [
[
{
"node": "4b0ed3c4-df99-4a79-9a7e-c9cb04e64afa",
"type": "main",
"index": 0
}
]
]
},
"392bc93d-c0b7-4b60-9a70-b7f72b384190": {
"main": [
[
{
"node": "da04ac69-9aaa-40dd-931b-50af87b9c7d2",
"type": "main",
"index": 0
}
]
]
},
"e5afe8d6-2c68-424b-af72-705c780b9540": {
"main": [
[
{
"node": "150da896-16ec-49d6-8680-50fde2aabaab",
"type": "main",
"index": 0
}
],
[
{
"node": "b7c783a8-8633-41ba-a4a9-f34c4d119076",
"type": "main",
"index": 0
},
{
"node": "e412c15b-cef6-4e9d-8818-e60ed237363e",
"type": "main",
"index": 0
},
{
"node": "91be2b24-b8e6-46a6-8f79-96c98095cf9c",
"type": "main",
"index": 0
},
{
"node": "392bc93d-c0b7-4b60-9a70-b7f72b384190",
"type": "main",
"index": 0
}
]
]
},
"e412c15b-cef6-4e9d-8818-e60ed237363e": {
"main": [
[
{
"node": "be90e0d6-71da-43ea-9a90-17785b7cb0b3",
"type": "main",
"index": 0
}
]
]
},
"f1bdd937-0007-4634-8c4e-9e823278101d": {
"main": [
[
{
"node": "e5afe8d6-2c68-424b-af72-705c780b9540",
"type": "main",
"index": 0
}
]
]
},
"b7c783a8-8633-41ba-a4a9-f34c4d119076": {
"main": [
[
{
"node": "c0b9ffb3-ea28-4ea4-8390-2d30c6d888e2",
"type": "main",
"index": 0
}
]
]
},
"554932b4-e8be-4aed-8dec-6324ee6e4303": {
"main": [
[
{
"node": "4a346547-a479-4c00-bc53-7a772c64817d",
"type": "main",
"index": 0
}
]
]
},
"4a346547-a479-4c00-bc53-7a772c64817d": {
"main": [
[
{
"node": "0381c270-7dfe-4924-be5c-d89830f15a83",
"type": "main",
"index": 0
}
]
]
}
}
}Foire aux questions
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é - Création de contenu, IA Multimodale
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
Version professionnelle de l'automatisation de blog WordPress (recherche approfondie) v2.1 sur le marché
Automatisation de la création de blog optimisé pour le SEO avec GPT-4o, Perplexity AI et support multilingue
If
Set
Xml
+
If
Set
Xml
125 NœudsDaniel Ng
Création de contenu
contenugénérateur v3
AI驱动blogautomatisation：utilisationGPT-4génération并publicationSEOarticle至WordPressetTwitter
If
Set
Code
+
If
Set
Code
144 NœudsJay Emp0
Création de contenu
Agrégation de contenu
Automatiser la publication de publications sur les réseaux sociaux à partir d'articles de site web vers LinkedIn et X/Twitter avec Gemini AI
If
Set
Xml
+
If
Set
Xml
34 NœudsVadim
Création de contenu
Résumé sportif quotidien
Utiliser Google Gemini, Kokoro TTS et FFmpeg pour convertir des sources RSS en podcasts
If
Set
Code
+
If
Set
Code
34 NœudsJonas
Création de contenu
Convertir les points de douleur commerciaux Reddit en contenu viral LinkedIn avec l'IA et Freepik
Utiliser l'IA et Freepik pour convertir les points de douleur métier Reddit en contenu LinkedIn viral
If
Set
Code
+
If
Set
Code
48 NœudsDaniel Lianes
Création de contenu
Créer un blog WordPress optimisé pour le référencement avec des mots-clés et des médias en utilisant Perplexity et GPT
Créer un blog SEO optimisé pour WordPress avec des mots-clés et des supports média en utilisant Perplexity et GPT
Set
Code
Limit
+
Set
Code
Limit
124 NœudsPaul
Création de contenu
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds26
Catégorie2
Types de nœuds11
Description de la difficulté
Auteur
Nima Salimi
@salimiWith a deep understanding of marketing processes and data flows, I create solutions that streamline user engagement, campaign management, and data synchronization across multiple platforms. My goal is to help businesses reduce manual effort, improve accuracy, and accelerate their marketing initiatives through smart automation.
Liens externes
Voir sur n8n.io →
Partager ce workflow