Brevo-Kontaktberichte in NocoDB einfügen
Experte
Dies ist ein Content Creation, Multimodal AI-Bereich Automatisierungsworkflow mit 26 Nodes. Hauptsächlich werden If, Set, Code, Merge, Filter und andere Nodes verwendet. Brevo-Kontaktbericht in NocoDB einfügen
Voraussetzungen
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
Verwendete Nodes (26)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"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": "Brevo-Kontaktbericht abrufen",
"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": "Aufteilen - 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": "Aufteilen - 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": "Aufteilen - 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": "Felder bearbeiten",
"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": "Felder bearbeiten2",
"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": "Felder bearbeiten3",
"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": "Felder bearbeiten4",
"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": "Zeitplan-Trigger",
"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": "Aufteilen - 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": "Prüfen, ob E-Mail bereits eingefügt wurde",
"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": "Zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
1700,
240
],
"parameters": {
"numberInputs": 4
},
"typeVersion": 3.1
},
{
"id": "3b978621-20e0-4704-8b9f-2ea846a51970",
"name": "Nullwerte löschen",
"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": "NocoDB aktualisieren",
"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": "Wenn E-Mail auf 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": "Schleife",
"type": "n8n-nodes-base.splitInBatches",
"position": [
160,
200
],
"parameters": {
"options": {},
"batchSize": 10
},
"typeVersion": 3
},
{
"id": "150da896-16ec-49d6-8680-50fde2aabaab",
"name": "NocoDB aktualisieren - 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": "E-Mails aus NocoDB einfügen",
"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": "Haftnotiz1",
"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": "Haftnotiz2",
"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": "Haftnotiz3",
"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": "Haftnotiz4",
"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
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Content-Erstellung, Multimodales KI
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
WordPress-Blog-Automatisierung Professional Edition (Deep Research) v2.1 Markt
Automatisierung der Erstellung von SEO-optimierten Blogs mit GPT-4o, Perplexity AI und mehrsprachiger Unterstützung
If
Set
Xml
+
If
Set
Xml
125 NodesDaniel Ng
Content-Erstellung
InhaltGenerator v3
If
Set
Code
+
If
Set
Code
144 NodesJay Emp0
Content-Erstellung
Inhaltsaggregation
Automatisierte Veröffentlichung von Social-Media-Posts auf LinkedIn und X/Twitter aus Website-Artikeln mit Gemini AI
If
Set
Xml
+
If
Set
Xml
34 NodesVadim
Content-Erstellung
Tägliches Sport-Update
Konvertieren Sie RSS-Feeds mit Google Gemini, Kokoro TTS und FFmpeg in Podcasts
If
Set
Code
+
If
Set
Code
34 NodesJonas
Content-Erstellung
Verwenden Sie AI und Freepik, um Reddit-Geschäftsprobleme in virales LinkedIn-Inhalt umzuwandeln
Verwandeln Sie Reddit-Geschäftsprobleme mithilfe von KI und Freepik in virale LinkedIn-Inhalte
If
Set
Code
+
If
Set
Code
48 NodesDaniel Lianes
Content-Erstellung
SEO-optimierten WordPress-Blog mit Keywords und Medien mit Perplexity und GPT erstellen
Erstellen Sie für WordPress eine SEO-optimierte Blog mit Keywords und Medien mit Perplexity und GPT
Set
Code
Limit
+
Set
Code
Limit
124 NodesPaul
Content-Erstellung
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes26
Kategorie2
Node-Typen11
Autor
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.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen