Guy This workflow corresponds to n8n.io template #7318 — we link there as the canonical source.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "210abf6c-eb2f-4bc2-9b72-95855961bb37",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-160,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "505840ce-982f-432b-8b3f-8c33087379e8",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
288,
-80
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "9d66fbd6-6d7b-41c8-95e6-fba126e9f447",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
1072,
-64
],
"parameters": {
"amount": 3
},
"typeVersion": 1.1
},
{
"id": "244ab1e8-7626-4580-911a-a86d51ef6bd2",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-320
],
"parameters": {
"color": 5,
"width": 396,
"height": 200,
"content": "## Email Sending Workflow \n### \ud83d\udee0\ufe0f 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": "Send an email with an existing Template",
"type": "n8n-nodes-base.sendInBlue",
"position": [
512,
-64
],
"parameters": {
"operation": "sendTemplate",
"templateId": 2,
"receipients": "={{ $json.Email }}",
"requestOptions": {},
"additionalFields": {}
},
"credentials": {
"sendInBlueApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "a85ae7c1-cba1-4cfa-9a4f-4e6d8d37bec7",
"name": "Edit Fields",
"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": "Create Interaction",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "4ef43cb4-9e4b-458f-8108-a3a1b51a4cb9",
"name": "Search Company",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "d520cced-8037-4e1d-87dc-fadeadeec378",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-176,
208
],
"parameters": {
"color": 5,
"width": 396,
"height": 200,
"content": "## Email Event Tracking Workflow \n### \ud83d\udee0\ufe0f 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
],
"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": "Edit Fields1",
"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": "Search Interaction",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "60aae98a-2ecd-40b4-af40-5fa4705acae1",
"name": "Update Delivred",
"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\u00e9livr\u00e9": "={{ $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\u00e9t\u00e9",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Soci\u00e9t\u00e9",
"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\u00e9l\u00e9phone",
"value": "T\u00e9l\u00e9phone"
},
{
"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\u00e9finir 1",
"value": "A d\u00e9finir 1"
},
{
"name": "A d\u00e9finir 2",
"value": "A d\u00e9finir 2"
},
{
"name": "A d\u00e9finir 3",
"value": "A d\u00e9finir 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\u00e9livr\u00e9",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email D\u00e9livr\u00e9",
"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\u00e9",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Cliqu\u00e9",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Brevo Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "3d512b07-91f6-4cb8-a262-1aae02f0fa86",
"name": "Update Opened",
"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\u00e9t\u00e9",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Soci\u00e9t\u00e9",
"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\u00e9l\u00e9phone",
"value": "T\u00e9l\u00e9phone"
},
{
"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\u00e9finir 1",
"value": "A d\u00e9finir 1"
},
{
"name": "A d\u00e9finir 2",
"value": "A d\u00e9finir 2"
},
{
"name": "A d\u00e9finir 3",
"value": "A d\u00e9finir 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\u00e9livr\u00e9",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email D\u00e9livr\u00e9",
"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\u00e9",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email Cliqu\u00e9",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Brevo Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "5637b700-2b79-43c8-963a-accd06cccf80",
"name": "Update Clicked",
"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\u00e9": "={{ $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\u00e9t\u00e9",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Soci\u00e9t\u00e9",
"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\u00e9l\u00e9phone",
"value": "T\u00e9l\u00e9phone"
},
{
"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\u00e9finir 1",
"value": "A d\u00e9finir 1"
},
{
"name": "A d\u00e9finir 2",
"value": "A d\u00e9finir 2"
},
{
"name": "A d\u00e9finir 3",
"value": "A d\u00e9finir 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\u00e9livr\u00e9",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email D\u00e9livr\u00e9",
"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\u00e9",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email Cliqu\u00e9",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Brevo Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "48fbfe3f-d96b-461c-bdb7-7f2dd283c297",
"name": "Search Company2",
"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\u00e9t\u00e9'][0] }}\""
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "55f4df06-afe0-4607-8b93-91abda5e4853",
"name": "Update Company",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "d9dcdd1d-4481-46cb-b72c-783642a797c3",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
256
],
"parameters": {
"color": 4,
"width": 188,
"height": 80,
"content": "### \u2709\ufe0f Delivred Email"
},
"typeVersion": 1
},
{
"id": "fa23de10-55a7-46c8-b1ca-aca96c8f6310",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
640
],
"parameters": {
"color": 4,
"width": 188,
"height": 80,
"content": "### \u2709\ufe0f Clicked Email"
},
"typeVersion": 1
},
{
"id": "6a47d115-c711-4060-b7f6-12e9dfe0e780",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
448
],
"parameters": {
"color": 4,
"width": 188,
"height": 80,
"content": "### \u2709\ufe0f Opened Email"
},
"typeVersion": 1
},
{
"id": "6930845f-383e-4734-a77a-711a9f5200ed",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1136,
832
],
"parameters": {
"color": 3,
"width": 236,
"height": 80,
"content": "### \u2709\ufe0f Unsubscribed Request\nUpdate of Opt-in Status"
},
"typeVersion": 1
}
],
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "Update Delivred",
"type": "main",
"index": 0
}
],
[
{
"node": "Update Opened",
"type": "main",
"index": 0
}
],
[
{
"node": "Update Clicked",
"type": "main",
"index": 0
}
],
[
{
"node": "Search Company2",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Create Interaction",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Search Interaction",
"type": "main",
"index": 0
}
]
]
},
"Search Company": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Send an email with an existing Template",
"type": "main",
"index": 0
}
]
]
},
"Search Company2": {
"main": [
[
{
"node": "Update Company",
"type": "main",
"index": 0
}
]
]
},
"Create Interaction": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Search Interaction": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Search Company",
"type": "main",
"index": 0
}
]
]
},
"Send an email with an existing Template": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApisendInBlueApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This template automates the management of marketing campaign from a CRM based on Airtable, using Brevo for sending and tracking emails. Sending emails to targeted companies in Airtable, creating an interaction record for each sent email. Real-time tracking of events (email…
Source: https://n8n.io/workflows/7318/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This n8n workflow is a complete marketing automation system that connects to your CDP (Customer Data Platform), selects which flows to send, and delivers personalized emails using Brevo. It's modular
Noco Db, Sendinblue
This n8n workflow sends personalized marketing or outreach emails using predefined templates stored in Google Sheets, with SendGrid as the email delivery provider. Instead of relying on dynamic AI con
Google Sheets, SendGrid
This n8n workflow automates the entire lead generation pipeline from discovery to outreach: Location Grid Generation and Management Generates precise lat/lng grid points covering major US cities (New
Google Sheets, HTTP Request, SendGrid
Maximize your conversion rates with this end-to-end automated outreach and lead nurturing system. This workflow manages the entire sales lifecycle—from instant contact enrollment via WhatsApp to AI-pe
N8N Nodes Wati, Airtable, HTTP Request
This workflow automates the import of leads into the Company table of a CRM built with Airtable.
Data Table, Gmail, Airtable +1