8
n8n 中文网amn8n.com

AI 驱动的网站表单潜在客户评分与自动回复

高级

这是一个Lead Generation, AI Summarization领域的自动化工作流,包含 23 个节点。主要使用 Set, Gmail, Merge, Webhook, Telegram 等节点。 使用 GPT-4o 评估网站潜在客户,通过 Gmail 自动回复,并通过 Telegram 通知

前置要求
  • Google 账号和 Gmail API 凭证
  • HTTP Webhook 端点(n8n 会自动生成)
  • Telegram Bot Token
  • Google Sheets API 凭证
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "3BHghGUgnBAx64fz",
  "meta": {
    "instanceId": "25e77c0c6022d4bb0bf1d4755e6d167b4f61a12eba4f980e0349847ef576722f"
  },
  "name": "AI 驱动的网站表单潜在客户评分与自动回复",
  "tags": [],
  "nodes": [
    {
      "id": "9df79639-32c0-47c3-9919-c55377f53c0e",
      "name": "网站表单提交",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1200,
        336
      ],
      "webhookId": "435f6511-401f-4db2-abf6-ad282cd5d036",
      "parameters": {
        "path": "website-form-submissions",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 2
    },
    {
      "id": "e4665978-7d01-443b-9d96-2bac5ad7e430",
      "name": "保存到潜在客户数据库",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1168,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $json['Email'] }}",
            "Phone": "={{ $json['Phone'] }}",
            "Company": "={{ $json['Company Name'] }}",
            "Industry": "={{ $json['Industry'] }}",
            "Last Name": "={{ $json['Last Name'] }}",
            "First Name": "={{ $json['First Name'] }}",
            "Lead Score": "={{ $json.output }}",
            "Request Type": "={{ $json['Request Type'] }}",
            "Specific Request": "={{ $json['Specific Request'] }}"
          },
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ]
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "YOUR_GOOGLE_SHEET_ID"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "cvFlX6GaAZe3fuVA",
          "name": "Taoperformai"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "cb31a05e-1de1-4452-892e-e81240db9dee",
      "name": "通知销售团队",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1136,
        848
      ],
      "webhookId": "4a4be97d-b8bb-49d6-bec8-fc64a0aa6cef",
      "parameters": {
        "text": "=🔔 New Lead Submission!\n\n👤 Name: {{ $json['First Name'] }} {{ $json['Last Name'] }}\n🏢 Company: {{ $json['Company Name'] }}\n🏭 Industry: {{ $json['Industry'] }}\n📞 Phone: {{ $json['Phone'] }}\n📧 Email: {{ $json['Email'] }}\n\n📝 Request Type:\n{{ $json['Request Type'] }}\n\n💬 Specific Request:\n{{ $json['Specific Request'] }}\n\n⭐ Lead Score: {{ $json.output }}\n\nTime to follow up! 🚀",
        "chatId": "YOUR_TELEGRAM_CHAT_ID",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "credentials": {
        "telegramApi": {
          "id": "peQScPfzU5H3cxVu",
          "name": "Veille IA"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ae0e6a69-4c61-466c-b9af-9fc01b8ac7a7",
      "name": "准备邮件数据",
      "type": "n8n-nodes-base.set",
      "position": [
        1664,
        -64
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "33f69835-f48f-4d12-b067-0d8ed68354e6",
              "name": "First Name",
              "type": "string",
              "value": "={{ $json['First Name'] }}"
            },
            {
              "id": "8b882f2e-7279-422c-aa27-86eae8bd71ac",
              "name": "Email",
              "type": "string",
              "value": "={{ $json['Email'] }}"
            },
            {
              "id": "bb5fdfcb-471c-4533-a873-ddfb1edc75fb",
              "name": "Request Type",
              "type": "string",
              "value": "={{ $json['Request Type'] }}"
            },
            {
              "id": "7bf4579c-1ecc-4eec-9df5-15b4646a4a18",
              "name": "Company Name",
              "type": "string",
              "value": "={{ $json['Company Name'] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "c0e0759a-6cec-4e03-9f27-2ce15b6eeb8a",
      "name": "发送自动回复邮件",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1872,
        -64
      ],
      "webhookId": "b889c80e-57c1-4c87-bf6b-e8a3c6ab1d97",
      "parameters": {
        "sendTo": "={{ $json['Email'] }}",
        "message": "=Hello {{ $json['First Name'] }},\n\nThank you for reaching out to us!\n\nWe've received your inquiry regarding:\n\"{{ $json['Request Type'] }}\"\n\nOur team is already reviewing your request and one of our experts will contact you within 24 hours.\n\nWe appreciate {{ $json['Company Name'] }}'s interest in our AI automation services.\n\nBest regards,\nThe Team",
        "options": {
          "appendAttribution": false
        },
        "subject": "Thank you for your inquiry!",
        "emailType": "text"
      },
      "typeVersion": 2.1
    },
    {
      "id": "1b6b2327-b833-4680-91ce-48b1cf5e61dc",
      "name": "提取表单字段",
      "type": "n8n-nodes-base.set",
      "position": [
        -592,
        160
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "ea8e29d9-abfc-4ecb-b06c-6f7e78df872c",
              "name": "First Name",
              "type": "string",
              "value": "={{ $json.body.data.fields[0].value }}"
            },
            {
              "id": "cb46e5b8-6f6a-48e9-bdf9-ee89e19cf4ea",
              "name": "Last Name",
              "type": "string",
              "value": "={{ $json.body.data.fields[1].value }}"
            },
            {
              "id": "8b7a40f7-c0ef-4b0c-9f7c-e80f3e6ee89f",
              "name": "Company Name",
              "type": "string",
              "value": "={{ $json.body.data.fields[2].value }}"
            },
            {
              "id": "a6a8354e-6da0-47f7-bdd9-5eec62c8fbaf",
              "name": "Industry",
              "type": "string",
              "value": "={{ $json.body.data.fields[3].value }}"
            },
            {
              "id": "5cf8e9e9-863e-4f97-bcba-a8a11883dc65",
              "name": "Phone",
              "type": "string",
              "value": "={{ $json.body.data.fields[4].value }}"
            },
            {
              "id": "f4131f26-175a-47fe-8831-67ce37dc948b",
              "name": "Email",
              "type": "string",
              "value": "={{ $json.body.data.fields[5].value }}"
            },
            {
              "id": "87c23b03-3924-4343-893b-d30fad3a9eb9",
              "name": "Request Type",
              "type": "string",
              "value": "={{ $json.body.data.fields[6].value }}"
            },
            {
              "id": "ca62ccaf-4eb4-43fe-9689-ab2a99a6e508",
              "name": "Specific Request",
              "type": "string",
              "value": "={{ $json.body.data.fields[7].value }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "e0bd5ebe-6fac-4d3d-923a-aa1cab25ae89",
      "name": "AI 潜在客户评分代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -144,
        832
      ],
      "parameters": {
        "text": "=# TASK\nAnalyze the lead priority level based on the provided scoring value and return ONLY the corresponding emoji indicator.\n\n# INPUT DATA\nScoring Value: {{ $json.Scoring }}\n\n# SCORING SYSTEM\nYou must match the scoring value to one of these priority levels:\n\n**Priority Level 1 - Cold Lead** ⚪️\n- Criteria: {{ $('Website Form Submission').item.json.body.data.fields[8].options[0].text }}\n- ID Match: {{ $('Website Form Submission').item.json.body.data.fields[8].options[0].id }}\n- Output: ⚪️\n\n**Priority Level 2 - Warm Lead** 🟢\n- Criteria: {{ $('Website Form Submission').item.json.body.data.fields[8].options[1].text }}\n- ID Match: {{ $('Website Form Submission').item.json.body.data.fields[8].options[1].id }}\n- Output: 🟢\n\n**Priority Level 3 - Hot Lead** 🔵\n- Criteria: {{ $('Website Form Submission').item.json.body.data.fields[8].options[2].text }}\n- ID Match: {{ $('Website Form Submission').item.json.body.data.fields[8].options[2].id }}\n- Output: 🔵\n\n**Priority Level 4 - Qualified Lead** 🟣\n- Criteria: {{ $('Website Form Submission').item.json.body.data.fields[8].options[3].text }}\n- ID Match: {{ $('Website Form Submission').item.json.body.data.fields[8].options[3].id }}\n- Output: 🟣\n\n**Priority Level 5 - VIP Lead** 🔴\n- Criteria: {{ $('Website Form Submission').item.json.body.data.fields[8].options[4].text }}\n- ID Match: {{ $('Website Form Submission').item.json.body.data.fields[8].options[4].id }}\n- Output: 🔴\n\n# OUTPUT REQUIREMENTS\n- Return ONLY the emoji (⚪️, 🟢, 🔵, 🟣, or 🔴)\n- NO explanatory text\n- NO additional characters\n- NO markdown formatting\n- Just the single emoji that matches the scoring value",
        "options": {},
        "promptType": "define"
      },
      "typeVersion": 1.7
    },
    {
      "id": "c874bf9b-0c3e-4a5b-815a-14566bd3bfcc",
      "name": "OpenAI 聊天模型",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -224,
        992
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini",
          "cachedResultName": "gpt-4o-mini"
        },
        "options": {}
      },
      "typeVersion": 1.2
    },
    {
      "id": "0a2c019e-cf55-497e-afee-06a0f1380eac",
      "name": "窗口缓冲内存",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -96,
        992
      ],
      "parameters": {
        "sessionKey": "={{ $('Website Form Submission').item.json.body.eventId}}",
        "sessionIdType": "customKey"
      },
      "typeVersion": 1.3
    },
    {
      "id": "6a01094a-80b6-4138-8908-a8c05c7af91f",
      "name": "提取优先级分数",
      "type": "n8n-nodes-base.set",
      "position": [
        -592,
        688
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "cca4b69d-60cb-44a1-9a56-5295022c5834",
              "name": "Scoring",
              "type": "string",
              "value": "={{ $json.body.data.fields[8].value[0] }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "3108b428-bc29-4f1d-b06d-c0b23eef2342",
      "name": "合并表单数据与分数",
      "type": "n8n-nodes-base.merge",
      "position": [
        528,
        176
      ],
      "parameters": {
        "mode": "combine",
        "options": {},
        "combineBy": "combineAll"
      },
      "typeVersion": 3
    },
    {
      "id": "b9b44eaa-9cb9-4818-ae0e-9cce56c9df6f",
      "name": "工作流概览",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2960,
        -368
      ],
      "parameters": {
        "color": 4,
        "width": 640,
        "height": 1220,
        "content": "## AI 驱动的网站表单潜在客户评分与自动回复"
      },
      "typeVersion": 1
    },
    {
      "id": "0f6e6ee9-f5f0-4414-ad05-de3405fb6b13",
      "name": "步骤 1 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1312,
        -80
      ],
      "parameters": {
        "color": 7,
        "width": 360,
        "height": 616,
        "content": "## 步骤 1:接收表单提交"
      },
      "typeVersion": 1
    },
    {
      "id": "5c4cee3e-a02c-4ed4-a064-bfdaf124610c",
      "name": "步骤 2 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        -256
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 592,
        "content": "## 步骤 2:提取表单字段"
      },
      "typeVersion": 1
    },
    {
      "id": "2a38aaaa-ee1e-42fc-9e67-c63029baec97",
      "name": "步骤 3 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        416
      ],
      "parameters": {
        "color": 7,
        "width": 396,
        "height": 468,
        "content": "## 步骤 3:提取优先级分数"
      },
      "typeVersion": 1
    },
    {
      "id": "56b7a24c-52f1-40a8-9ab3-c3497cd39584",
      "name": "步骤 4 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -272,
        272
      ],
      "parameters": {
        "color": 7,
        "width": 480,
        "height": 900,
        "content": "## 步骤 4:AI 潜在客户评分代理"
      },
      "typeVersion": 1
    },
    {
      "id": "35f82e40-ba1e-4f94-b57d-8b1c46e6fb71",
      "name": "步骤 5 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        384,
        -176
      ],
      "parameters": {
        "color": 7,
        "width": 380,
        "height": 536,
        "content": "## 步骤 5:合并数据"
      },
      "typeVersion": 1
    },
    {
      "id": "26f75499-a2ac-48f3-b75e-03919171a786",
      "name": "步骤 6 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1024,
        -480
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 640,
        "content": "## 步骤 6:保存到潜在客户数据库"
      },
      "typeVersion": 1
    },
    {
      "id": "84c10145-177e-4181-b113-471266d1e4e7",
      "name": "步骤 7 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        384
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 628,
        "content": "## 步骤 7:通知销售团队"
      },
      "typeVersion": 1
    },
    {
      "id": "f095569e-d9e0-4448-8afe-118b833474a2",
      "name": "步骤 8 详情",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        -624
      ],
      "parameters": {
        "color": 7,
        "width": 488,
        "height": 776,
        "content": "## 步骤 8:发送自动回复邮件"
      },
      "typeVersion": 1
    },
    {
      "id": "a5d3aa8e-bce8-4e37-bb02-87b9d7ecfae6",
      "name": "配置清单",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2080,
        112
      ],
      "parameters": {
        "color": 5,
        "width": 500,
        "height": 344,
        "content": "## 🔧 配置清单"
      },
      "typeVersion": 1
    },
    {
      "id": "59a16dbb-6529-44ef-ba29-1259d040a193",
      "name": "自定义想法",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1904,
        656
      ],
      "parameters": {
        "color": 6,
        "width": 500,
        "height": 468,
        "content": "## 💡 高级自定义想法"
      },
      "typeVersion": 1
    },
    {
      "id": "440eefa2-41cb-4e9f-8018-1480fb2e22ed",
      "name": "工作流优势",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1904,
        320
      ],
      "parameters": {
        "color": 3,
        "width": 500,
        "height": 260,
        "content": "## 🎯 此工作流为何强大"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e0124722-bba0-42db-8d91-7e04fcb6f870",
  "connections": {
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Lead Scoring Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Email Data": {
      "main": [
        [
          {
            "node": "Send Auto-Reply Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Form Fields": {
      "main": [
        [
          {
            "node": "Combine Form Data with Score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Window Buffer Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Lead Scoring Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "AI Lead Scoring Agent": {
      "main": [
        [
          {
            "node": "Combine Form Data with Score",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Save to Lead Database": {
      "main": [
        [
          {
            "node": "Prepare Email Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Priority Score": {
      "main": [
        [
          {
            "node": "AI Lead Scoring Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Website Form Submission": {
      "main": [
        [
          {
            "node": "Extract Form Fields",
            "type": "main",
            "index": 0
          },
          {
            "node": "Extract Priority Score",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Form Data with Score": {
      "main": [
        [
          {
            "node": "Notify Sales Team",
            "type": "main",
            "index": 0
          },
          {
            "node": "Save to Lead Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

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

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

高级 - 潜在客户开发, AI 摘要总结

需要付费吗?

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

工作流信息
难度等级
高级
节点数量23
分类2
节点类型10
难度说明

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

作者
Mattis

Mattis

@iiiii

Consultant et expert en automatisation. Co-fondateur de l'agence PerformAi. Pas qu'un simple créateur, j'écoute et comprends l'importance pour simplifier votre activité au quotidien. On en discute ?

外部链接
在 n8n.io 查看

分享此工作流