8
n8n 中文网amn8n.com

自动化客户培育邮件和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)可能需要您自行付费。

工作流信息
难度等级
中级
节点数量14
分类1
节点类型8
难度说明

适合有一定经验的用户,包含 6-15 个节点的中等复杂度工作流

作者
Shelly-Ann Davy

Shelly-Ann Davy

@SheCodesFlow

Founder 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 查看

分享此工作流