每日从NocoDB导入新联系人到Brevo
高级
这是一个Social Media, Multimodal AI领域的自动化工作流，包含 16 个节点。主要使用 If, NocoDb, SendInBlue, SplitInBatches, ScheduleTrigger 等节点。 每日从NocoDB导入已验证联系人到Brevo
前置要求
- •无特殊前置要求，导入即可使用
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "MIAB9TEo4WAoEXhr",
"meta": {
"instanceId": "c24388df44432e8ff2c4acecd7ab0dd2faec628bd83c70beb384cea105f7a50a",
"templateCredsSetupCompleted": true
},
"name": "每日从 NocoDB 导入新联系人到 Brevo",
"tags": [],
"nodes": [
{
"id": "b5f8e6d7-960f-45d6-a15d-9161200b3993",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-280,
0
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "f4f5e8bd-0e28-41c2-b0dd-342f68e4a74c",
"name": "检查参数是否为空",
"type": "n8n-nodes-base.if",
"position": [
340,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "edcfbe98-bc44-4400-9610-273b4b4ef999",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.first_name }}",
"rightValue": ""
},
{
"id": "1b5b2a35-277c-4970-ab32-a2b89185b2dc",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.last_name }}",
"rightValue": ""
},
{
"id": "58ac466e-4447-4a4b-8564-8ef14e388415",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "2a684591-5c13-42c2-a826-12c0305d3525",
"name": "检查是否为一次性邮箱",
"type": "n8n-nodes-base.if",
"position": [
700,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "4d399880-7a22-4ecd-91f6-2e395de7e375",
"operator": {
"type": "string",
"operation": "notRegex"
},
"leftValue": "={{ $json.email }}",
"rightValue": ".*(temp|abc|1234|yopmail|protonmail|mailinator|\\.cc|bigbester|fake|spam|gdf|sdf|mr123|passinbox|landininbox|@inbox|random|anony|mymail|mail\\.ru|\\.buzz|asdasd|asf|simplelogin|simplelogin\\.com|silomails\\.com|slmails\\.com|simplelogin\\.fr|aleeas\\.com|slmail\\.me|8shield\\.net|dralias\\.com|passinbox\\.com|passfwd\\.com|passmail\\.com|passmail\\.net|simplelogin\\.co|simplelogin\\.io|duck\\.com|mozmail\\.com|anonaddy\\.com|anonaddy\\.me|trash|guerrilla|getnada|owly|mvrht|sharklasers|anonbox).*"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "dba5e2e9-17d3-4a3f-b0c2-fc23b68b0fa5",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1020,
-200
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "0f6142d4-8aa1-4e2e-82a5-7adb0a89ba72",
"name": "Brevo：创建联系人",
"type": "n8n-nodes-base.sendInBlue",
"position": [
1320,
-200
],
"parameters": {
"email": "={{ $json.email }}",
"resource": "contact",
"requestOptions": {},
"createContactAttributes": {
"attributesValues": [
{
"fieldName": "FIRSTNAME",
"fieldValue": "={{ $json.first_name }}"
},
{
"fieldName": "LASTNAME",
"fieldValue": "={{ $json.last_name }}"
}
]
}
},
"credentials": {
"sendInBlueApi": {
"id": "YQK9pEnWrCzPOkw8",
"name": "Brevo account - U-test"
}
},
"typeVersion": 1
},
{
"id": "0e6921d1-3131-4ae9-ac50-783c57e61582",
"name": "NocoDB：获取新用户列表",
"type": "n8n-nodes-base.nocoDb",
"position": [
40,
0
],
"parameters": {
"table": "m5mxqjs3ae68oyc",
"options": {
"where": "(status,eq,0-not-imported)"
},
"operation": "getAll",
"projectId": "p4lnw5vwzf2yy3i",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "ec5753b4-d6fb-4444-b53d-1e6506c875bd",
"name": "NocoDB：将状态更改为 1-空字段",
"type": "n8n-nodes-base.nocoDb",
"position": [
340,
260
],
"parameters": {
"table": "m5mxqjs3ae68oyc",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "id",
"fieldValue": "={{ $json.Id }}"
},
{
"fieldName": "status",
"fieldValue": "1-empty-fields"
}
]
},
"operation": "update",
"projectId": "p4lnw5vwzf2yy3i",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "90227f77-8840-41ae-aaa9-fac355463c1f",
"name": "NocoDB：将状态更改为 2-一次性邮箱",
"type": "n8n-nodes-base.nocoDb",
"position": [
700,
260
],
"parameters": {
"table": "m5mxqjs3ae68oyc",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "id",
"fieldValue": "={{ $json.Id }}"
},
{
"fieldName": "status",
"fieldValue": "2-disposal-email"
}
]
},
"operation": "update",
"projectId": "p4lnw5vwzf2yy3i",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "3a539eb1-732a-4133-ac57-2760da656b5e",
"name": "NocoDB：将状态更改为 3-联系人已创建",
"type": "n8n-nodes-base.nocoDb",
"position": [
1620,
-200
],
"parameters": {
"table": "m5mxqjs3ae68oyc",
"fieldsUi": {
"fieldValues": [
{
"fieldName": "id",
"fieldValue": "={{ $('Loop Over Items').item.json.Id }}"
},
{
"fieldName": "status",
"fieldValue": "3-contact-created"
}
]
},
"operation": "update",
"projectId": "p4lnw5vwzf2yy3i",
"authentication": "nocoDbApiToken"
},
"credentials": {
"nocoDbApiToken": {
"id": "OmiCzu1TOrJhZRIa",
"name": "NocoDB Token account"
}
},
"typeVersion": 3
},
{
"id": "de4b9326-03cc-4f33-b244-63de98fbbabc",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
-160
],
"parameters": {
"color": 7,
"height": 340,
"content": "工作流每天在预定时间自动运行一次。"
},
"typeVersion": 1
},
{
"id": "a56f0f46-8c7a-4895-b42f-175636ed7853",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-40,
-160
],
"parameters": {
"color": 7,
"height": 340,
"content": "从 NocoDB 表中获取状态为 0-未导入的所有新用户记录。"
},
"typeVersion": 1
},
{
"id": "11d68333-74ff-4b32-8a1d-ffa918743a4d",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
260,
-160
],
"parameters": {
"color": 7,
"width": 280,
"height": 740,
"content": "在继续之前验证必填字段：first_name、last_name 和 email 是否均已填写。"
},
"typeVersion": 1
},
{
"id": "2e1d7c71-d8ef-43e0-b601-ce5a5f8d3d60",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-160
],
"parameters": {
"color": 7,
"width": 280,
"height": 740,
"content": "在继续之前验证邮箱地址是否来自已知的一次性或临时邮箱提供商。"
},
"typeVersion": 1
},
{
"id": "f818f406-b2c8-487e-8bb2-bf02b57d3c3b",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
940,
-340
],
"parameters": {
"color": 7,
"height": 360,
"content": "一次处理一条记录，以避免批量创建联系人造成高负载。"
},
"typeVersion": 1
},
{
"id": "ac098881-8bb3-4214-8502-bba7f92c3bed",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-340
],
"parameters": {
"color": 7,
"height": 360,
"content": "使用提供的 first_name、last_name 和 email 在 Brevo 中创建新联系人。"
},
"typeVersion": 1
},
{
"id": "ac752d01-6d5c-44e0-abe0-b065a1d4bd40",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1540,
-340
],
"parameters": {
"color": 7,
"height": 360,
"content": "在联系人成功添加到 Brevo 后，在 NocoDB 中将记录状态更新为 3-联系人已创建。"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "74b9415d-63fe-4bb2-b782-beeb6faf0dae",
"connections": {
"Loop Over Items": {
"main": [
[],
[
{
"node": "Brevo: Create Contact",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "NocoDB: Get new users list",
"type": "main",
"index": 0
}
]
]
},
"Brevo: Create Contact": {
"main": [
[
{
"node": "NocoDB: change status to 3-contact-created",
"type": "main",
"index": 0
}
]
]
},
"Check if email is Disposal": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
],
[
{
"node": "NocoDB: change status to 2-disposal-email",
"type": "main",
"index": 0
}
]
]
},
"NocoDB: Get new users list": {
"main": [
[
{
"node": "Check if parameters are not empty",
"type": "main",
"index": 0
}
]
]
},
"Check if parameters are not empty": {
"main": [
[
{
"node": "Check if email is Disposal",
"type": "main",
"index": 0
}
],
[
{
"node": "NocoDB: change status to 1-empty-fields",
"type": "main",
"index": 0
}
]
]
},
"NocoDB: change status to 3-contact-created": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
营销自动化系统 (eCRM) - NocoDB 与 Brevo
使用 NocoDB 和 Brevo 实现邮件营销活动自动化
If
Set
Wait
+6
30 节点Nima Salimi
社交媒体
将 Brevo 联系人报告插入 NocoDB
将 Brevo 联系人报告插入 NocoDB
If
Set
Code
+8
26 节点Nima Salimi
内容创作
Arunava的多智能体智能Reddit自动化
使用AI品牌提及和Baserow跟踪自动评论Reddit帖子
If
Set
Code
+12
35 节点Arunava
社交媒体
使用GPT-4o-mini、表格和Slack自动化Reddit品牌监控和回复
通过GPT-4o-mini、表格和Slack实现Reddit品牌监控和回复的自动化
If
Code
Slack
+6
20 节点Daniel Shashko
社交媒体
带跟进与回复追踪的自动邮件群发
带跟进与回复追踪的自动邮件群发
If
Gmail
Switch
+5
11 节点Oneclick AI Squad
社交媒体
我的工作流79
使用Google Sheets和MailerSend构建完整的电子邮件CRM系统
If
Set
Wait
+6
34 节点Nima Salimi
社交媒体
工作流信息
难度等级
高级
节点数量16
分类2
节点类型6
作者
Nima Salimi
@salimiWith a deep understanding of marketing processes and data flows, I create solutions that streamline user engagement, campaign management, and data synchronization across multiple platforms. My goal is to help businesses reduce manual effort, improve accuracy, and accelerate their marketing initiatives through smart automation.
外部链接
在 n8n.io 查看 →
分享此工作流