自动化客户培育邮件和Notion中的客户评价收集
中级
这是一个Social Media领域的自动化工作流,包含 14 个节点。主要使用 Code, Telegram, EmailSend, ItemLists, HttpRequest 等节点。 基于Notion数据库跟踪的自动化客户培育邮件系统,在第7、30和60天发送个性化里程碑邮件,并通过Telegram通知
前置要求
- •Telegram Bot Token
- •可能需要目标 API 的认证凭证
分类
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"meta": {
"categories": [
"Business",
"CRM",
"Marketing",
"Automation"
],
"instanceId": "client-nurture-automation",
"description": "Automated client nurture email system that sends personalized milestone emails at 7, 30, and 60 days based on Notion database tracking with Telegram notifications",
"templateVersion": "1.0.0",
"templateCreatedBy": {
"id": "template-creator",
"name": "n8n Template Creator"
},
"templateCredentials": [
"notionApi",
"smtp",
"telegramApi"
]
},
"name": "自动化客户培育邮件和 Notion 中的客户评价收集",
"tags": [
"crm",
"email",
"notion",
"automation",
"nurture"
],
"nodes": [
{
"id": "sticky1",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
200
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "manual-trigger",
"name": "手动触发器",
"type": "n8n-nodes-base.manualTrigger",
"position": [
220,
320
],
"parameters": {},
"typeVersion": 1
},
{
"id": "schedule-trigger",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
220,
440
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "settings",
"name": "设置",
"type": "n8n-nodes-base.set",
"position": [
440,
380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "get-date",
"name": "获取日期",
"type": "n8n-nodes-base.code",
"position": [
660,
380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "query-notion",
"name": "查询 Notion",
"type": "n8n-nodes-base.httpRequest",
"position": [
880,
380
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "calculate",
"name": "计算",
"type": "n8n-nodes-base.code",
"position": [
1100,
380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "if-day7",
"name": "如果是第7天",
"type": "n8n-nodes-base.if",
"position": [
1320,
280
],
"parameters": {},
"typeVersion": 2
},
{
"id": "if-day30",
"name": "如果是第30天",
"type": "n8n-nodes-base.if",
"position": [
1320,
380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "if-day60",
"name": "如果是第60天",
"type": "n8n-nodes-base.if",
"position": [
1320,
480
],
"parameters": {},
"typeVersion": 2
},
{
"id": "email7",
"name": "第 7 天邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1540,
280
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "email30",
"name": "第 30 天邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1540,
380
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "email60",
"name": "第 60 天邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
1540,
480
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "telegram-notify",
"name": "Telegram 通知",
"type": "n8n-nodes-base.telegram",
"position": [
1760,
380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "webhook",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
220,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "parse",
"name": "解析",
"type": "n8n-nodes-base.code",
"position": [
440,
640
],
"parameters": {},
"typeVersion": 2
},
{
"id": "telegram-testimonial",
"name": "通知客户评价",
"type": "n8n-nodes-base.telegram",
"position": [
660,
640
],
"parameters": {},
"typeVersion": 1
},
{
"id": "respond",
"name": "响应",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
880,
640
],
"parameters": {},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"updatedAt": "2025-09-29T12:00:00.000Z",
"versionId": "1.0.0",
"staticData": null,
"connections": {
"Parse": {
"main": [
[
{
"node": "Notify Testimonial",
"type": "main",
"index": 0
}
]
]
},
"Webhook": {
"main": [
[
{
"node": "Parse",
"type": "main",
"index": 0
}
]
]
},
"Get Date": {
"main": [
[
{
"node": "Query Notion",
"type": "main",
"index": 0
}
]
]
},
"IF Day 7": {
"main": [
[],
[
{
"node": "Email Day 7",
"type": "main",
"index": 0
}
]
]
},
"Settings": {
"main": [
[
{
"node": "Get Date",
"type": "main",
"index": 0
}
]
]
},
"Calculate": {
"main": [
[
{
"node": "IF Day 7",
"type": "main",
"index": 0
},
{
"node": "IF Day 30",
"type": "main",
"index": 0
},
{
"node": "IF Day 60",
"type": "main",
"index": 0
}
]
]
},
"IF Day 30": {
"main": [
[],
[
{
"node": "Email Day 30",
"type": "main",
"index": 0
}
]
]
},
"IF Day 60": {
"main": [
[],
[
{
"node": "Email Day 60",
"type": "main",
"index": 0
}
]
]
},
"Email Day 7": {
"main": [
[
{
"node": "Telegram Notify",
"type": "main",
"index": 0
}
]
]
},
"Email Day 30": {
"main": [
[
{
"node": "Telegram Notify",
"type": "main",
"index": 0
}
]
]
},
"Email Day 60": {
"main": [
[
{
"node": "Telegram Notify",
"type": "main",
"index": 0
}
]
]
},
"Query Notion": {
"main": [
[
{
"node": "Calculate",
"type": "main",
"index": 0
}
]
]
},
"Manual Trigger": {
"main": [
[
{
"node": "Settings",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Settings",
"type": "main",
"index": 0
}
]
]
},
"Notify Testimonial": {
"main": [
[
{
"node": "Respond",
"type": "main",
"index": 0
}
]
]
}
},
"triggerCount": 2
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 社交媒体
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
从 Notion 自动化客户培育邮件和推荐收集
基于 Notion 数据库跟踪的自动化客户培育邮件系统,在第 7、30 和 60 天发送个性化里程碑邮件,附带 Telegram 通知
If
Set
Code
+7
20 节点Shelly-Ann Davy
社交媒体
从Notion自动执行客户培育邮件和评价收集
通过Telegram使用Google日历和Notion CRM自动化会议安排
If
Set
Code
+8
19 节点Shelly-Ann Davy
客服机器人
从Notion进行的客户培育邮件自动化
使用Notion、Email、Tally和Telegram自动化客户培育与评价收集
If
Code
Notion
+3
17 节点Shelly-Ann Davy
社交媒体
自动化客户培育邮件与Notion客户评价收集
使用WhatsApp、GPT-4V和Google Sheets提取并整理收据数据
If
Code
Notion
+7
18 节点Shelly-Ann Davy
发票处理
宁静 CFO 日出 — 软科技晨间简报(家庭 CEO)🌸
🌸 CFO 日出 — 面向家庭 CEO 的软科技晨间简报(n8n 模板)
Set
Cron
Open Ai
+6
15 节点Shelly-Ann Davy
个人效率
企业Reddit智能参与平台
基于AI的Reddit潜在客户生成与社区管理,具备高级评分功能
If
Code
Wait
+9
52 节点Shelly-Ann Davy
工作流信息
难度等级
中级
节点数量14
分类1
节点类型8
作者
Shelly-Ann Davy
@SheCodesFlowFounder of The Workflow Muse & @SheCodesFlow. I craft elegant, task-focused automations for creators, founders, and soft-tech enthusiasts. “Automate with grace. Scale with power.”
外部链接
在 n8n.io 查看 →
分享此工作流