Vérifier les adresses e-mail des prospects avec Anymail Finder

Intermédiaire

Ceci est unLead Generation, Multimodal AIworkflow d'automatisation du domainecontenant 6 nœuds.Utilise principalement des nœuds comme HttpRequest, GoogleSheets, ManualTrigger, SplitInBatches. Vérification de masse des e-mails des prospects avec Google Sheets et Anymail Finder

Prérequis
  • Peut nécessiter les informations d'identification d'authentification de l'API cible
  • Informations d'identification Google Sheets API
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": "bvYcq5zrLPePpJPm",
  "meta": {
    "instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
    "templateCredsSetupCompleted": true
  },
  "name": "Verify leads email address with Anymail Finder",
  "tags": [],
  "nodes": [
    {
      "id": "b440f1f9-ec22-4958-bf05-e1d65f277951",
      "name": "Déclencheur Manuel",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -704,
        -448
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5094115d-4649-4d28-847d-541e3b4b1494",
      "name": "Obtenir les Prospects",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -496,
        -448
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupColumn": "VERIFY"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit?usp=drivesdk",
          "cachedResultName": "Verify leads email"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "3cde3dfb-91dc-4863-ad0f-aedd7078cd18",
      "name": "Boucle sur les Éléments",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -288,
        -448
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "311399e5-d190-4e72-9968-c9c2ec88fbe1",
      "name": "Mettre à jour le statut de l'e-mail",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        -448
      ],
      "parameters": {
        "columns": {
          "value": {
            "VERIFY": "={{ $json.email_status }}",
            "row_number": "={{ $('Loop Over Items').item.json.row_number }}"
          },
          "schema": [
            {
              "id": "COMPANY NAME",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "COMPANY NAME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMAIL ",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "EMAIL ",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "VERIFY",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "VERIFY",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "number",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit?usp=drivesdk",
          "cachedResultName": "Verify leads email"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "6c24bae6-fb01-4071-ba23-b5613a9a6c7b",
      "name": "Vérifier le statut de l'e-mail",
      "type": "n8n-nodes-base.httpRequest",
      "notes": "This node sends the request to Anymailfinder.\nMake sure you've connected your API key in the credentials (HTTP Header Auth).",
      "onError": "continueErrorOutput",
      "position": [
        -16,
        -432
      ],
      "parameters": {
        "url": "https://api.anymailfinder.com/v5.1/verify-email",
        "method": "POST",
        "options": {
          "timeout": 180000
        },
        "sendBody": true,
        "authentication": "genericCredentialType",
        "bodyParameters": {
          "parameters": [
            {
              "name": "email",
              "value": "={{ $json[\"EMAIL \"] }}"
            }
          ]
        },
        "genericAuthType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "h3AkgiVUAlGDw3Ec",
          "name": "Anymail Finder"
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "7d2a131c-527e-44ac-b4b9-089dcc3245b0",
      "name": "Note Adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -768
      ],
      "parameters": {
        "width": 608,
        "height": 256,
        "content": "## Verify leads email address with Anymail Finder\nThis workflow automates the **process of validating email addresses** stored in a **Google Sheets file** by using the Anymail Finder API.\n\n- Clone this [sheet](https://docs.google.com/spreadsheets/d/108sjf89zpKRyZbGq9MjcNFQOezP4hi97SJ_uAkXc8WI/edit?usp=sharing)\n- Get your (Anymail Finder)[https://anymailfinder.com] API Key (FREE Trial)\n- In \"Check email status\" node Create a credential named “Anymail Finder” of type HTTP Header Auth. In the “Name” field, enter \"Authorization\" and in the “Value” field, enter your Anymail Finder API key (in the format YOUR_API_KEY)"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "b53ba6c5-ac90-42d7-90a9-13b405c13206",
  "connections": {
    "5094115d-4649-4d28-847d-541e3b4b1494": {
      "main": [
        [
          {
            "node": "3cde3dfb-91dc-4863-ad0f-aedd7078cd18",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b440f1f9-ec22-4958-bf05-e1d65f277951": {
      "main": [
        [
          {
            "node": "5094115d-4649-4d28-847d-541e3b4b1494",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3cde3dfb-91dc-4863-ad0f-aedd7078cd18": {
      "main": [
        [],
        [
          {
            "node": "6c24bae6-fb01-4071-ba23-b5613a9a6c7b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6c24bae6-fb01-4071-ba23-b5613a9a6c7b": {
      "main": [
        [
          {
            "node": "311399e5-d190-4e72-9968-c9c2ec88fbe1",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "311399e5-d190-4e72-9968-c9c2ec88fbe1": {
      "main": [
        [
          {
            "node": "3cde3dfb-91dc-4863-ad0f-aedd7078cd18",
            "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, 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.

Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds6
Catégorie2
Types de nœuds5
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Auteur

Full-stack Web Developer based in Italy specialising in Marketing & AI-powered automations. For business enquiries, send me an email at info@n3w.it or add me on Linkedin.com/in/davideboizza

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34