Validation automatisée des e-mails avec Google Sheets, Hunter.io et EmailValidation.io
Intermédiaire
Ceci est unLead Generation, Miscellaneous, Multimodal AIworkflow d'automatisation du domainecontenant 8 nœuds.Utilise principalement des nœuds comme Set, Filter, Hunter, HttpRequest, GoogleSheets. Vérification automatisée des e-mails avec Google Sheets, Hunter.io et EmailValidation.io
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
Nœuds utilisés (8)
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"meta": {
"instanceId": "3dd7d3035157a6c8c0bc0904aa8991f90872849a76d57fd6b5eedb4e09f76c2f"
},
"nodes": [
{
"id": "6a06b03c-27d8-4256-8f54-ac614fec00b2",
"name": "Google Sheets Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-544,
96
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit?usp=drivesdk",
"cachedResultName": "Email Validation"
}
},
"typeVersion": 1
},
{
"id": "bd24d486-ff8a-483f-9123-8158e47f2c36",
"name": "Email Validation API",
"type": "n8n-nodes-base.httpRequest",
"position": [
96,
96
],
"parameters": {
"url": "=https://api.emailvalidation.io/v1/info?apikey={{api_key}}&email={{ $json.Email }}",
"options": {},
"sendBody": true,
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{}
]
},
"headerParameters": {
"parameters": [
{}
]
}
},
"typeVersion": 4.2
},
{
"id": "1296f145-1589-4df5-a648-8d24266adb9a",
"name": "Filtrer les cellules vides",
"type": "n8n-nodes-base.filter",
"position": [
-320,
96
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "55afbbbe-0c07-412d-aae3-eceb061d1b92",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d8cb2bf4-babb-4a80-a051-35cc37ac7479",
"name": "Extraire uniquement l'email",
"type": "n8n-nodes-base.set",
"position": [
-112,
96
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "26020ce1-c307-4c9d-9c47-f66efda1b57e",
"name": "Email",
"type": "string",
"value": "={{ $json.Email }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "95f7fc3a-32c1-4dff-85f7-e9d36a2808fe",
"name": "Extraire l'email et le statut de validation",
"type": "n8n-nodes-base.set",
"position": [
272,
96
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ba35033d-05fc-4b05-9a08-c55662f956c3",
"name": "status",
"type": "string",
"value": "={{ $json.state }}"
},
{
"id": "abab1589-c81b-4d1f-80c5-83dc156a45e0",
"name": "email",
"type": "string",
"value": "={{ $json.email }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "6feaf204-bdc8-48f8-a427-8a16afd63688",
"name": "Mettre à jour la feuille avec le statut de validation",
"type": "n8n-nodes-base.googleSheets",
"position": [
464,
96
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.email }}",
"Deliverability ": "={{ $json.status }}"
},
"schema": [
{
"id": "Name ",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Deliverability ",
"type": "string",
"display": true,
"required": false,
"displayName": "Deliverability ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Linkedin URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company ",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company ",
"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": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14tsPplI_HG0K1IuRjFNsAIxqewmFrxfb10JRy15Urg4/edit?usp=drivesdk",
"cachedResultName": "Email Validation"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "buZ3kxvSme2Z38GJ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "40b08848-691d-4082-ad80-cf2d2d45c39e",
"name": "Alternative - Hunter pour la validation d'email",
"type": "n8n-nodes-base.hunter",
"position": [
96,
-80
],
"parameters": {
"email": "={{ $json.Email }}",
"operation": "emailVerifier"
},
"typeVersion": 1
},
{
"id": "43b4b741-3db0-48c6-b99b-8f1bf6b5d76b",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-672,
-176
],
"parameters": {
"width": 1456,
"height": 464,
"content": "## Instructions\n1. Take email and other data from the google sheets. \n2. If new row added the trigger will trigger the workflow automatically\n3. Setup Sheets credentails \n4. Setup Email Validation or Hunter Credentials \n5. Tadah! You are all good."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"d8cb2bf4-babb-4a80-a051-35cc37ac7479": {
"main": [
[
{
"node": "bd24d486-ff8a-483f-9123-8158e47f2c36",
"type": "main",
"index": 0
}
]
]
},
"1296f145-1589-4df5-a648-8d24266adb9a": {
"main": [
[
{
"node": "d8cb2bf4-babb-4a80-a051-35cc37ac7479",
"type": "main",
"index": 0
}
]
]
},
"bd24d486-ff8a-483f-9123-8158e47f2c36": {
"main": [
[
{
"node": "95f7fc3a-32c1-4dff-85f7-e9d36a2808fe",
"type": "main",
"index": 0
}
]
]
},
"6a06b03c-27d8-4256-8f54-ac614fec00b2": {
"main": [
[
{
"node": "1296f145-1589-4df5-a648-8d24266adb9a",
"type": "main",
"index": 0
}
]
]
},
"95f7fc3a-32c1-4dff-85f7-e9d36a2808fe": {
"main": [
[
{
"node": "6feaf204-bdc8-48f8-a427-8a16afd63688",
"type": "main",
"index": 0
}
]
]
}
}
}Foire aux questions
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 - Génération de leads, Divers, IA Multimodale
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
Scraping de prospects Google Maps et enrichissement de contact personnalisé par IA
Capture de leads Google Maps et enrichissement avec une approche personnalisée pilotée par l'IA
Set
Code
Filter
+
Set
Code
Filter
24 NœudsA Z
Génération de leads
Génération de prospects basée sur l'IA (Apollo, recherche LinkedIn et email de personnalisation en 4 étapes)
Génération de prospects basée sur l'IA : Utilisation d'Apollo, de la recherche LinkedIn et d'un email de personnalisation en 4 étapes
If
Set
Code
+
If
Set
Code
30 NœudsGain FLow AI
Génération de leads
Générateur de contenu d'accroche personnalisé pour les e-mails froids
Automatiser le froid personnalisé via l'extraction de prospects Apollo et GPT-4.1
Set
Code
Slack
+
Set
Code
Slack
24 NœudsRichard Besier
Génération de leads
Système automatisé de support client avec Gmail, GPT-4 et une base de connaissances vectorielle
Système automatisé de support client avec Gmail, GPT-4 et une base de connaissances vectorielle
If
Set
Code
+
If
Set
Code
32 NœudsKhair Ahammed
RAG IA
Agent intelligent de prospection IA
Génération automatisée de prospects et envoi de froid e-mails avec Apify, l'IA et Gmail
If
Set
Wait
+
If
Set
Wait
20 NœudsRakin Jakaria
Génération de leads
Utiliser GPT-4 Mini, Apify et LinkedIn pour générer des personnalisations d'ouverture pour des e-mails froids
Générer des phrases d'ouverture pour e-mails froids personnalisés à partir de LinkedIn avec GPT-4 Mini, Apify
Set
Filter
Aggregate
+
Set
Filter
Aggregate
16 NœudsErfan Mostafiz
Génération de leads
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds8
Catégorie3
Types de nœuds7
Description de la difficulté
Auteur
Khair Ahammed
@khair1212Automation engineer with over 2 years of experience specializing in building scalable and reliable automation solutions using n8n and other cutting-edge tools. With expertise in workflow optimization, API integrations, and process automation, I help businesses streamline their operations and eliminate repetitive tasks.
Liens externes
Voir sur n8n.io →
Partager ce workflow