Facebook线索管理：自动批量发送WhatsApp消息和电子邮件
高级
这是一个Lead Nurturing领域的自动化工作流，包含 18 个节点。主要使用 Code、Wait、Gmail、GoogleSheets、ManualTrigger 等节点。 Facebook线索管理：使用Gmail和Google Sheets自动回复电子邮件
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
- •Facebook Graph API 凭证
使用的节点 (18 个)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "giVBIt7WFacM8ujc",
"meta": {
"instanceId": "cb9a1e5321767b6316634728341237e564b2587ab15b74ca0a89eb02a53484d6",
"templateCredsSetupCompleted": true
},
"name": "Facebook 线索管理：自动批量发送 WhatsApp 消息和电子邮件",
"tags": [],
"nodes": [
{
"id": "243082de-153c-4081-b421-c2690d13915f",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
1296,
464
],
"webhookId": "6c474e54-eb3c-4fcd-b455-948322cd0121",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "0360724c-9b37-405c-a9be-1107077a1774",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
464,
448
],
"parameters": {},
"typeVersion": 3
},
{
"id": "d8cd523e-ec3d-4211-bb5b-3f1b4d77e697",
"name": "点击开始",
"type": "n8n-nodes-base.manualTrigger",
"position": [
16,
544
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f809a897-f90e-4934-9df2-af71d280c44c",
"name": "由另一个工作流执行",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
16,
352
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "4732e301-3711-4a2f-89f4-d5749f5b3177",
"name": "Facebook 线索广告",
"type": "n8n-nodes-base.facebookLeadAdsTrigger",
"position": [
-272,
32
],
"webhookId": "f2c02f9a-f6f1-4f07-a953-2cbe6d9f2723",
"parameters": {},
"typeVersion": 1
},
{
"id": "5a310514-3060-4504-ab68-e6180fe61a3c",
"name": "格式化广告线索响应数据",
"type": "n8n-nodes-base.code",
"position": [
-48,
32
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8c60754c-c093-4b8a-8bfd-e5c5db005354",
"name": "在表格中保存广告线索",
"type": "n8n-nodes-base.googleSheets",
"position": [
176,
32
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "5bd4bc13-3292-492c-856b-4493cfe6ab09",
"name": "不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
400,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "edcded97-7794-4fb2-8628-c177fe6a3c7e",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
240,
448
],
"parameters": {},
"typeVersion": 4.7
},
{
"id": "547f9d37-251e-4f51-a7e5-ecdff32f1a2d",
"name": "发送电子邮件",
"type": "n8n-nodes-base.gmail",
"position": [
704,
464
],
"webhookId": "f8df583e-7b83-4e01-9603-a295ac6c45a5",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "f236c5cd-9acc-465a-b746-e5b0504b6f11",
"name": "保存已发送邮件的行状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
1024,
464
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "57b50511-c5bb-44c8-a9be-6053455ec0c2",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
-128
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0e277c68-1aaa-41eb-8712-e4800c1cc8db",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "7fa2848b-e556-468f-9b2c-1d6b02e35529",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
624,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2bdafef1-45f3-4c12-905e-485d3411d142",
"name": "### 需要帮助？",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-128
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b55eab3d-23b9-46f9-8e41-c542465583c0",
"name": "## 试试看！",
"type": "n8n-nodes-base.stickyNote",
"position": [
208,
240
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1eb17e7-d9d8-426b-a0db-3ae283dcd880",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1200,
-128
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fb1ce2cb-3b43-4307-87c8-1b18480ffdf1",
"name": "## 1. 创建新的自定义 OpenAI 凭据",
"type": "n8n-nodes-base.stickyNote",
"position": [
-368,
768
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "963cb86f-d882-4f20-b315-24bdea9a9583",
"connections": {
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Send a Email": {
"main": [
[
{
"node": "Save State of Rows in Email Sent",
"type": "main",
"index": 0
}
]
]
},
"Click to Start": {
"main": [
[
{
"node": "Get row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Send a Email",
"type": "main",
"index": 0
}
]
]
},
"Get row in sheet": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Facebook Lead Ads": {
"main": [
[
{
"node": "Format Ads Lead Response Data",
"type": "main",
"index": 0
}
]
]
},
"Save Ads Lead In Sheet": {
"main": [
[
{
"node": "Do Nothing",
"type": "main",
"index": 0
}
]
]
},
"Executed by Another Workflow": {
"main": [
[
{
"node": "Get row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Format Ads Lead Response Data": {
"main": [
[
{
"node": "Save Ads Lead In Sheet",
"type": "main",
"index": 0
}
]
]
},
"Save State of Rows in Email Sent": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
这是一个高级难度的工作流，适用于Lead Nurturing等场景。适合高级用户，包含 16+ 个节点的复杂工作流
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Facebook页面评论管理机器人：回复、删除、封禁和通知
AI驱动的Facebook评论管理：自动回复、删除、封禁和通知
If
Set
Code
+18
59 节点SpaGreen Creative
Social Media
使用Rapiwa API从Google表格自动化发送WhatsApp欢迎消息
使用Google表格和Rapiwa为销售线索自动化发送WhatsApp欢迎消息
If
Code
Wait
+6
17 节点SpaGreen Creative
Lead Nurturing
在可视化参考库中探索n8n节点
在可视化参考库中探索n8n节点
If
Ftp
Set
+93
113 节点I versus AI
Other
Shopify自动发送WhatsApp感谢消息和忠诚度优惠券（使用Rapiwa API）
使用Rapiwa从Shopify自动发送WhatsApp感谢消息和忠诚度优惠券
If
Code
Wait
+5
17 节点SpaGreen Creative
Content Creation
自动化高级潜在客户触达与培育活动系统（含AI）
通过GPT-4、LinkedIn和Hunter.io自动化个性化B2B触达
If
Code
Wait
+9
30 节点Marth
Lead Nurturing
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
Lead Generation
工作流信息
难度等级
高级
节点数量18
分类1
节点类型10
作者
SpaGreen Creative
@spagreenSpaGreen Creative is a leading software company specializing in SaaS solutions, AI automation, and Laravel/Vue.js development. With 800+ eCommerce platforms and 8,000+ global clients, we deliver powerful tools for OTT, CRM, ERP, and WhatsApp marketing. We combine innovation and tech to build scalable digital products.
外部链接
在 n8n.io 上查看 →
分享此工作流