Automatisierung von Marketingkampagnen mit Airtable CRM und Brevo-E-Mail-Tracking
Experte
Dies ist ein Social Media, Multimodal AI-Bereich Automatisierungsworkflow mit 22 Nodes. Hauptsächlich werden Set, Wait, Switch, Webhook, Airtable und andere Nodes verwendet. Automatisierung von Marketingkampagnen mit Airtable CRM und Brevo-E-Mail-Tracking
Voraussetzungen
- •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
- •Airtable API Key
Verwendete Nodes (22)
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
{
"meta": {
"instanceId": "ad48a01aec252f63ae8de1713711ab9e32029259011598511a3ef275db7ecb31",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "210abf6c-eb2f-4bc2-9b72-95855961bb37",
"name": "Bei Klick auf 'Workflow ausführen'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-160,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "505840ce-982f-432b-8b3f-8c33087379e8",
"name": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"position": [
288,
-80
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "9d66fbd6-6d7b-41c8-95e6-fba126e9f447",
"name": "Warten",
"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": "Notiz",
"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": "E-Mail mit vorhandener Vorlage senden",
"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": "Felder bearbeiten",
"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": "Interaktion erstellen",
"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": "Unternehmen suchen",
"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": "Notiz1",
"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": "Switch",
"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": "Felder bearbeiten1",
"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": "Interaktion suchen",
"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": "Zustellung aktualisieren",
"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": "Öffnung aktualisieren",
"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": "Klick aktualisieren",
"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": "Unternehmen suchen2",
"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": "Unternehmen aktualisieren",
"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": "Notiz2",
"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": "Notiz3",
"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": "Notiz4",
"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": "Notiz5",
"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
}
]
]
}
}
}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 - Soziale Medien, 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
KI-verfasste Pressemitteilungen und Materialien für HubSpot-Kontakte und SharePoint generieren
Erstelle zweisprachige Pressemitteilungen für HubSpot und SharePoint mit GPT-4o, KI-Bildern und -Videos
If
Set
Code
+
If
Set
Code
49 Nodesplemeo
Soziale Medien
Echtzeit - Automatisierung der viralen KI-Videoproduktion und -veröffentlichung mit Gemini und Creatomate
Automatisierte KI-Videoproduktion und -veröffentlichung auf mehreren Plattformen mit Gemini und Creatomate
Set
Code
Wait
+
Set
Code
Wait
47 NodesIntuz
Content-Erstellung
Automatisierte Lead-Generierung und personalisierte Ansprache: Apollo, AI und Instantly.ai
Automatisierung der Lead-Generierung und personalisierten Ansprache: Apollo, AI und Instantly.ai
If
Set
Code
+
If
Set
Code
166 NodesRuben AI
Lead-Pflege
Automatisierte Lead-Generierung und Direktnachrichten-Kontaktierung auf LinkedIn mit Airtable, OpenAI und Unipile
Automatisierte LinkedIn-Lead-Generierung und Direktnachrichten-Kontaktaufnahme mit Airtable, OpenAI und Unipile
If
Set
Code
+
If
Set
Code
143 NodesRuben AI
Lead-Pflege
Shopify-Produktliste aus Bildern mit Gemini AI und Airtable generieren
Shopify-Produktlisten aus Bildern mit Gemini AI und Airtable generieren
If
Set
Code
+
If
Set
Code
33 NodesMANISH KUMAR
Content-Erstellung
Veröffentlichung von Videos und Bildern - neuer Blotato-Knoten
Automatisches Veröffentlichen von Inhalten auf 9 Social-Media-Plattformen mit Blotato und Airtable
Set
Code
Wait
+
Set
Code
Wait
51 NodesMax aka Mosheh
Soziale Medien
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes22
Kategorie2
Node-Typen9
Autor
Guy
@guyExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen