{
  "name": "Validate leads email addresses with Hunter.io and Google Sheets",
  "nodes": [
    {
      "id": "5722ab46-2a4a-4f51-97ca-e5dc97a58fa1",
      "name": "📥 Fetch Emails from Source Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -40,
        -20
      ]
    },
    {
      "id": "84ba1906-ec77-4890-8499-81521c215ddf",
      "name": "🧹 Clean & Prepare Email Data",
      "type": "n8n-nodes-base.code",
      "position": [
        180,
        -20
      ]
    },
    {
      "id": "330e8cf0-dfc3-49d7-bcad-8343fa329740",
      "name": "🕵️‍♂️ Hunter.io Email Verifier",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        400,
        -20
      ]
    },
    {
      "id": "0b103e51-5df5-4825-8e4d-28498fa127b2",
      "name": "🧠 Format Hunter Response",
      "type": "n8n-nodes-base.code",
      "position": [
        620,
        -20
      ]
    },
    {
      "id": "b999f5c9-9001-435d-bf33-05861d891b54",
      "name": "📤 Write Results to Output Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        840,
        -20
      ]
    },
    {
      "id": "d6d80276-4911-455a-b0c5-4196aec824e5",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -300,
        -320
      ],
      "parameters": {
        "width": 420,
        "height": 560,
        "content": "## Start & Input Source\n\n**Workflow begins manually using the trigger.\n\nEmails are read from the source Google Sheet (Sheet1).\n\nInput data is expected to include columns like Email, FirstName, LastNam"
      }
    },
    {
      "id": "3472c014-1657-4f35-92fd-b6b6775cbb6b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -320
      ],
      "parameters": {
        "width": 420,
        "height": 560,
        "content": "## Clean & Verify Emails\n\n**Filters out invalid or malformed emails.\n\nExtracts fields for each contact.\n\nSends each email to Hunter.io for verification using /v2/email-verifier.\n\nReturns rich metadata"
      }
    },
    {
      "id": "51f38886-34e7-418e-b655-4a2b0a3b8eb7",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        580,
        -320
      ],
      "parameters": {
        "width": 400,
        "height": 560,
        "content": "## Post-Processing & Output\n\n**Parses Hunter.io API results and maps them to a clean format.\n\nAdds a readable statusSummary (like: valid (96% confidence)).\n\nAppends or updates the output Google Sheet "
      }
    },
    {
      "id": "9ce17c7f-221c-4268-8438-f95c99c39e09",
      "name": "⏯️ Triggers Everyday",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -260,
        -20
      ]
    }
  ],
  "connections": {
    "⏯️ Triggers Everyday": {
      "main": [
        [
          {
            "node": "📥 Fetch Emails from Source Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧠 Format Hunter Response": {
      "main": [
        [
          {
            "node": "📤 Write Results to Output Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🧹 Clean & Prepare Email Data": {
      "main": [
        [
          {
            "node": "🕵️‍♂️ Hunter.io Email Verifier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📥 Fetch Emails from Source Sheet": {
      "main": [
        [
          {
            "node": "🧹 Clean & Prepare Email Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🕵️‍♂️ Hunter.io Email Verifier": {
      "main": [
        [
          {
            "node": "🧠 Format Hunter Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}