使用Gmail、Google表格和Slack通知的批量邮件发送与追踪
中级
这是一个Marketing领域的自动化工作流，包含 10 个节点。主要使用 Wait, Gmail, Slack, Switch, GoogleSheets 等节点。 使用Gmail、Google表格和Slack通知的批量邮件发送与追踪
前置要求
- •Google 账号和 Gmail API 凭证
- •Slack Bot Token 或 Webhook URL
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "28099d2544433ae0f39c65315a4d4c531947fcb0f060a94d6047d7be5df31063",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "abb38b5f-3e0d-449a-8aa5-65cacac5bdcf",
"name": "Gmail1",
"type": "n8n-nodes-base.gmail",
"position": [
-140,
260
],
"webhookId": "7991dbd6-9db7-4a38-ab95-b4c9756b93ee",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "cdae80d4-4f4a-4291-a41c-0c77406eef53",
"name": "等待4",
"type": "n8n-nodes-base.wait",
"position": [
220,
260
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "ebb78ca4-059a-4e3f-be69-5380d62ba9d9",
"name": "Google Sheets8",
"type": "n8n-nodes-base.googleSheets",
"position": [
-840,
140
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "ad52a0d8-37af-4181-a023-87986dbd2a8f",
"name": "遍历项目4",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-620,
140
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9007c279-f456-4d98-8e89-b012875fd687",
"name": "Google Sheets9",
"type": "n8n-nodes-base.googleSheets",
"position": [
40,
260
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "ee34e264-6f1c-4009-b401-ad6276ebd732",
"name": "分支2",
"type": "n8n-nodes-base.switch",
"position": [
-380,
240
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "bac9dd7f-ea4d-4aa0-a681-3c3ac12223e7",
"name": "Slack",
"type": "n8n-nodes-base.slack",
"position": [
-400,
40
],
"webhookId": "806ebfab-0c1c-4011-b116-7d06dbf16ec4",
"parameters": {},
"typeVersion": 2.3
},
{
"id": "20bb811a-706e-4729-aef0-a95ddeb38932",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5d99e02c-b946-4f80-8393-35cd6aaf5e89",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1480,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ecdc3aa2-b779-4717-b1cd-f8366093d76c",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1060,
140
],
"parameters": {},
"typeVersion": 1.2
}
],
"pinData": {},
"connections": {
"Wait4": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Gmail1": {
"main": [
[
{
"node": "Google Sheets9",
"type": "main",
"index": 0
}
]
]
},
"Switch2": {
"main": [
[
{
"node": "Gmail1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets8": {
"main": [
[
{
"node": "Loop Over Items4",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets9": {
"main": [
[
{
"node": "Wait4",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items4": {
"main": [
[
{
"node": "Slack",
"type": "main",
"index": 0
}
],
[
{
"node": "Switch2",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Google Sheets8",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
Gmail冷邮件序列，含Google Sheets跟踪与Slack通知
Gmail冷邮件序列，含Google Sheets跟踪与Slack通知
If
Set
Wait
+8
62 节点Electrabot
营销
LinkedIn自动连接与销售个性化消息
LinkedIn自动连接与销售个性化消息
If
Set
Wait
+12
32 节点Vansh Arora
销售
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
使用GPT-4o、WordPress和LinkedIn发布自动化RSS内容到博客文章
If
Set
Code
+21
40 节点Immanuel
人工智能
LinkedIn自动连接与销售个性化消息-N8N
LinkedIn自动连接与销售个性化消息-N8N
If
Set
Wait
+12
33 节点Vansh Arora
自动化新闻到简报AI代理v13
AI新闻研究团队：24/7简报自动化，含Perplexity引用
Set
Code
Gmail
+15
37 节点Derek Cheung
产品
广告监测工具（含AI模型名称：GPT-4、Gemini）
广告监测工具（含AI模型名称：GPT-4、Gemini）
Wait
Filter
Switch
+7
29 节点Electrabot
市场调研
工作流信息
难度等级
中级
节点数量10
分类1
节点类型8
作者
Electrabot
@vansh404AI Automation Agency Based In Canada Reach out to me if you need any help -https://www.linkedin.com/in/vansharoraa/
外部链接
在 n8n.io 查看 →
分享此工作流