Airtable CRM と Brevo メールに基づく自動化された宣伝キャンペーン
上級
これはSocial Media, Multimodal AI分野の自動化ワークフローで、22個のノードを含みます。主にSet, Wait, Switch, Webhook, Airtableなどのノードを使用。 Airtable CRM と Brevo メールを使ってマーケティングキャンペーンを自動化
前提条件
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •Airtable API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "ad48a01aec252f63ae8de1713711ab9e32029259011598511a3ef275db7ecb31",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "210abf6c-eb2f-4bc2-9b72-95855961bb37",
"name": "ワークフロー実行時",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-160,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "505840ce-982f-432b-8b3f-8c33087379e8",
"name": "アイテムのループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
288,
-80
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "9d66fbd6-6d7b-41c8-95e6-fba126e9f447",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
1072,
-64
],
"webhookId": "63de4e13-614a-4f47-b8ae-16443455cfde",
"parameters": {
"amount": 3
},
"typeVersion": 1.1
},
{
"id": "244ab1e8-7626-4580-911a-a86d51ef6bd2",
"name": "付箋メモ",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-320
],
"parameters": {
"color": 5,
"width": 396,
"height": 200,
"content": "## Email Sending Workflow \n### 🛠️ Prerequisites :\n* Credentials : Airtable, Brevo\n* CRM Tables : Compagny, Interaction, [Campaign]\n* Email Template defined in Brevo\n* Search Conditions : AND({Opt-in} = 1, {Campaign} = 1, {Checked Email} = 1)"
},
"typeVersion": 1
},
{
"id": "af8f6f63-10aa-47e5-b631-63171d6a6767",
"name": "既存テンプレートを使用したメール送信",
"type": "n8n-nodes-base.sendInBlue",
"position": [
512,
-64
],
"parameters": {
"operation": "sendTemplate",
"templateId": 2,
"receipients": "={{ $json.Email }}",
"requestOptions": {},
"additionalFields": {}
},
"credentials": {
"sendInBlueApi": {
"id": "p3EVXKxk4XIJAHvo",
"name": "Brevo EML"
}
},
"typeVersion": 1
},
{
"id": "a85ae7c1-cba1-4cfa-9a4f-4e6d8d37bec7",
"name": "フィールド編集",
"type": "n8n-nodes-base.set",
"position": [
704,
-64
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c57ff277-6091-439b-8dd1-83d23150953f",
"name": "message_Id",
"type": "string",
"value": "={{ $json.messageId.match(/<([^@]+)@/)[1] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e0a41139-df0a-4c79-ba10-838c1d1cffe8",
"name": "インタラクション作成",
"type": "n8n-nodes-base.airtable",
"position": [
896,
-64
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appQMvR0bhVFIfsp5",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5",
"cachedResultName": "Prospection"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblgenUgOs4nZEiZY",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5/tblgenUgOs4nZEiZY",
"cachedResultName": "INTERACTION"
},
"columns": {
"value": {
"Date": "={{ $now.format('yyyy-MM-dd\\'T\\'HH:mm:ss.000\\'Z\\'') }}",
"Name": "=Campaign {{$now}}",
"Media": "Email",
"COMPANY": "=[\"{{ $('Search Company').item.json.Name }}\"]",
"Brevo Id": "={{ $json.message_Id }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "COMPANY",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "COMPANY",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Media",
"type": "options",
"display": true,
"options": [
{
"name": "Email",
"value": "Email"
},
{
"name": "1:1",
"value": "1:1"
},
{
"name": "Call",
"value": "Call"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Media",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "CAMPAIGN",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "CAMPAIGN",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Brevo Id",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Brevo Id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Delivred Email",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Delivred Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Open Email",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Open Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Clicked Email",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Clicked Email",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "Psqhq4DEUuvikWZJ",
"name": "Airtable GS"
}
},
"typeVersion": 2.1
},
{
"id": "4ef43cb4-9e4b-458f-8108-a3a1b51a4cb9",
"name": "企業検索",
"type": "n8n-nodes-base.airtable",
"position": [
64,
-80
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appQMvR0bhVFIfsp5",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5",
"cachedResultName": "Prospection"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZvVs5HurZQdK2u",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5/tblZvVs5HurZQdK2u",
"cachedResultName": "COMPANY"
},
"options": {},
"operation": "search",
"filterByFormula": "=AND({Opt-in} = 1, {Campaign} = 1, {Checked Email} = 1)"
},
"credentials": {
"airtableTokenApi": {
"id": "Psqhq4DEUuvikWZJ",
"name": "Airtable GS"
}
},
"typeVersion": 2.1
},
{
"id": "d520cced-8037-4e1d-87dc-fadeadeec378",
"name": "付箋メモ1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-176,
208
],
"parameters": {
"color": 5,
"width": 396,
"height": 200,
"content": "## Email Event Tracking Workflow \n### 🛠️ Prerequisites :\n* Brevo configuration for calling the n8n Webhook\n* Brevo configuration sending email events"
},
"typeVersion": 1
},
{
"id": "808ce229-b3c8-4c07-a40f-8b37fbcf61b7",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-160,
544
],
"webhookId": "c33e522e-9ee2-4156-a430-f49d997cd2dc",
"parameters": {
"path": "TO-BE-MODIFIED",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "02d02732-9eec-402a-8351-8d003056d265",
"name": "分岐",
"type": "n8n-nodes-base.switch",
"position": [
464,
512
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Delivred Email",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "7d464efc-43ea-4024-862c-fa3dcfe23c51",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Webhook').item.json.body.event }}",
"rightValue": "delivered"
}
]
},
"renameOutput": true
},
{
"outputKey": "Opened Email",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "6d7ae41f-800e-44e5-8f16-4f59a486c198",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Webhook').item.json.body.event }}",
"rightValue": "opened"
}
]
},
"renameOutput": true
},
{
"outputKey": "Clicked Email",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "161e9343-ca68-4187-b508-9801fad12e1c",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Webhook').item.json.body.event }}",
"rightValue": "click"
}
]
},
"renameOutput": true
}
]
},
"options": {
"fallbackOutput": "extra"
},
"looseTypeValidation": true
},
"typeVersion": 3.2
},
{
"id": "6824bcdc-381d-4143-9081-f28450640202",
"name": "フィールド編集1",
"type": "n8n-nodes-base.set",
"position": [
64,
544
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d3b95280-ac48-4b20-8b1f-aace4c0fd42b",
"name": "body['message-id']",
"type": "string",
"value": "={{ $json.body['message-id'].match(/<([^@]+)@/)[1] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "30306b08-dff4-4c02-b101-0856e30d8a4e",
"name": "インタラクション検索",
"type": "n8n-nodes-base.airtable",
"position": [
272,
544
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appQMvR0bhVFIfsp5",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5",
"cachedResultName": "Prospection"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblgenUgOs4nZEiZY",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5/tblgenUgOs4nZEiZY",
"cachedResultName": "INTERACTION"
},
"options": {},
"operation": "search",
"filterByFormula": "=({Brevo Id} = '{{ $json.body['message-id'] }}') "
},
"credentials": {
"airtableTokenApi": {
"id": "Psqhq4DEUuvikWZJ",
"name": "Airtable GS"
}
},
"typeVersion": 2.1
},
{
"id": "60aae98a-2ecd-40b4-af40-5fa4705acae1",
"name": "配信済み更新",
"type": "n8n-nodes-base.airtable",
"position": [
736,
256
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appNBamDT6tL067rG",
"cachedResultUrl": "https://airtable.com/appNBamDT6tL067rG",
"cachedResultName": "CRM"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblx5NMTFT6XeRgZJ",
"cachedResultUrl": "https://airtable.com/appNBamDT6tL067rG/tblx5NMTFT6XeRgZJ",
"cachedResultName": "Interaction"
},
"columns": {
"value": {
"Brevo Id": "={{ $json['Brevo Id'] }}",
"Email Délivré": "={{ $now.format('yyyy-MM-dd\\'T\\'HH:mm:ss.000\\'Z\\'') }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Interaction",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Interaction",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Société",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Société",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Contact",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Interaction",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Date Interaction",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Media",
"type": "options",
"display": true,
"options": [
{
"name": "Email",
"value": "Email"
},
{
"name": "Courrier",
"value": "Courrier"
},
{
"name": "Téléphone",
"value": "Téléphone"
},
{
"name": "Linkedin",
"value": "Linkedin"
},
{
"name": "Autre",
"value": "Autre"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "A définir 1",
"value": "A définir 1"
},
{
"name": "A définir 2",
"value": "A définir 2"
},
{
"name": "A définir 3",
"value": "A définir 3"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Brevo Id",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Brevo Id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Délivré",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email Délivré",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Ouvert",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Ouvert",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Cliqué",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Cliqué",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Brevo Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "ICBJakkf7Bs46udo",
"name": "Airtable EML"
}
},
"typeVersion": 2.1
},
{
"id": "3d512b07-91f6-4cb8-a262-1aae02f0fa86",
"name": "開封済み更新",
"type": "n8n-nodes-base.airtable",
"position": [
736,
448
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appNBamDT6tL067rG",
"cachedResultUrl": "https://airtable.com/appNBamDT6tL067rG",
"cachedResultName": "CRM"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblx5NMTFT6XeRgZJ",
"cachedResultUrl": "https://airtable.com/appNBamDT6tL067rG/tblx5NMTFT6XeRgZJ",
"cachedResultName": "Interaction"
},
"columns": {
"value": {
"Brevo Id": "={{ $json['Brevo Id'] }}",
"Email Ouvert": "={{ $now.format('yyyy-MM-dd\\'T\\'HH:mm:ss.000\\'Z\\'') }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Interaction",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Interaction",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Société",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Société",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Contact",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Interaction",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Date Interaction",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Media",
"type": "options",
"display": true,
"options": [
{
"name": "Email",
"value": "Email"
},
{
"name": "Courrier",
"value": "Courrier"
},
{
"name": "Téléphone",
"value": "Téléphone"
},
{
"name": "Linkedin",
"value": "Linkedin"
},
{
"name": "Autre",
"value": "Autre"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "A définir 1",
"value": "A définir 1"
},
{
"name": "A définir 2",
"value": "A définir 2"
},
{
"name": "A définir 3",
"value": "A définir 3"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Brevo Id",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Brevo Id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Délivré",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Délivré",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Ouvert",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email Ouvert",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Cliqué",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Cliqué",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Brevo Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "ICBJakkf7Bs46udo",
"name": "Airtable EML"
}
},
"typeVersion": 2.1
},
{
"id": "5637b700-2b79-43c8-963a-accd06cccf80",
"name": "クリック済み更新",
"type": "n8n-nodes-base.airtable",
"position": [
736,
624
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appNBamDT6tL067rG",
"cachedResultUrl": "https://airtable.com/appNBamDT6tL067rG",
"cachedResultName": "CRM"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblx5NMTFT6XeRgZJ",
"cachedResultUrl": "https://airtable.com/appNBamDT6tL067rG/tblx5NMTFT6XeRgZJ",
"cachedResultName": "Interaction"
},
"columns": {
"value": {
"Brevo Id": "={{ $json['Brevo Id'] }}",
"Email Cliqué": "={{ $now.format('yyyy-MM-dd\\'T\\'HH:mm:ss.000\\'Z\\'') }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Interaction",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Interaction",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Société",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Société",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contact",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Contact",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date Interaction",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Date Interaction",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Media",
"type": "options",
"display": true,
"options": [
{
"name": "Email",
"value": "Email"
},
{
"name": "Courrier",
"value": "Courrier"
},
{
"name": "Téléphone",
"value": "Téléphone"
},
{
"name": "Linkedin",
"value": "Linkedin"
},
{
"name": "Autre",
"value": "Autre"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "A définir 1",
"value": "A définir 1"
},
{
"name": "A définir 2",
"value": "A définir 2"
},
{
"name": "A définir 3",
"value": "A définir 3"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Brevo Id",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Brevo Id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Délivré",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Délivré",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Ouvert",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Ouvert",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Cliqué",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email Cliqué",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Brevo Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "ICBJakkf7Bs46udo",
"name": "Airtable EML"
}
},
"typeVersion": 2.1
},
{
"id": "48fbfe3f-d96b-461c-bdb7-7f2dd283c297",
"name": "企業検索2",
"type": "n8n-nodes-base.airtable",
"position": [
736,
816
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appQMvR0bhVFIfsp5",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5",
"cachedResultName": "Prospection"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZvVs5HurZQdK2u",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5/tblZvVs5HurZQdK2u",
"cachedResultName": "COMPANY"
},
"options": {},
"operation": "search",
"filterByFormula": "=RECORD_ID() = \"{{ $json['Société'][0] }}\""
},
"credentials": {
"airtableTokenApi": {
"id": "Psqhq4DEUuvikWZJ",
"name": "Airtable GS"
}
},
"typeVersion": 2.1
},
{
"id": "55f4df06-afe0-4607-8b93-91abda5e4853",
"name": "企業情報更新",
"type": "n8n-nodes-base.airtable",
"position": [
944,
816
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appQMvR0bhVFIfsp5",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5",
"cachedResultName": "Prospection"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblZvVs5HurZQdK2u",
"cachedResultUrl": "https://airtable.com/appQMvR0bhVFIfsp5/tblZvVs5HurZQdK2u",
"cachedResultName": "COMPANY"
},
"columns": {
"value": {
"id": "={{ $json.id }}",
"Opt-in": false
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Opt-in",
"type": "boolean",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Opt-in",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Campaign",
"type": "boolean",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Campaign",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Checked Email",
"type": "boolean",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Checked Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Calcul",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Calcul",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "INTERACTION",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "INTERACTION",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "Psqhq4DEUuvikWZJ",
"name": "Airtable GS"
}
},
"typeVersion": 2.1
},
{
"id": "d9dcdd1d-4481-46cb-b72c-783642a797c3",
"name": "付箋メモ2",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
256
],
"parameters": {
"color": 4,
"width": 188,
"height": 80,
"content": "### ✉️ Delivred Email"
},
"typeVersion": 1
},
{
"id": "fa23de10-55a7-46c8-b1ca-aca96c8f6310",
"name": "付箋メモ3",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
640
],
"parameters": {
"color": 4,
"width": 188,
"height": 80,
"content": "### ✉️ Clicked Email"
},
"typeVersion": 1
},
{
"id": "6a47d115-c711-4060-b7f6-12e9dfe0e780",
"name": "付箋メモ4",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
448
],
"parameters": {
"color": 4,
"width": 188,
"height": 80,
"content": "### ✉️ Opened Email"
},
"typeVersion": 1
},
{
"id": "6930845f-383e-4734-a77a-711a9f5200ed",
"name": "付箋メモ5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1136,
832
],
"parameters": {
"color": 3,
"width": 236,
"height": 80,
"content": "### ✉️ Unsubscribed Request\nUpdate of Opt-in Status"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"9d66fbd6-6d7b-41c8-95e6-fba126e9f447": {
"main": [
[
{
"node": "505840ce-982f-432b-8b3f-8c33087379e8",
"type": "main",
"index": 0
}
]
]
},
"02d02732-9eec-402a-8351-8d003056d265": {
"main": [
[
{
"node": "60aae98a-2ecd-40b4-af40-5fa4705acae1",
"type": "main",
"index": 0
}
],
[
{
"node": "3d512b07-91f6-4cb8-a262-1aae02f0fa86",
"type": "main",
"index": 0
}
],
[
{
"node": "5637b700-2b79-43c8-963a-accd06cccf80",
"type": "main",
"index": 0
}
],
[
{
"node": "48fbfe3f-d96b-461c-bdb7-7f2dd283c297",
"type": "main",
"index": 0
}
]
]
},
"808ce229-b3c8-4c07-a40f-8b37fbcf61b7": {
"main": [
[
{
"node": "6824bcdc-381d-4143-9081-f28450640202",
"type": "main",
"index": 0
}
]
]
},
"a85ae7c1-cba1-4cfa-9a4f-4e6d8d37bec7": {
"main": [
[
{
"node": "e0a41139-df0a-4c79-ba10-838c1d1cffe8",
"type": "main",
"index": 0
}
]
]
},
"6824bcdc-381d-4143-9081-f28450640202": {
"main": [
[
{
"node": "30306b08-dff4-4c02-b101-0856e30d8a4e",
"type": "main",
"index": 0
}
]
]
},
"4ef43cb4-9e4b-458f-8108-a3a1b51a4cb9": {
"main": [
[
{
"node": "505840ce-982f-432b-8b3f-8c33087379e8",
"type": "main",
"index": 0
}
]
]
},
"505840ce-982f-432b-8b3f-8c33087379e8": {
"main": [
[],
[
{
"node": "af8f6f63-10aa-47e5-b631-63171d6a6767",
"type": "main",
"index": 0
}
]
]
},
"48fbfe3f-d96b-461c-bdb7-7f2dd283c297": {
"main": [
[
{
"node": "55f4df06-afe0-4607-8b93-91abda5e4853",
"type": "main",
"index": 0
}
]
]
},
"e0a41139-df0a-4c79-ba10-838c1d1cffe8": {
"main": [
[
{
"node": "9d66fbd6-6d7b-41c8-95e6-fba126e9f447",
"type": "main",
"index": 0
}
]
]
},
"30306b08-dff4-4c02-b101-0856e30d8a4e": {
"main": [
[
{
"node": "02d02732-9eec-402a-8351-8d003056d265",
"type": "main",
"index": 0
}
]
]
},
"210abf6c-eb2f-4bc2-9b72-95855961bb37": {
"main": [
[
{
"node": "4ef43cb4-9e4b-458f-8108-a3a1b51a4cb9",
"type": "main",
"index": 0
}
]
]
},
"af8f6f63-10aa-47e5-b631-63171d6a6767": {
"main": [
[
{
"node": "a85ae7c1-cba1-4cfa-9a4f-4e6d8d37bec7",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - ソーシャルメディア, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
HubSpot 連絡先と SharePoint に AI 生成のニュースリリースと素材を生成
GPT-4o、AI画像・動画を使ってHubSpotとSharePointでバイリンガル・プレスリリースを作成
If
Set
Code
+
If
Set
Code
49 ノードplemeo
ソーシャルメディア
リアルタイム - GeminiとCreatomateを使ってウイルスのAI動画制作と投稿を自動化
AI動画制作とマルチプラットフォーム公開にはGeminiとCreatomateを活用しましょう
Set
Code
Wait
+
Set
Code
Wait
47 ノードIntuz
コンテンツ作成
自動化プロスペクト生成とパーソナライズされたアウトリーチ：Apollo、AI、Instantly.ai
自動化avic リード生成とパーソナライズドウォームアップ：Apollo、AI、アンドインスタンティエイトpty
If
Set
Code
+
If
Set
Code
166 ノードRuben AI
リードナーチャリング
Airtable、OpenAI、Unipile を使用した LinkedIn リード生成と自動ダイレクトメッセージングの自動化
Airtable、OpenAI、Unipileを使用した自動LinkedInリード生成とInMail投稿
If
Set
Code
+
If
Set
Code
143 ノードRuben AI
リードナーチャリング
Gemini AI と Airtable から画像で Shopify 製品一覧を生成
Gemini AI と Airtable を使用して、画像からShopify製品一覧を生成する
If
Set
Code
+
If
Set
Code
33 ノードMANISH KUMAR
コンテンツ作成
動画と画像の投稿 - 新しい Blotato ノード
Blotato と Airtable を使って 9 つのソーシャルプラットフォームにコンテンツを自動投稿する
Set
Code
Wait
+
Set
Code
Wait
51 ノードMax aka Mosheh
ソーシャルメディア
