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": "웹훅",
"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 동영상 제작 및 게시 자동화
Gemini와 Creatomate를 사용한 AI 비디오 제작 및 다중 플랫폼 게시 자동화
Set
Code
Wait
+
Set
Code
Wait
47 노드Intuz
콘텐츠 제작
잠재 리드 생성 및 개인화 아웃리치 자동화: Apollo, AI 및 Instantly.ai
잠재 고객 생성 및 개인화 아웃리치 자동화: Apollo, AI 및 Instantly.ai
If
Set
Code
+
If
Set
Code
166 노드Ruben AI
리드 육성
Airtable, OpenAI 및 Unipile을 사용한 자동화된 LinkedIn 잠재 고객 생성 및 개인 메시지 발송
Airtable, OpenAI 및 Unipile을 사용한 자동화된 LinkedIn 리드 생성 및 개인 메시지 발송
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
소셜 미디어
