Brevo連絡先レポートをNocoDBに挿入
上級
これはContent Creation, Multimodal AI分野の自動化ワークフローで、26個のノードを含みます。主にIf, Set, Code, Merge, Filterなどのノードを使用。 Brevo連絡先レポートのNocoDBへの挿入
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定を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コンタクトレポート取得",
"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": "分割 - 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": "分割 - 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": "分割 - 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": "コード",
"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": "フィールド編集",
"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": "コード1",
"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": "フィールド編集2",
"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": "コード2",
"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": "フィールド編集3",
"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": "コード3",
"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": "フィールド編集4",
"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": "スケジュールトリガー",
"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": "分割 - 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": "メール既挿入確認",
"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": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
1700,
240
],
"parameters": {
"numberInputs": 4
},
"typeVersion": 3.1
},
{
"id": "3b978621-20e0-4704-8b9f-2ea846a51970",
"name": "Null値削除",
"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更新",
"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": "メールブラックリスト判定",
"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": "ループ",
"type": "n8n-nodes-base.splitInBatches",
"position": [
160,
200
],
"parameters": {
"options": {},
"batchSize": 10
},
"typeVersion": 3
},
{
"id": "150da896-16ec-49d6-8680-50fde2aabaab",
"name": "NocoDB更新 - ブラックリスト",
"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": "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": "付箋1",
"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": "付箋2",
"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": "付箋3",
"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": "付箋4",
"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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - コンテンツ作成, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
WordPressブログの自動化プロフェッショナル版（先端研究）v2.1マーケットプラグイン
GPT-4o、Perplexity AI、そして多言語対応を使ったSEO最適化ブログ作成の自動化
If
Set
Xml
+
If
Set
Xml
125 ノードDaniel Ng
コンテンツ作成
コンテンツジェネレーター v3
AI驱动ブログ自動化：使用GPT-4生成并公開SEO記事至WordPressとTwitter
If
Set
Code
+
If
Set
Code
144 ノードJay Emp0
コンテンツ作成
コンテンツ集約
Gemini AIを使ってウェブ記事からLinkedInとX/Twitterへのソーシャルメディア投稿を自動化する
If
Set
Xml
+
If
Set
Xml
34 ノードVadim
コンテンツ作成
毎日のスポーツ要約
Google Gemini、Kokoro TTS、FFmpegを使用してRSSフィードをポッドキャストに変換
If
Set
Code
+
If
Set
Code
34 ノードJonas
コンテンツ作成
AIとFreepikを使用してRedditのビジネス課題をウイルスのLinkedInコンテンツに変換
AIとFreepikを使用してRedditのビジネス課題をウイルスのなLinkedInコンテンツに変換
If
Set
Code
+
If
Set
Code
48 ノードDaniel Lianes
コンテンツ作成
PerplexityとGPTを使用して、キーワードとメディアを含むWordPressのSEO最適化ブログを作成
WordPress向けSEO最適化されたブログの作成（Perplexity、GPTベース、キーワードとメディア付き）
Set
Code
Limit
+
Set
Code
Limit
124 ノードPaul
コンテンツ作成
ワークフロー情報
難易度
上級
ノード数26
カテゴリー2
ノードタイプ11
作成者
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.
外部リンク
n8n.ioで表示 →
このワークフローを共有