8
n8n 中文网amn8n.com

Hostinger 网站表单线索资质判定

中级

这是一个Sales, AI领域的自动化工作流，包含 8 个节点。主要使用 HttpRequest, GmailTrigger, GoogleSheets, OpenAi 等节点，结合人工智能技术实现智能自动化。 使用 OpenAI、Beehiiv 和 Google Sheets 进行 Hostinger 表单线索捕获与资质判定

前置要求
  • •可能需要目标 API 的认证凭证
  • •Google 账号和 Gmail API 凭证
  • •Google Sheets API 凭证
  • •OpenAI API Key

使用的节点 (8)

StickyNote
HttpRequest
GmailTrigger
GoogleSheets
OpenAi

分类

销售
人工智能
工作流预览
可视化展示节点连接关系，支持缩放和平移
React Flow
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
  "id": "NYq3UCwuVeSy4t2X",
  "meta": {
    "instanceId": "9219ebc7795bea866f70aa3d977d54417fdf06c41944be95e20cfb60f992db19",
    "templateCredsSetupCompleted": true
  },
  "name": "Hostinger 网站表单线索资质判定",
  "tags": [
    {
      "id": "55FGhjeaCcjBUam6",
      "name": "1node",
      "createdAt": "2025-04-30T08:13:16.484Z",
      "updatedAt": "2025-04-30T08:13:16.484Z"
    },
    {
      "id": "33yuvdx4oQ05TZoD",
      "name": "newsletter",
      "createdAt": "2025-05-02T08:18:43.148Z",
      "updatedAt": "2025-05-02T08:18:43.148Z"
    }
  ],
  "nodes": [
    {
      "id": "79eb3b2e-7039-4462-b63a-941a8b7ed5c5",
      "name": "列出 Beehiiv 出版物",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -684,
        -40
      ],
      "parameters": {
        "url": "https://api.beehiiv.com/v2/publications",
        "options": {},
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "JttI5PDV6bISzI9c",
          "name": "Beehiiv newsletter"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "495b8118-f0dc-442e-8b52-48cd3b698753",
      "name": "添加 Beehiiv 订阅者",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -464,
        -40
      ],
      "parameters": {
        "url": "=https://api.beehiiv.com/v2/publications/{{ $json.data[0].id }}/subscriptions",
        "method": "POST",
        "options": {},
        "sendBody": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $('Extract & Qualify').item.json.message.content.email }}"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "JttI5PDV6bISzI9c",
          "name": "Beehiiv newsletter"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "3ae5298e-c0bf-44ef-9f1b-d6f1b8964c73",
      "name": "提取与资质判定",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -1060,
        -40
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini",
          "cachedResultName": "GPT-4.1-MINI"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "=You are a lead qualification engine. You will receive the text of an email containing a form response.\n\nHere is the form response: \n{{ $json.text }} \n\nYour task is to evaluate the fields: \"email\", \"company name\", and \"website\" to determine if a lead is qualified, as well as extracting the rest of the variables in the form response to output a JSON with all the fields.\n\n\"isQualified\" → true or false\n\"reason\" → short explanation if unqualified, empty string if qualified\n\nRules:\n\nIf the email domain is from a free provider (e.g., gmail.com, yahoo.com, hotmail.com, outlook.com), set isQualified = false and set reason = \"Personal email used\".\n\nIf the website field is missing, invalid, or not a proper URL, set isQualified = false and set reason = \"Invalid or missing website\".\n\nIf both email and website are acceptable, set isQualified = true and set reason = \"\".\n\nResponse format: Only return JSON with all the variables. No explanations, no additional text."
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "vupAk5StuhOafQcb",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "e35a283f-7ddd-4d20-b3cb-2a2d57cb1a36",
      "name": "新表单触发器",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -1280,
        -40
      ],
      "parameters": {
        "simple": false,
        "filters": {
          "sender": "enterHostingerSender@notifications.hostinger.com"
        },
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "q3P6IybvNdDiPZ52",
          "name": "Gmail account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "172514fb-f8b5-4bf9-940c-edf115f6448d",
      "name": "插入到表格中",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -244,
        -40
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $('Extract & Qualify').item.json.message.content.name }}",
            "Role": "={{ $('Extract & Qualify').item.json.message.content.role }}",
            "Size": "={{ $('Extract & Qualify').item.json.message.content.companySize }}",
            "Email": "={{ $('Extract & Qualify').item.json.message.content.email }}",
            "Budget": "={{ $('Extract & Qualify').item.json.message.content.projectBudget }}",
            "Reason": "={{ $('Extract & Qualify').item.json.message.content.reason }}",
            "Company": "={{ $('Extract & Qualify').item.json.message.content.companyName }}",
            "Message": "={{ $('Extract & Qualify').item.json.message.content.howCanWeHelp }}",
            "Website": "={{ $('Extract & Qualify').item.json.message.content.companyWebsite }}",
            "Services": "={{ $('Extract & Qualify').item.json.message.content.servicesInterested }}",
            "Is Qualified": "={{ $('Extract & Qualify').item.json.message.content.isQualified }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Role",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Role",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Website",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Size",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Size",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Budget",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Budget",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Services",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Services",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Message",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Is Qualified",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Is Qualified",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Reason",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Reason",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {
          "useAppend": true
        },
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XpNF2nQfYkSCOYQbG-KR0PT3iisVyjO50p-GwhO_IMo/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1XpNF2nQfYkSCOYQbG-KR0PT3iisVyjO50p-GwhO_IMo",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1XpNF2nQfYkSCOYQbG-KR0PT3iisVyjO50p-GwhO_IMo/edit?usp=drivesdk",
          "cachedResultName": "Website form responses"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "twZdLFsI3kTnqtpG",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "cbdae788-7246-4efa-adfe-1db0a395ce50",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1380,
        -260
      ],
      "parameters": {
        "width": 300,
        "height": 380,
        "content": "## 设置步骤"
      },
      "typeVersion": 1
    },
    {
      "id": "738d2276-6cc0-41c8-9eec-ca26aba6a164",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -754,
        -260
      ],
      "parameters": {
        "width": 460,
        "height": 380,
        "content": "## 新闻简报同步"
      },
      "typeVersion": 1
    },
    {
      "id": "e99246b5-38a2-4c3b-bfc1-dfacb6ad208f",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1060,
        -260
      ],
      "parameters": {
        "color": 5,
        "width": 280,
        "content": "## 提取表单响应"
      },
      "typeVersion": 1
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "timezone": "Europe/Madrid",
    "callerPolicy": "workflowsFromSameOwner",
    "errorWorkflow": "qFOYM3IA9QZ7fMym",
    "executionOrder": "v1"
  },
  "versionId": "8c6c1826-b6fd-46f7-88fd-0986d99fe7e1",
  "connections": {
    "New form trigger": {
      "main": [
        [
          {
            "node": "Extract & Qualify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "insert in Sheets": {
      "main": [
        []
      ]
    },
    "Extract & Qualify": {
      "main": [
        [
          {
            "node": "List Beehiiv publications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Beehiiv subscriber": {
      "main": [
        [
          {
            "node": "insert in Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "List Beehiiv publications": {
      "main": [
        [
          {
            "node": "Add Beehiiv subscriber",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流？

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

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

中级 - 销售, 人工智能

需要付费吗？

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

相关工作流推荐

AI房地产经纪人：端到端运营自动化（网络、数据、语音）
AI房地产经纪人：端到端运营自动化（网络、数据、语音）
If
Set
Code
+16
45 节点Sam Yassine
销售
会议已预订 - 发送至新闻简报和CRM
使用Google Sheets、Beehiiv和Telegram自动化Cal.com会议参与者管理
Set
Split Out
Telegram
+4
9 节点Aitor | 1node.ai
人工智能
使用 RetellAI 构建电话代理用于外呼潜在客户资格认证和呼入电话处理 -视频
使用 RetellAI 电话代理、OpenAI GPT-4 和 Google Sheets 自动进行潜在客户资格认定
If
Wait
Gmail
+9
18 节点Dr. Firas
销售
LinkGPT
使用OpenAI和Hunter自动化LinkedIn档案搜索与冷邮件外联
If
Code
Wait
+6
22 节点Abhijay Vuyyuru
销售
AI潜在客户机器专业版：Google地图→Slack→HubSpot→$$$
使用Google地图、GPT-4和HubSpot的自动化潜在客户生成与资格认证
If
Set
Code
+7
16 节点David Olusola
销售
我的工作流5
使用AI邮件个性化的自动化LinkedIn潜在客户生成（未完成）
If
Set
Code
+9
37 节点Matthieu
销售
工作流信息
难度等级
中级
节点数量8
分类2
节点类型5
难度说明

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

作者
Aitor | 1Node

Aitor | 1Node

@aitoralonso

Hi, I’m Aitor. At 1Node we help businesses integrate full-scale AI solutions that save time, cut costs, and increase revenue. Guaranteed. Need help implementing AI infrastructures?

外部链接
在 n8n.io 查看 →

分享此工作流