Hostinger ウェブサイトフォームリード資格判定
中級
これはSales, AI分野の自動化ワークフローで、8個のノードを含みます。主にHttpRequest, GmailTrigger, GoogleSheets, OpenAiなどのノードを使用、AI技術を活用したスマート自動化を実現。 OpenAI、Beehiiv、Googleスプレッドシートを使用したHostingerフォームリードキャプチャと資格判定
前提条件
- •ターゲットAPIの認証情報が必要な場合あり
- •Googleアカウント + Gmail API認証情報
- •Google Sheets API認証情報
- •OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "NYq3UCwuVeSy4t2X",
"meta": {
"instanceId": "9219ebc7795bea866f70aa3d977d54417fdf06c41944be95e20cfb60f992db19",
"templateCredsSetupCompleted": true
},
"name": "Hostinger website form lead qualification",
"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": "Sheets に挿入",
"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": "## Set up steps\n- Create an account on [Hostinger](https://hostinger.es?REFERRALCODE=6MKHELLOUQOS) \n- Set up a form in your website and send a test response\n- Check your email to map the hostinger sender "
},
"typeVersion": 1
},
{
"id": "738d2276-6cc0-41c8-9eec-ca26aba6a164",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-754,
-260
],
"parameters": {
"width": 460,
"height": 380,
"content": "## Newsletter sync \nEvery time a user fills your contact form, they will be added to your newsletter on [Beehiiv](https://www.beehiiv.com?via=1node-ai). Just make sure you have added this inside your terms and conditions.\n\nWe have tried other tools but this one remains the strongest, offering flexible features for free"
},
"typeVersion": 1
},
{
"id": "e99246b5-38a2-4c3b-bfc1-dfacb6ad208f",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1060,
-260
],
"parameters": {
"color": 5,
"width": 280,
"content": "## Extract form response\nOne of Hostinger's weaknesses is not being able to store form data. This is where we message an OpenAI model to extract email data as JSON"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"timezone": "Europe/Madrid",
"callerPolicy": "workflowsFromSameOwner",
"errorWorkflow": "qFOYM3IA9QZ7fMym",
"executionOrder": "v1"
},
"versionId": "8c6c1826-b6fd-46f7-88fd-0986d99fe7e1",
"connections": {
"e35a283f-7ddd-4d20-b3cb-2a2d57cb1a36": {
"main": [
[
{
"node": "3ae5298e-c0bf-44ef-9f1b-d6f1b8964c73",
"type": "main",
"index": 0
}
]
]
},
"172514fb-f8b5-4bf9-940c-edf115f6448d": {
"main": [
[]
]
},
"3ae5298e-c0bf-44ef-9f1b-d6f1b8964c73": {
"main": [
[
{
"node": "79eb3b2e-7039-4462-b63a-941a8b7ed5c5",
"type": "main",
"index": 0
}
]
]
},
"495b8118-f0dc-442e-8b52-48cd3b698753": {
"main": [
[
{
"node": "172514fb-f8b5-4bf9-940c-edf115f6448d",
"type": "main",
"index": 0
}
]
]
},
"79eb3b2e-7039-4462-b63a-941a8b7ed5c5": {
"main": [
[
{
"node": "495b8118-f0dc-442e-8b52-48cd3b698753",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - 営業, 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
AI不動産エージェント：エンドツーエンド運用自動化（Web、データ、音声）
AI不動産エージェント：エンドツーエンド運用自動化（Web、データ、音声）
If
Set
Code
+
If
Set
Code
45 ノードSam Yassine
営業
会議が予約されました - ニュースレターとCRMへの送信済み
Google Sheets、Beehiiv、Telegramを使ってCal.comのカンファレンス参加者管理を自動化
Set
Split Out
Telegram
+
Set
Split Out
Telegram
9 ノードAitor | 1node.ai
人工知能
RetellAI を使った電話アイドルを構築してリード外提起格付と内向電話処理 -動画
RetellAI 電話アジェント、OpenAI GPT-4、Google Sheets を使った potential customer 資格認定の自動化
If
Wait
Gmail
+
If
Wait
Gmail
18 ノードDr. Firas
営業
LinkGPT
OpenAI と Hunter を使って LinkedIn プロフィール検索とコールドメールアウトレッチを自動化
If
Code
Wait
+
If
Code
Wait
22 ノードAbhijay Vuyyuru
営業
AIリードマシンProfessional版：Google Maps→Slack→HubSpot→$$$
Googleマップ、GPT-4、HubSpotを使った自動リード生成とクオリファイアケーション
If
Set
Code
+
If
Set
Code
16 ノードDavid Olusola
営業
私のワークフロー5
AIメールパーソナライゼーションを使用した自動LinkedInリード生成（未完了）
If
Set
Code
+
If
Set
Code
37 ノードMatthieu
営業
ワークフロー情報
難易度
中級
ノード数8
カテゴリー2
ノードタイプ5
作成者
Aitor | 1Node
@aitoralonsoHi, 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で表示 →
このワークフローを共有