8
n8n 中文网amn8n.com

冷/暖邮件自动化

高级

这是一个Lead Nurturing领域的自动化工作流，包含 19 个节点。主要使用 If, Set, Hunter, EmailSend, GoogleSheets 等节点。 使用Google Sheets、邮件验证和SMTP的自动冷邮件营销活动

前置要求
  • •Google Sheets API 凭证

使用的节点 (19)

If
Set
NoOp
Hunter
EmailSend
StickyNote
GoogleSheets
ManualTrigger
ScheduleTrigger

分类

客户培育
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "0NUf4DsJtFfnyxnp",
  "meta": {
    "instanceId": "b575ae39acc98e53d75e50d1b5147e8b0922704c4aeb3230092d8e2a78247bc3"
  },
  "name": "冷/暖邮件自动化",
  "tags": [],
  "nodes": [
    {
      "id": "8df39dbf-a9c7-4de0-9582-8946a312a35f",
      "name": "当点击\"执行工作流\"时",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        432,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3adc0f15-d7a2-4b23-b36d-eb0361167446",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        2096
      ],
      "parameters": {
        "color": 7,
        "height": 256,
        "content": "## **查找您的电子邮件服务提供商的 SMTP 信息 链接**"
      },
      "typeVersion": 1
    },
    {
      "id": "42a71dd2-654d-48ca-9e89-619402f9b65a",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        1584
      ],
      "parameters": {
        "color": 7,
        "width": 272,
        "height": 208,
        "content": "## **分步教程 YouTube 视频链接**"
      },
      "typeVersion": 1
    },
    {
      "id": "bb87b350-c396-4cd4-a266-1b58300cf261",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1584
      ],
      "parameters": {
        "color": 7,
        "width": 224,
        "height": 224,
        "content": "## **我使用的潜在客户示例 Google Sheet。**"
      },
      "typeVersion": 1
    },
    {
      "id": "5a7e7b8a-30ef-43fa-a290-23ccff275628",
      "name": "在上午 9 点安排触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        176,
        1392
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
      "name": "潜在客户表格 - 从表格获取行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        640,
        1392
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=drivesdk",
          "cachedResultName": "Leads"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "3a2a1244-2870-421b-a27b-ce9dba18eace",
      "name": "如果邮件状态为\"已发送\"则更新 Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2320,
        1744
      ],
      "parameters": {
        "columns": {
          "value": {
            "Tool Name": "={{ $('Google Sheets').item.json['Tool Name'] }}",
            "Email Sent": "={{ $json.accepted[0] }}"
          },
          "schema": [
            {
              "id": "Tool Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Tool Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Country",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Country",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Tool Link",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Tool Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Link to Apply Affiliate",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Link to Apply Affiliate",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "How to Work",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "How to Work",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Affiliate Link to Share",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Affiliate Link to Share",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Coupon Code",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Coupon Code",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reach Out Mode",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Reach Out Mode",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "How did you find?",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "How did you find?",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reach Out Platform",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Reach Out Platform",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Incoming",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Incoming",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Script",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Script",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Sent",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Ideas",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Ideas",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Tool Name"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 2051398108,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit#gid=2051398108",
          "cachedResultName": "AI tool reachout"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit?usp=drivesdk",
          "cachedResultName": "CF Calendar"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.6
    },
    {
      "id": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
      "name": "检查器 - 邮件是否已验证？",
      "type": "n8n-nodes-base.if",
      "position": [
        1568,
        1584
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json.result }}",
              "rightValue": "undeliverable"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "935d4058-b2e9-43f1-a887-defb038948c3",
      "name": "便签5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1264,
        1760
      ],
      "parameters": {
        "width": 208,
        "height": 192,
        "content": "## **添加邮件验证 API**"
      },
      "typeVersion": 1
    },
    {
      "id": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
      "name": "创建用于在 Google Sheets 中更新\"已发送\"状态的字段",
      "type": "n8n-nodes-base.set",
      "position": [
        2096,
        1744
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "05814c14-4365-4c37-af55-f28bf2ee5819",
              "name": "accepted[0]",
              "type": "string",
              "value": "Sent"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4f251ddb-b669-4b14-8255-ab47ab062516",
      "name": "无操作，不执行任何操作5",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1872,
        1424
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
      "name": "使用 Hunter 进行邮件验证",
      "type": "n8n-nodes-base.hunter",
      "position": [
        1312,
        1584
      ],
      "parameters": {
        "email": "={{ $json.Email }}",
        "operation": "emailVerifier"
      },
      "typeVersion": 1
    },
    {
      "id": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
      "name": "检查器 - 是否已\"已发送\"",
      "type": "n8n-nodes-base.if",
      "position": [
        864,
        1392
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "c72a013e-7b22-4bc7-a6c6-d51e9804ece7",
              "operator": {
                "type": "string",
                "operation": "contains"
              },
              "leftValue": "={{ $json['Email Sent'] }}",
              "rightValue": "Sent"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
      "name": "检查器 - 潜在客户的\"邮件\"字段是否为空？",
      "type": "n8n-nodes-base.if",
      "position": [
        1088,
        1488
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
      "name": "无操作，不执行任何操作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1040,
        1296
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
      "name": "无操作，不执行任何操作1",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1312,
        1392
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d98f7325-01c6-4e62-acc9-ca6bee188d39",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        576,
        1232
      ],
      "parameters": {
        "width": 224,
        "height": 128,
        "content": "## **连接到 Google Sheets 或 CRM**"
      },
      "typeVersion": 1
    },
    {
      "id": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
      "name": "使用 SMTP 发送邮件",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1872,
        1744
      ],
      "webhookId": "3a2cb249-8183-4481-8df7-5fcdd2c52881",
      "parameters": {
        "text": "=Hello {{ $('Lead Sheet - Get Rows from the sheet').item.json['Tool Name'] }} team, \n\nWe can collborate on multiple features. Can we have a quick meet over the meet?\n\nBest regards,\nJanak",
        "options": {},
        "subject": "Let's collaborate!",
        "toEmail": "={{ $('Lead Sheet - Get Rows from the sheet').item.json.Email }}",
        "fromEmail": "support@dolphy.io",
        "emailFormat": "text"
      },
      "executeOnce": false,
      "typeVersion": 2.1
    },
    {
      "id": "2188bf86-d2d8-48c2-9783-954d3c879089",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1824,
        1920
      ],
      "parameters": {
        "width": 224,
        "height": 128,
        "content": "## **使用 SMTP 发送邮件 - 任何邮件提供商都适用**"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d5347202-25e6-43fd-aca3-2e53eef114c0",
  "connections": {
    "Send email using SMTP": {
      "main": [
        [
          {
            "node": "Creating Field for Updating \"Sent\" in G Sheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email verification using Hunter": {
      "main": [
        [
          {
            "node": "Checker - If emails are verified or no?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Checker - If Already \"Sent\" or not": {
      "main": [
        [
          {
            "node": "No Operation, Do Nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Checker - If Lead's \"Email\" Field is empty?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Lead Sheet - Get Rows from the sheet": {
      "main": [
        [
          {
            "node": "Checker - If Already \"Sent\" or not",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Lead Sheet - Get Rows from the sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Checker - If emails are verified or no?": {
      "main": [
        [
          {
            "node": "No Operation, do nothing5",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send email using SMTP",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Checker - If Lead's \"Email\" Field is empty?": {
      "main": [
        [
          {
            "node": "No Operation, Do Nothing1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Email verification using Hunter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Creating Field for Updating \"Sent\" in G Sheet1": {
      "main": [
        [
          {
            "node": "Updating GSheet if Email Is \"Sent\"",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

高级 - 客户培育

需要付费吗？

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

相关工作流推荐

使用 Browserflow 和 Google Sheets 跟踪自动化 LinkedIn 邀请
使用 Browserflow 和 Google Sheets 跟踪自动化 LinkedIn 邀请
If
Set
Wait
+8
23 节点Stéphane Heckel
客户培育
使用随机模板和Google Sheets追踪的自动冷邮件营销活动
使用随机模板和Google Sheets追踪的自动冷邮件营销活动
If
Set
Code
+7
20 节点Anir Agram
客户培育
YouTube SEO自动化1
使用GPT-4o和Runway从视频脚本生成YouTube SEO内容和缩略图
If
Set
Code
+6
19 节点Janak Patel
内容创作
AI生成的WordPress文章摘要块
WordPress文章的AI生成摘要块
If
Set
Slack
+14
32 节点Dataki
人工智能
Noco看板与AI优先级排序
使用AI分配请求并根据NocoDB看板状态发送提醒
If
Set
Slack
+11
27 节点Łukasz
客户支持
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
使用Gmail、OpenAI和Google表格自动化敏捷细化准备
If
Set
Gmail
+14
51 节点Willemijn
产品
工作流信息
难度等级
高级
节点数量19
分类1
节点类型9
难度说明

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

作者
Janak Patel

Janak Patel

@dolphyai
外部链接
在 n8n.io 查看 →

分享此工作流