Mon workflow 2

Name: Mon workflow 2
Rating: 4.5 (10 reviews)
Author: Gaurav

Intermédiaire

Ceci est unLead Generationworkflow d'automatisation du domainecontenant 13 nœuds.Utilise principalement des nœuds comme Filter, HttpRequest, GoogleSheets, SplitInBatches, GoogleSheetsTrigger. Vérification automatisée des e-mails dans Google Sheets avec Rapid Email Verifier

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 (13)

Catégorie

Génération de leads

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Surveiller les nouvelles entrées d'e-mails

Mettre à jour les résultats de validation

Filtrer les e-mails non vérifiés

Traiter les e-mails par lots

Vérifier l'adresse e-mail

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "id": "O9e1SfXnhax8YZal",
  "meta": {
    "instanceId": "f080fafc9937b6b383f471ad8cc35ad1727032832bd16212f900e0577db46644"
  },
  "name": "My workflow 2",
  "tags": [],
  "nodes": [
    {
      "id": "13f98fdb-07fc-49a9-9362-1eb1bab2e1ee",
      "name": "Surveiller les nouvelles entrées d'e-mails",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        112,
        544
      ],
      "parameters": {
        "event": "rowAdded",
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyHour"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": "Your Email Verification Spreadsheet"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "28e1409f-e4ef-46aa-b035-a8227d5d6646",
      "name": "Mettre à jour les résultats de validation",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1584,
        544
      ],
      "parameters": {
        "columns": {
          "value": {
            "SrNo": "={{ $('Filter Unverified Emails').item.json.SrNo }}",
            "Email Verified": "={{ $json.status }}"
          },
          "schema": [
            {
              "id": "SrNo",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "SrNo",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email Verified",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email Verified",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "SrNo"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "",
          "cachedResultUrl": "",
          "cachedResultName": "Your Email Verification Spreadsheet"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "XruFPA2NpYd9OmBT",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "2ee35cec-c0a0-476e-b91e-ee18e586f989",
      "name": "Vue d'ensemble du flux",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "color": 6,
        "width": 416,
        "height": 192,
        "content": "📧 AUTOMATED EMAIL VERIFICATION SYSTEM\n════════════════════════════════════════════════════════════\n✨ Automatically validates email addresses from Google Sheets\n⚡ Real-time verification using rapid-email-verifier API\n📊 Updates spreadsheet with verification status\n🔄 Continuous monitoring with hourly checks\n\n🎯 USE CASES: Lead qualification | Contact list cleaning | Email marketing prep\n"
      },
      "typeVersion": 1
    },
    {
      "id": "601194a5-7ddf-48e4-814d-7f8be5a4cb99",
      "name": "Instructions de configuration",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        0
      ],
      "parameters": {
        "color": 5,
        "width": 416,
        "height": 208,
        "content": "⚙️ QUICK SETUP GUIDE\n═══════════════════════════════════════\n1️⃣ Create Google Sheet with columns:\n   • SrNo | Name | Email | Email Verified\n\n2️⃣ Connect your Google Sheets account\n   \n3️⃣ Update Sheet ID in trigger and update nodes\n\n4️⃣ Test with sample data\n\n💡 TIP: Test with a sample email first!\n"
      },
      "typeVersion": 1
    },
    {
      "id": "99d920b4-a489-4215-8757-0f123f6351e8",
      "name": "Explication du déclencheur",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        272
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 192,
        "content": "🚀 MONITORING TRIGGER\n───────────────────────\n• Checks every hour for new rows\n• Only processes newly added entries\n• Automatically handles multiple entries\n• Uses efficient polling to avoid rate limits\n• Connects to your Google Sheets document\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0f7b061a-3410-48a6-bc71-39d93595ff6d",
      "name": "Filtrer les e-mails non vérifiés",
      "type": "n8n-nodes-base.filter",
      "position": [
        528,
        544
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "80aa56a4-b365-448f-9214-71f0ba758947",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['Email Verified'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
      "name": "Traiter les e-mails par lots",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        832,
        544
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2",
      "name": "Vérifier l'adresse e-mail",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1216,
        544
      ],
      "parameters": {
        "url": "https://rapid-email-verifier.fly.dev/api/validate",
        "options": {},
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $json.Email }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "7513234f-b1a3-4fe8-b167-410bb8a6921e",
      "name": "Logique de filtrage",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 192,
        "content": "🔍 SMART FILTERING\n─────────────────────\nOnly processes emails that haven't been verified yet\n• Checks if \"Email Verified\" column is empty\n• Prevents duplicate API calls\n• Saves processing time and API credits\n• Ensures efficient workflow execution\n"
      },
      "typeVersion": 1
    },
    {
      "id": "d45072c3-7be3-423a-8afc-f787fc484772",
      "name": "Traitement par lots",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        752,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 256,
        "height": 224,
        "content": "⚙️ BATCH PROCESSING\n─────────────────────\nProcesses emails one by one to:\n• Respect API rate limits\n• Handle errors gracefully  \n• Ensure reliable verification\n• Track progress per item\n• Maintain data consistency\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e8d919ee-92d1-41b8-8862-6c12e8bff6d5",
      "name": "Détails de API",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 224,
        "content": "🌐 EMAIL VALIDATION API\n────────────────────────\nrapid-email-verifier.fly.dev\n• Real-time email verification\n• Returns: valid/invalid/unknown\n• Fast response times (<500ms)\n• No authentication required\n• Free tier: 1000 verifications/month\n"
      },
      "typeVersion": 1
    },
    {
      "id": "dc571bb2-e2f0-4a5d-870b-62f388c7609f",
      "name": "Mise à jour des résultats",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1472,
        256
      ],
      "parameters": {
        "color": 4,
        "width": 352,
        "height": 224,
        "content": "✅ RESULTS UPDATE\n──────────────────\nUpdates the original sheet with:\n• Verification status (valid/invalid)\n• Matches by Serial Number\n• Preserves original data\n• Creates audit trail\n• Enables easy filtering\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8e1eeaaf-823b-468b-90c4-6bd03c068a34",
      "name": "Mesures de performance",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        0
      ],
      "parameters": {
        "color": 7,
        "width": 416,
        "height": 224,
        "content": "📈 WORKFLOW PERFORMANCE  \n────────────────────────────\n• Processes: ~60 emails/hour\n• API Response: <500ms average\n• Accuracy: 95%+ verification rate\n• Cost: Free tier supports 1000/month\n• Memory efficient batch processing\n\n💡 PRO TIP: Use webhook trigger for real-time verification\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a5ff6180-438a-4e77-98ea-372bf7177dc8",
  "connections": {
    "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2": {
      "main": [
        [
          {
            "node": "28e1409f-e4ef-46aa-b035-a8227d5d6646",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0f7b061a-3410-48a6-bc71-39d93595ff6d": {
      "main": [
        [
          {
            "node": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "13f98fdb-07fc-49a9-9362-1eb1bab2e1ee": {
      "main": [
        [
          {
            "node": "0f7b061a-3410-48a6-bc71-39d93595ff6d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0af226e1-ded6-4fb4-b5af-296b02be9c63": {
      "main": [
        [],
        [
          {
            "node": "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "28e1409f-e4ef-46aa-b035-a8227d5d6646": {
      "main": [
        [
          {
            "node": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
            "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

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.