10 跟踪电子邮件营销活动表现
高级
这是一个Social Media, AI Summarization领域的自动化工作流，包含 17 个节点。主要使用 If, Set, Gmail, McpClientTool, Agent 等节点。 使用 Bright Data 和 OpenAI 自动化邮件营销活动分析与智能跟进
前置要求
- •Google 账号和 Gmail API 凭证
- •OpenAI API Key
使用的节点 (17)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "P6LeLqxzbkO3FiPE",
"meta": {
"instanceId": "60046904b104f0f72b2629a9d88fe9f676be4035769f1f08dad1dd38a76b9480",
"templateCredsSetupCompleted": true
},
"name": "10 跟踪电子邮件营销活动表现",
"tags": [],
"nodes": [
{
"id": "75f14163-7400-49fe-aeb9-1f983dfe0c5e",
"name": "⏰ 每日营销活动检查触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-60,
0
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "3d85c239-8871-48ce-aecc-581a4a4be75c",
"name": "✏️ 设置营销活动输入字段",
"type": "n8n-nodes-base.set",
"position": [
160,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "04df454e-d477-4dd4-a029-2c97cfd1bf8f",
"name": "url",
"type": "string",
"value": "=https://www.mailchimp.com/campaigns/123/report"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "197f6678-606d-4e9d-91b9-2ed48fe6799c",
"name": "🤖 助手：抓取并分析营销活动表现",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
520,
0
],
"parameters": {
"options": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2
},
{
"id": "0fa379ec-3e22-4f69-97dc-c45e244121c6",
"name": "🧠 LLM：总结并格式化",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
500,
300
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "d1a27651-f1b3-412e-8452-563eba14c7d0",
"name": "🌐 Bright Data MCP：抓取报告",
"type": "n8n-nodes-mcp.mcpClientTool",
"position": [
680,
300
],
"parameters": {
"toolName": "scrape_as_markdown",
"operation": "executeTool",
"toolParameters": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Tool_Parameters', ``, 'json') }}"
},
"credentials": {
"mcpClientApi": {
"id": "eqq94k789oJCd6jU",
"name": "MCP Client (STDIO) account"
}
},
"typeVersion": 1
},
{
"id": "fb814c29-e412-4332-ae43-b5f8ce4f0783",
"name": "🔎 IF：打开率≥30%且点击率<10%？",
"type": "n8n-nodes-base.if",
"position": [
1100,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d5c41a60-cadf-47a6-9685-9bead865346d",
"operator": {
"type": "number",
"operation": "gte"
},
"leftValue": "={{ $json.open_rate }}",
"rightValue": 20
},
{
"id": "7a251b0b-a122-418d-8b0c-6714ebfa6018",
"operator": {
"type": "number",
"operation": "lt"
},
"leftValue": "={{ $json.ctr }}",
"rightValue": 130
}
]
}
},
"typeVersion": 2.2
},
{
"id": "b77a5854-6882-47ac-8dba-9af0bdcc0e1f",
"name": "📧 发送跟进参与电子邮件",
"type": "n8n-nodes-base.gmail",
"position": [
1340,
-100
],
"webhookId": "0fd0b382-f827-4262-a3de-4df28f33fb10",
"parameters": {
"sendTo": "shahkar.genai@gmail.com",
"message": "Hi [First Name], \nWe noticed you opened our recent email — thank you for staying connected! \n🙌 But we think you might have missed the best part… \n👉 [Big Benefit or Offer — e.g., “Get 20% off your next order — today only!”] \nWe don’t want you to miss out — just click below and grab your exclusive [deal / resource / upgrade]. \n[CTA Button: “Claim Your Offer”] Still not sure? We’re here to help if you have any questions. Just hit reply — we love hearing from you! Talk soon, [Your Name] [Your Company]",
"options": {},
"subject": "Did you miss this? Here’s something special for you!",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "AQDSl75AdzK3vmqJ",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "1259660d-e04c-4708-9319-22749360bdc3",
"name": "🚫 跳过 — 无需操作",
"type": "n8n-nodes-base.noOp",
"position": [
1340,
100
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6e673900-d27b-4aba-be1d-8d9149fa6ceb",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-120,
-1180
],
"parameters": {
"color": 6,
"width": 420,
"height": 1360,
"content": "## 🎯 **🔹 第一部分：计划并准备输入**"
},
"typeVersion": 1
},
{
"id": "d722faa7-9304-4145-9e22-f90b71b02053",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
440,
-1300
],
"parameters": {
"color": 3,
"width": 420,
"height": 1480,
"content": "## 🤖 **🔹 第二部分：使用AI助手抓取和分析**"
},
"typeVersion": 1
},
{
"id": "031503cb-3fa4-46b6-9b57-529b10553ec2",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1060,
-840
],
"parameters": {
"color": 5,
"width": 420,
"height": 1100,
"content": "## 📈 **🔹 第三部分：自动决策并行动**"
},
"typeVersion": 1
},
{
"id": "4502ee4c-219e-4495-b4ff-c8b3beec55e8",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1560,
-920
],
"parameters": {
"color": 7,
"width": 380,
"height": 240,
"content": "## 如果您通过此链接加入 Bright Data，我将获得少量佣金——感谢您支持更多免费内容！"
},
"typeVersion": 1
},
{
"id": "07751162-2ade-4591-93bc-a3dc2414553d",
"name": "### 替换 Airtable 连接",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1980,
-1180
],
"parameters": {
"color": 4,
"width": 1300,
"height": 320,
"content": "======================================="
},
"typeVersion": 1
},
{
"id": "6c9e1f76-b6d0-4915-8f05-ada92abfcd89",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1980,
-840
],
"parameters": {
"color": 4,
"width": 1289,
"height": 3118,
"content": "# 动态电子邮件重新参与自动化"
},
"typeVersion": 1
},
{
"id": "237aeaf4-64f1-411b-a013-9209f46fa320",
"name": "自动修复输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
"position": [
840,
300
],
"parameters": {
"options": {}
},
"typeVersion": 1
},
{
"id": "f86d1724-c0c3-4820-9699-44f2d4101054",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
800,
560
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "8sEyPDkC5p4w4Jha",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "41e646ea-effa-40c0-8513-7fecd83762ee",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
980,
560
],
"parameters": {
"jsonSchemaExample": "{\n \"campaign_name\": \"Summer Promo Blast\",\n \"campaign_id\": \"123456789\",\n \"date_sent\": \"2025-06-29\",\n \"unique_opens\": 1230,\n \"total_opens\": 1590,\n \"open_rate\": 47,\n \"unique_clicks\": 530,\n \"total_clicks\": 670,\n \"ctr\": 20,\n \"soft_bounces\": 25,\n \"hard_bounces\": 10,\n \"bounce_rate\": 1.8,\n \"unsubscribed\": 15,\n \"unsubscribe_rate\": 0.6\n}\n"
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "226f422b-33c6-4834-8653-5f7a501d9955",
"connections": {
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Auto-fixing Output Parser",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Auto-fixing Output Parser": {
"ai_outputParser": [
[
{
"node": "🤖 Agent: Scrape & Analyze Campaign Performance",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"🧠 LLM: Summarize & Format": {
"ai_languageModel": [
[
{
"node": "🤖 Agent: Scrape & Analyze Campaign Performance",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"⏰ Daily Campaign Check Trigger": {
"main": [
[
{
"node": "✏️ Set Campaign Input Fields",
"type": "main",
"index": 0
}
]
]
},
"✏️ Set Campaign Input Fields": {
"main": [
[
{
"node": "🤖 Agent: Scrape & Analyze Campaign Performance",
"type": "main",
"index": 0
}
]
]
},
"🔎 IF: Open ≥30% & CTR <10%?": {
"main": [
[
{
"node": "📧 Send Follow-Up Engagement Email",
"type": "main",
"index": 0
}
],
[
{
"node": "🚫 Skip — No Action Needed",
"type": "main",
"index": 0
}
]
]
},
"🌐 Bright Data MCP: Scrape Report": {
"ai_tool": [
[
{
"node": "🤖 Agent: Scrape & Analyze Campaign Performance",
"type": "ai_tool",
"index": 0
}
]
]
},
"🤖 Agent: Scrape & Analyze Campaign Performance": {
"main": [
[
{
"node": "🔎 IF: Open ≥30% & CTR <10%?",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 社交媒体, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
23 分析客户终身价值
使用GPT-4和Bright Data MCP分析与定位高价值客户
If
Set
Code
+9
20 节点Yaron Been
市场调研
17 跟踪库存水平
自动化亚马逊库存水平追踪，使用Bright Data MCP和OpenAI
If
Set
Gmail
+8
17 节点Yaron Been
工程
11 监控社交媒体广告表现
使用 Bright Data MCP 监控社交媒体广告表现并发送告警
If
Set
Code
+9
19 节点Yaron Been
市场调研
22 监控流失指标
使用Bright Data MCP和OpenAI监控客户流失指标
If
Set
Code
+10
20 节点Yaron Been
客户关系管理
4跟踪竞争对手网站更新
使用Bright Data MCP和OpenAI的自动竞争对手价格监控
If
Set
Google Sheets
+8
18 节点Yaron Been
市场调研
15 个追踪反向链接机会
使用 Bright Data MCP 和 GPT-4o 追踪并分析反向链接机会
If
Set
Gmail
+9
19 节点Yaron Been
市场调研
工作流信息
难度等级
高级
节点数量17
分类2
节点类型11
作者
Yaron Been
@yaron-nofluffBuilding AI Agents and Automations | Growth Marketer | Entrepreneur | Book Author & Podcast Host If you need any help with Automations, feel free to reach out via linkedin: https://www.linkedin.com/in/yaronbeen/ And check out my Youtube channel: https://www.youtube.com/@YaronBeen/videos
外部链接
在 n8n.io 查看 →
分享此工作流