Qualification des pistes de formulaires de site Hostinger
Ceci est unSales, AIworkflow d'automatisation du domainecontenant 8 nœuds.Utilise principalement des nœuds comme HttpRequest, GmailTrigger, GoogleSheets, OpenAi, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Capture et qualification des prospects de formulaires Hostinger avec OpenAI, Beehiiv et Google Sheets
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (8)
Catégorie
{
"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": "Lister les publications 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": "Ajouter un abonné 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": "Extraire et qualifier",
"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": "Déclencheur nouveau formulaire",
"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": "Insérer dans 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": "Note adhésive",
"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": "Note adhésive 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": "Note adhésive 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
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Ventes, Intelligence Artificielle
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
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?
Partager ce workflow