使用 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": "## 邮件发送工作流"
},
"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": "## 邮件事件跟踪工作流"
},
"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": "### ✉️ 邮件已送达"
},
"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": "### ✉️ 邮件已点击"
},
"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": "### ✉️ 邮件已打开"
},
"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": "### ✉️ 取消订阅请求"
},
"typeVersion": 1
}
],
"pinData": {},
"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 ‘Execute workflow’": {
"main": [
[
{
"node": "Search Company",
"type": "main",
"index": 0
}
]
]
},
"Send an email with an existing Template": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
为 HubSpot 联系人和 SharePoint 生成 AI 撰写的新闻稿和素材
使用 GPT-4o、AI 图像和视频为 HubSpot 和 SharePoint 创建双语新闻稿
If
Set
Code
+15
49 节点plemeo
社交媒体
实时 - 使用Gemini和Creatomate自动化病毒式AI视频制作与发布
使用Gemini和Creatomate自动化AI视频创作与多平台发布
Set
Code
Wait
+15
47 节点Intuz
内容创作
自动化潜在客户生成与个性化外联：Apollo、AI和Instantly.ai
自动化潜在客户生成与个性化外联：Apollo、AI和Instantly.ai
If
Set
Code
+15
166 节点Ruben AI
客户培育
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
使用Airtable、OpenAI和Unipile的自动化LinkedIn潜在客户生成与私信触达
If
Set
Code
+15
143 节点Ruben AI
客户培育
使用 Gemini AI 和 Airtable 从图片生成 Shopify 产品列表
使用 Gemini AI 和 Airtable 从图片生成 Shopify 产品列表
If
Set
Code
+16
33 节点MANISH KUMAR
内容创作
使用 Google Drive 和 Meta Graph API 从 Google Sheets 上传视频和图片广告到 Meta Ads Manager
从 Google Sheets 和 Google Drive 上传视频和图片广告到 Meta Ads Manager
If
Set
Code
+11
42 节点Daniel Setzermann
社交媒体
