8
n8n 中文网amn8n.com

CentralStationCRM中标记人员的简单邮件自动化

高级

这是一个Lead Nurturing领域的自动化工作流,包含 19 个节点。主要使用 If, Wait, Gmail, Slack, HttpRequest 等节点。 使用CentralStationCRM、Gmail和Slack提醒的自动邮件跟进系统

前置要求
  • Google 账号和 Gmail API 凭证
  • Slack Bot Token 或 Webhook URL
  • 可能需要目标 API 的认证凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "gsJVZsZPIb5Lngwn",
  "meta": {
    "instanceId": "68ab8a7bd891eafb85f915471f38591da0135936f93fdf7e27d0ebea24fea950",
    "templateCredsSetupCompleted": true
  },
  "name": "CentralStationCRM 中标记人员的简单邮件自动化",
  "tags": [],
  "nodes": [
    {
      "id": "1162956d-a0c7-49f2-9251-2c0af29f17a2",
      "name": "发送消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        336,
        -336
      ],
      "webhookId": "acf551ca-9814-4e8f-9f06-609443ed936e",
      "parameters": {
        "sendTo": "={{ $json.person.emails[0].name }}",
        "message": "=Hi {{ $json.person.salutation }} {{ $json.person.name }},\n\n#INSERT YOUR TEXT#\n\nBest regards\n\n#SIGNATURE#\n",
        "options": {
          "appendAttribution": false
        },
        "subject": "=Unser Gespräch",
        "emailType": "text"
      },
      "typeVersion": 2.1
    },
    {
      "id": "010d381e-0a38-4feb-a5d7-5b39cb94678f",
      "name": "定时任务:工作日 17:00",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -288,
        -320
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 17 * * 1-5"
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "b0b1b71d-8017-49a9-ae81-0226c0192401",
      "name": "移除重复项",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        1104,
        -96
      ],
      "parameters": {
        "compare": "selectedFields",
        "options": {
          "removeOtherFields": false
        },
        "fieldsToCompare": "from.value[0].address"
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "a92b9c44-3d4e-4fe6-ae18-0158970e4d9d",
      "name": "移除重复项1",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        1792,
        -80
      ],
      "parameters": {
        "compare": "selectedFields",
        "options": {
          "removeOtherFields": false
        },
        "fieldsToCompare": "from.value[0].address"
      },
      "typeVersion": 2,
      "alwaysOutputData": true
    },
    {
      "id": "a028cbd4-459f-4354-b82f-999022cac887",
      "name": "获取 CRM 更新",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -96,
        -320
      ],
      "parameters": {
        "url": "https://api.centralstationcrm.net/api/people",
        "options": {},
        "jsonQuery": "={\"filter\" : {\"updated_at\": {\"larger_than\": \"{{ new Date().beginningOf('day') }}\"}},\n\"includes\" : \"tags addrs companies emails\"}",
        "sendQuery": true,
        "sendHeaders": true,
        "specifyQuery": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "headerParameters": {
          "parameters": [
            {
              "name": "accept",
              "value": "application/json"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "c7037d7a-62f1-4484-8c82-2e33b72b6b20",
      "name": "测试标签",
      "type": "n8n-nodes-base.if",
      "position": [
        96,
        -320
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "or",
          "conditions": [
            {
              "id": "4b075c94-c553-4dee-a4f0-d0f501982c53",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.person.tags }}",
              "rightValue": "\"Outreach\""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "923918e9-5165-41e2-8272-e44811f5f64d",
      "name": "已回复?",
      "type": "n8n-nodes-base.if",
      "position": [
        848,
        -336
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "fde577e8-0f72-4ff5-a71e-f6cd4d512b95",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.id }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2
    },
    {
      "id": "1e2fe3c7-01dd-4c25-8897-b6b275b386bc",
      "name": "获取最近7天",
      "type": "n8n-nodes-base.gmail",
      "position": [
        672,
        -336
      ],
      "webhookId": "bd0cb35b-9cf9-4785-8695-d25e8f6db950",
      "parameters": {
        "limit": 10,
        "simple": false,
        "filters": {
          "q": "=from:  {{ $('test for tag').item.json.person.emails[0].name }}",
          "receivedAfter": "={{ new Date(Date.now() - 7 * 24 * 60 * 60 * 1000).toISOString() }}"
        },
        "options": {},
        "operation": "getAll"
      },
      "typeVersion": 2.1,
      "alwaysOutputData": true
    },
    {
      "id": "aed8bf29-5fb0-4730-9bea-b6193afcb7c5",
      "name": "提醒用户",
      "type": "n8n-nodes-base.slack",
      "position": [
        1280,
        -96
      ],
      "webhookId": "d4bc8854-ec94-4da7-b8b2-215879d9b480",
      "parameters": {
        "text": "=Hi #YOURNAME#,\n\nyour contact {{ $('test for tag').item.json.person.salutation }} {{ $('test for tag').item.json.person.name }} has responded.\n\nLook it up: \n\nhttps://mail.google.com/mail/u/0/#all/{{ $json.threadId }}",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": "U063KFE3KNW",
          "cachedResultName": "christian"
        },
        "select": "user",
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "executeOnce": false,
      "typeVersion": 2.3
    },
    {
      "id": "beab7970-9060-45c0-a30e-6befe4a4f6a2",
      "name": "发送另一条消息",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1088,
        -320
      ],
      "webhookId": "acf551ca-9814-4e8f-9f06-609443ed936e",
      "parameters": {
        "sendTo": "={{ $('get CRM updates').item.json.person.emails[0].name }}",
        "message": "=Hi {{ $('get CRM updates').item.json.person.salutation }} {{ $json.person.name }},\n\n##CONTENT OF YOUR SECOND MESSAGE##\n\nBest regards\n\n##SIGNATURE##\n\nSIGNATUR",
        "options": {
          "senderName": "Christian Lipowsky",
          "appendAttribution": false
        },
        "subject": "=Unser Gespräch",
        "emailType": "text"
      },
      "typeVersion": 2.1
    },
    {
      "id": "bd869007-756b-4478-82d8-3fa512155642",
      "name": "再次获取最近7天",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1344,
        -320
      ],
      "webhookId": "bd0cb35b-9cf9-4785-8695-d25e8f6db950",
      "parameters": {
        "limit": 10,
        "simple": false,
        "filters": {
          "q": "=from:  {{ $('test for tag').item.json.person.emails[0].name }}",
          "receivedAfter": "={{ new Date(Date.now() - 7 * 24 * 60 * 60 * 1000).toISOString() }}"
        },
        "options": {},
        "operation": "getAll"
      },
      "typeVersion": 2.1
    },
    {
      "id": "760630fa-970c-462b-bf30-210b0067417d",
      "name": "现在回复了吗?",
      "type": "n8n-nodes-base.if",
      "position": [
        1552,
        -320
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "loose"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "fde577e8-0f72-4ff5-a71e-f6cd4d512b95",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json.id }}",
              "rightValue": ""
            }
          ]
        },
        "looseTypeValidation": true
      },
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "aa362bbf-cd9c-4976-a01d-4cc71d7ad363",
      "name": "提醒用户1",
      "type": "n8n-nodes-base.slack",
      "position": [
        1952,
        -80
      ],
      "webhookId": "d4bc8854-ec94-4da7-b8b2-215879d9b480",
      "parameters": {
        "text": "=Hi #YOURNAME#,\n\nyour contact {{ $('test for tag').item.json.person.salutation }} {{ $('test for tag').item.json.person.name }} has responded.\n\nLook it up: \n\nhttps://mail.google.com/mail/u/0/#all/{{ $json.threadId }}",
        "user": {
          "__rl": true,
          "mode": "list",
          "value": "U063KFE3KNW",
          "cachedResultName": "christian"
        },
        "select": "user",
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "executeOnce": false,
      "typeVersion": 2.3
    },
    {
      "id": "c5d41c88-d813-4212-9f54-33d34993dcf2",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -1168
      ],
      "parameters": {
        "width": 528,
        "height": 592,
        "content": "![CSCRM Logo](https://s3.42he.com/cscrm-marketing-page-production/Logo_Central_Station_CRM_0dd02e23d2.jpeg)"
      },
      "typeVersion": 1
    },
    {
      "id": "e12d61d0-1380-46e7-ad80-922384f330a5",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -560
      ],
      "parameters": {
        "width": 528,
        "height": 128,
        "content": "## 本工作流使用的工具"
      },
      "typeVersion": 1
    },
    {
      "id": "56ca8d77-8820-4cab-9c0a-c5b5ca7845b4",
      "name": "等待7天",
      "type": "n8n-nodes-base.wait",
      "position": [
        512,
        -336
      ],
      "webhookId": "884a6f56-ccbd-47b6-9a7f-6980152dabfd",
      "parameters": {
        "unit": "days",
        "amount": 7
      },
      "typeVersion": 1.1
    },
    {
      "id": "f573b22b-c275-4094-a9b3-27b0494153df",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        -1328
      ],
      "parameters": {
        "color": 7,
        "width": 420,
        "height": 900,
        "content": "## 设置 CentralStationCRM API 密钥"
      },
      "typeVersion": 1
    },
    {
      "id": "05885492-a884-4612-a328-f270e01a5aab",
      "name": "## 为什么选择 4o 模型?👆",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        704,
        -1328
      ],
      "parameters": {
        "color": 7,
        "width": 440,
        "height": 900,
        "content": "## 设置 CentralStationCRM n8n 凭据"
      },
      "typeVersion": 1
    },
    {
      "id": "c43c8f76-e71f-4ee8-a0a1-4715b16b61c1",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1168,
        -1328
      ],
      "parameters": {
        "color": 7,
        "width": 868,
        "height": 892,
        "content": "## 设置 Slack 节点"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "85dd4cf8-4b8a-49df-89b7-f8566a255605",
  "connections": {
    "answered?": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "send another message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "alert user": {
      "main": [
        []
      ]
    },
    "wait 7 days": {
      "main": [
        [
          {
            "node": "get last 7 days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "replied now?": {
      "main": [
        [
          {
            "node": "Remove Duplicates1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "test for tag": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "wait 7 days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get CRM updates": {
      "main": [
        [
          {
            "node": "test for tag",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get last 7 days": {
      "main": [
        [
          {
            "node": "answered?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "alert user",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates1": {
      "main": [
        [
          {
            "node": "alert user1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Cron: weekday 17:00": {
      "main": [
        [
          {
            "node": "get CRM updates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "send another message": {
      "main": [
        [
          {
            "node": "get last 7 days again",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get last 7 days again": {
      "main": [
        [
          {
            "node": "replied now?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 客户培育

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

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

适合高级用户,包含 16+ 个节点的复杂工作流

作者
CentralStationCRM

CentralStationCRM

@centralstationcrm

CentralStationCRM ist das einfache und intuitive CRM für kleine Teams. Auf n8n teilen wir unsere Workflow-Ideen: für schnellere Abläufe und einen besseren Arbeitsalltag. CentralStationCRM is the simple and intuitive CRM for small businesses. On n8, we share CRM-workflow ideas to speed up your working life!

外部链接
在 n8n.io 查看

分享此工作流