8
n8n 中文网amn8n.com

我的工作流

中级

这是一个Sales, Marketing领域的自动化工作流，包含 12 个节点。主要使用 If, Gmail, Hunter, Discord, FormTrigger 等节点。 收集并丰富表单线索至Gmail、Google表格和Discord

前置要求
  • •Google 账号和 Gmail API 凭证
  • •Discord Bot Token 或 Webhook
  • •Google Sheets API 凭证

使用的节点 (12)

If
NoOp
Gmail
Hunter
Discord
StickyNote
FormTrigger
GoogleSheets

分类

销售
营销
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "yYjRbTWULZuNLXM0",
  "meta": {
    "instanceId": "616c00803b706b71f395da00f933102e3b493591ba0a653e82d0b9ed360368da"
  },
  "name": "我的工作流",
  "tags": [],
  "nodes": [
    {
      "id": "2125c56b-1c76-4219-847b-470f11865c01",
      "name": "n8n Form Trigger",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        180,
        300
      ],
      "webhookId": "5fb20488-aa11-4788-aa0f-73d40e7e4475",
      "parameters": {
        "path": "form",
        "options": {},
        "formTitle": "Form Title",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Name",
              "requiredField": true
            },
            {
              "fieldLabel": "Email",
              "requiredField": true
            },
            {
              "fieldType": "textarea",
              "fieldLabel": "Let us know your queries"
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "94f6684f-925b-4ded-a79f-ff44771ee992",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1220,
        280
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $json.Name }}",
            "Email": "={{ $json.Email }}",
            "Query": "={{ $json['Let us know your queries'] }}",
            "Submitted On": "={{ $json.submittedAt }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Query",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Query",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Submitted On",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Submitted On",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Name"
          ]
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zvlIZNAVFZ7lg9hch_zsNEIbmAhInUuwhiK2zWq0snA/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1zvlIZNAVFZ7lg9hch_zsNEIbmAhInUuwhiK2zWq0snA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1zvlIZNAVFZ7lg9hch_zsNEIbmAhInUuwhiK2zWq0snA/edit?usp=drivesdk",
          "cachedResultName": "Leads Data"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "7HR3jwkVoNgbw7fb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4a1d8a68-c976-4bf6-956a-6a29affdaed4",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1220,
        -40
      ],
      "parameters": {
        "sendTo": "yourmail@gmail.com",
        "message": "=Name:   {{ $json.Name }} \n\nEmail:  {{ $json.Email }} \n\nQuery:  {{ $json['Let us know your queries'] }} \n\nSubmitted on:  {{ $json.submittedAt }}",
        "options": {},
        "subject": "=New lead from {{ $json.Name }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "DrjEhQ0S42VeRofT",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "126d0ee3-de81-41ed-88f6-ffdeefae5576",
      "name": "Discord",
      "type": "n8n-nodes-base.discord",
      "position": [
        1240,
        620
      ],
      "parameters": {
        "embeds": {
          "values": [
            {
              "color": "#FF00F2",
              "title": "=New Lead from  {{ $json.Name }}",
              "author": "N8N Automation",
              "description": "=Name:   {{ $json.Name }} \n\nEmail:  {{ $json.Email }} \n\nQuery:  {{ $json['Let us know your queries'] }} \n\nSubmitted on:  {{ $json.submittedAt }}"
            }
          ]
        },
        "content": "=",
        "options": {},
        "authentication": "webhook"
      },
      "credentials": {
        "discordWebhookApi": {
          "id": "kuEJsXFqZfG48TDJ",
          "name": "Discord Webhook account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "4cd07d01-6d9a-4d0a-9999-9d66d99fb624",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        -100
      ],
      "parameters": {
        "width": 379.65154010753633,
        "height": 211.1881665582037,
        "content": "确保添加收件人地址以便接收通知"
      },
      "typeVersion": 1
    },
    {
      "id": "4e8eebfa-df98-473c-8666-c7768f641694",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1070,
        520
      ],
      "parameters": {
        "width": 399.1832608339331,
        "height": 246.28862362668644,
        "content": "有时邮件可能无法到达收件箱，这种情况很少发生，但如果您收到大量潜在客户，最好设置 Discord webhook 并通过该方式接收更新，以免收件箱被所有潜在客户填满"
      },
      "typeVersion": 1
    },
    {
      "id": "caff8f87-4e07-4125-bfd7-62a912b4ada9",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        220
      ],
      "parameters": {
        "width": 377.5924476942702,
        "height": 211.1881665582037,
        "content": "将数据映射到相关字段/列"
      },
      "typeVersion": 1
    },
    {
      "id": "c5e320e3-6489-4957-bb4e-e9873d001a66",
      "name": "如果",
      "type": "n8n-nodes-base.if",
      "position": [
        640,
        300
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d8c112a3-377c-4ca2-90d9-05c19f895ddb",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.Email }}",
              "rightValue": "="
            }
          ]
        }
      },
      "typeVersion": 2
    },
    {
      "id": "778ba29f-ed75-4706-830f-d906d28d45e3",
      "name": "Hunter",
      "type": "n8n-nodes-base.hunter",
      "position": [
        420,
        300
      ],
      "parameters": {
        "email": "={{ $json.Email }}",
        "operation": "emailVerifier"
      },
      "typeVersion": 1
    },
    {
      "id": "0021001b-0784-4983-a419-8bb491004133",
      "name": "无操作，不执行任何动作",
      "type": "n8n-nodes-base.noOp",
      "position": [
        640,
        500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "997da82a-618f-417a-be73-dd3cc0c70ee8",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        219.7136799847175
      ],
      "parameters": {
        "color": 4,
        "width": 456.2047033929433,
        "height": 435.9183833776615,
        "content": "仅在接收高流量潜在客户且希望避免虚假邮箱的假线索时使用"
      },
      "typeVersion": 1
    },
    {
      "id": "9b764ce3-66b5-44ff-8086-28812bc79db1",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        520,
        440
      ],
      "parameters": {
        "color": 3,
        "width": 314.12732687758046,
        "height": 209.4182179183868,
        "content": "如果邮箱无效或为虚假地址，则不会继续推进"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "callerPolicy": "workflowsFromSameOwner",
    "executionOrder": "v1",
    "saveManualExecutions": true
  },
  "versionId": "6455a6bd-0749-4c00-805b-a04ea6e34cc7",
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          },
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Discord",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail": {
      "main": [
        []
      ]
    },
    "Hunter": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Discord": {
      "main": [
        []
      ]
    },
    "n8n Form Trigger": {
      "main": [
        [
          {
            "node": "Hunter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 销售, 营销

需要付费吗？

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

相关工作流推荐

LinkedIn自动连接与销售个性化消息
LinkedIn自动连接与销售个性化消息
If
Set
Wait
+12
32 节点Vansh Arora
销售
AI营销代理：Reddit + OpenRouter + Gmail 潜在客户生成
AI营销代理：通过Reddit、OpenRouter和Gmail进行潜在客户生成
If
Set
Code
+12
23 节点Ari Nakos
销售
使用 MadKudu 和 Hunter 从 n8n 表单筛选优质潜在客户并在 Slack 上提醒
使用 MadKudu 和 Hunter 从 n8n 表单筛选优质潜在客户并在 Slack 上提醒
If
Slack
Hunter
+4
11 节点Mutasem
销售
实时Notion Todoist双向同步模板
使用Redis的Notion Todoist实时双向同步
If
Set
Code
+26
246 节点Mario
销售
使用 Hunter 和 Clearbit 验证并丰富表单潜在客户，然后添加到 Pipedrive
使用 Hunter 和 Clearbit 验证并丰富表单潜在客户，然后添加到 Pipedrive
If
Hunter
Clearbit
+4
15 节点Niklas Hatje
销售
验证邮箱并丰富新表单线索，保存至HubSpot
验证邮箱并丰富新表单线索，保存至HubSpot
If
Hunter
Hubspot
+4
11 节点Niklas Hatje
销售
工作流信息
难度等级
中级
节点数量12
分类2
节点类型8
难度说明

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

作者
M4JOR

M4JOR

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

分享此工作流