🔐 Système de validation par double confirmation pour l'envoi de courriels (utilise Google Sheets)
Avancé
Ceci est unMarketing, IT Opsworkflow d'automatisation du domainecontenant 24 nœuds.Utilise principalement des nœuds comme If, Code, Form, EmailSend, FormTrigger. 🔐 Système de double validation par e-mail pour Google Sheets
Prérequis
- •Informations d'identification Google Sheets API
Nœuds utilisés (24)
Catégorie
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
{
"id": "bWbwE1qVduRTdWmc",
"meta": {
"instanceId": "a98b2884375a41e5c54ee9fdf1ece06db7f5771d5abd20450875f3922d7c41f8"
},
"name": "🔐 Double Opt-In Email Verification System with Google Sheets",
"tags": [
{
"id": "2E1hRaAa0axOUCXV",
"name": "UTCM",
"createdAt": "2025-05-08T22:11:01.814Z",
"updatedAt": "2025-05-08T22:11:01.814Z"
},
{
"id": "GZT3Cgu3i4As1Giz",
"name": "Doble-OptIn",
"createdAt": "2025-05-08T22:10:58.928Z",
"updatedAt": "2025-05-08T22:10:58.928Z"
},
{
"id": "UZnyfKrtC83mHOyK",
"name": "Forms",
"createdAt": "2025-05-08T22:10:50.602Z",
"updatedAt": "2025-05-08T22:10:50.602Z"
}
],
"nodes": [
{
"id": "93c4049b-138e-4cb1-906a-8aada9485ffd",
"name": "À la soumission du formulaire",
"type": "n8n-nodes-base.formTrigger",
"position": [
-4460,
-160
],
"webhookId": "13e025ae-a071-4659-ad64-6aab4fdf26c8",
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
"name": "Formulaire Email",
"type": "n8n-nodes-base.form",
"position": [
-4140,
-160
],
"webhookId": "65c69d26-adef-48d9-8bff-2f152fc5ce94",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "d0106dca-e3d1-45bc-b0e4-a0ac7a82a903",
"name": "Générer un code",
"type": "n8n-nodes-base.code",
"position": [
-3800,
-160
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "659f0327-c4ee-45f8-a38d-80e9aada20db",
"name": "Envoyer l'email",
"type": "n8n-nodes-base.emailSend",
"position": [
-3020,
-160
],
"webhookId": "7a787e42-b725-454a-99e6-71f95863d37f",
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.1
},
{
"id": "ac5dfb19-9254-45fd-92bb-2d78a3062f51",
"name": "Stocker les données",
"type": "n8n-nodes-base.googleSheets",
"position": [
-3440,
-120
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 4.5
},
{
"id": "f9586647-ea00-4b21-bd54-76f4314f926d",
"name": "Formulaire de vérification",
"type": "n8n-nodes-base.form",
"position": [
-2700,
-160
],
"webhookId": "d21ac010-2872-4320-af3b-6f5e398dc8e5",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1",
"name": "Vérifier le code",
"type": "n8n-nodes-base.if",
"position": [
-2380,
-160
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
"name": "Formulaire principal",
"type": "n8n-nodes-base.form",
"position": [
-1840,
-440
],
"webhookId": "5c229f26-1625-4367-a3f9-ebd2cc3e8241",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "016ff76e-12f6-42ed-ad3c-234c585d6126",
"name": "Formulaire de code incorrect",
"type": "n8n-nodes-base.form",
"position": [
-1920,
600
],
"webhookId": "c69a7027-4453-43ba-a5ae-5601d912978e",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "b1692894-3759-4f56-bd98-1c57a91dbb3c",
"name": "Deuxième vérification",
"type": "n8n-nodes-base.if",
"position": [
-1200,
60
],
"parameters": {},
"notesInFlow": false,
"typeVersion": 2.2
},
{
"id": "f883c1c1-4529-41a8-9ec4-4f2396fcc972",
"name": "Formulaire de réinitialisation",
"type": "n8n-nodes-base.form",
"position": [
-640,
760
],
"webhookId": "16d0402a-20a1-4a6c-9ab8-13c353a1efe7",
"parameters": {},
"notesInFlow": false,
"typeVersion": 1
},
{
"id": "dc335784-6532-4e63-b4a1-5b9cf77b5de6",
"name": "Note adhésive 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4540,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2160baa2-a011-4bd8-b4bb-a11845e0323c",
"name": "Note adhésive 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4240,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6fed7946-cac4-48c0-836d-863f87ac1da0",
"name": "Note adhésive 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3920,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4d8dbcce-1dc3-48fa-a2f9-1561e6399462",
"name": "Note adhésive 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3600,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3b1cdbbd-28f3-420a-b507-0a707e857845",
"name": "Note adhésive 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3120,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "59276d85-d217-4883-86ac-427eb70083df",
"name": "Note adhésive 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2800,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6c0df430-39c0-4dc9-b0a4-6b9a2aeabc12",
"name": "Note adhésive 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2480,
-600
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "05973b8b-b873-44c6-8274-1bae17118cb8",
"name": "Note adhésive 8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2120,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1479b495-1d18-4a03-8fdb-d276b33e70ac",
"name": "Note adhésive 9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1480,
-220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9936331c-2fb5-4d4f-ab8d-b586310a75ca",
"name": "Note adhésive 10",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ae131e8-69a1-4212-81d6-95aabaf5cd3e",
"name": "Note adhésive 11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2120,
-740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2a429ebd-460c-4a33-bc57-7576e31e1fea",
"name": "Continuer avec votre flux",
"type": "n8n-nodes-base.noOp",
"position": [
-1200,
-440
],
"parameters": {},
"typeVersion": 1
},
{
"id": "0935942e-3a27-4f5c-ac0f-9a0ddc68ac8a",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1420,
-1000
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "5ace2a5e-1f6c-4c13-a069-d71dcb22ee1d",
"connections": {
"47dd37e4-409c-42dd-9554-b14c18b65cb0": {
"main": [
[
{
"node": "2a429ebd-460c-4a33-bc57-7576e31e1fea",
"type": "main",
"index": 0
}
]
]
},
"e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1": {
"main": [
[
{
"node": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
"type": "main",
"index": 0
}
],
[
{
"node": "016ff76e-12f6-42ed-ad3c-234c585d6126",
"type": "main",
"index": 0
}
]
]
},
"358d84d7-381b-4de9-8c5e-d1d988c0b4a7": {
"main": [
[
{
"node": "d0106dca-e3d1-45bc-b0e4-a0ac7a82a903",
"type": "main",
"index": 0
}
]
]
},
"f883c1c1-4529-41a8-9ec4-4f2396fcc972": {
"main": [
[
{
"node": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
"type": "main",
"index": 0
}
]
]
},
"659f0327-c4ee-45f8-a38d-80e9aada20db": {
"main": [
[
{
"node": "f9586647-ea00-4b21-bd54-76f4314f926d",
"type": "main",
"index": 0
}
]
]
},
"ac5dfb19-9254-45fd-92bb-2d78a3062f51": {
"main": [
[
{
"node": "659f0327-c4ee-45f8-a38d-80e9aada20db",
"type": "main",
"index": 0
}
]
]
},
"b1692894-3759-4f56-bd98-1c57a91dbb3c": {
"main": [
[
{
"node": "47dd37e4-409c-42dd-9554-b14c18b65cb0",
"type": "main",
"index": 0
}
],
[
{
"node": "f883c1c1-4529-41a8-9ec4-4f2396fcc972",
"type": "main",
"index": 0
}
]
]
},
"d0106dca-e3d1-45bc-b0e4-a0ac7a82a903": {
"main": [
[
{
"node": "ac5dfb19-9254-45fd-92bb-2d78a3062f51",
"type": "main",
"index": 0
}
]
]
},
"f9586647-ea00-4b21-bd54-76f4314f926d": {
"main": [
[
{
"node": "e33fb6cd-59c2-4c84-9d51-5c8f7af1e2a1",
"type": "main",
"index": 0
}
]
]
},
"93c4049b-138e-4cb1-906a-8aada9485ffd": {
"main": [
[
{
"node": "358d84d7-381b-4de9-8c5e-d1d988c0b4a7",
"type": "main",
"index": 0
}
]
]
},
"016ff76e-12f6-42ed-ad3c-234c585d6126": {
"main": [
[
{
"node": "b1692894-3759-4f56-bd98-1c57a91dbb3c",
"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é ?
Avancé - Marketing, Opérations IT
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
Téléverseur CSV vers HubSpot (cartographie dynamique de champs et intégration Google Sheets)
Chargeur de fichiers CSV vers HubSpot avec mappage de champs dynamique et intégration Google Sheets
If
Set
Code
+
If
Set
Code
36 NœudsPollupAI
Intelligence Artificielle
Automatisation du processus d'intégration en plusieurs étapes avec Google Sheets, Forms et notifications Gmail
Utiliser Google Sheets, Forms et les notifications Gmail pour automatiser un processus d'intégration multi-étapes
If
Set
Code
+
If
Set
Code
31 NœudsPollupAI
Ressources Humaines
Vidéo de produit 3D
为电商店铺de2D图像génération3Dproduit视频
If
Code
Wait
+
If
Code
Wait
21 NœudsInfyOm Technologies
Design
AImarketingagent：Reddit + OpenRouter + Gmail 潜在clientgénération
AImarketingagent：viaReddit、OpenRouteretGmail进行潜在clientgénération
If
Set
Code
+
If
Set
Code
23 NœudsAri Nakos
Ventes
Surveillance d'informations pilotée par l'IA avec OpenAI, Google Sheets, Jina AI et Slack
Une surveillance d'informations basée sur l'IA, intégrant OpenAI, Google Sheets, Jina AI et Slack
If
Set
Code
+
If
Set
Code
31 NœudsDataki
Ventes
Optimisation avancée du référencement YouTube et mise à jour automatisée par l'AI
Optimisation avancée du référencement YouTube et mise à jour automatique par IA
If
Code
Form
+
If
Code
Form
12 NœudsLucas Correia
Intelligence Artificielle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds24
Catégorie2
Types de nœuds8
Description de la difficulté
Auteur
Un tal Camilo Medina
@untalcamilomedinaLiens externes
Voir sur n8n.io →
Partager ce workflow