{
  "name": "Automated email validation for Google Sheets using Rapid Email Verifier",
  "nodes": [
    {
      "id": "13f98fdb-07fc-49a9-9362-1eb1bab2e1ee",
      "name": "Monitor New Email Entries",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        112,
        544
      ]
    },
    {
      "id": "28e1409f-e4ef-46aa-b035-a8227d5d6646",
      "name": "Update Verification Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1584,
        544
      ]
    },
    {
      "id": "2ee35cec-c0a0-476e-b91e-ee18e586f989",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 416,
        "height": 192,
        "content": "📧 AUTOMATED EMAIL VERIFICATION SYSTEM\n════════════════════════════════════════════════════════════\n✨ Automatically validates email addresses from Google Sheets\n⚡ Real-time verification using rapid-ema"
      }
    },
    {
      "id": "601194a5-7ddf-48e4-814d-7f8be5a4cb99",
      "name": "Setup Instructions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        0
      ],
      "parameters": {
        "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 Shee"
      }
    },
    {
      "id": "99d920b4-a489-4215-8757-0f123f6351e8",
      "name": "Trigger Explanation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        272
      ],
      "parameters": {
        "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 limit"
      }
    },
    {
      "id": "0f7b061a-3410-48a6-bc71-39d93595ff6d",
      "name": "Filter Unverified Emails",
      "type": "n8n-nodes-base.filter",
      "position": [
        528,
        544
      ]
    },
    {
      "id": "0af226e1-ded6-4fb4-b5af-296b02be9c63",
      "name": "Process Emails in Batches",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        832,
        544
      ]
    },
    {
      "id": "92f176f5-6cef-4b7f-abd7-0a8bd6b9eda2",
      "name": "Verify Email Address",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1216,
        544
      ]
    },
    {
      "id": "7513234f-b1a3-4fe8-b167-410bb8a6921e",
      "name": "Filter Logic",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        256
      ],
      "parameters": {
        "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"
      }
    },
    {
      "id": "d45072c3-7be3-423a-8afc-f787fc484772",
      "name": "Batch Processing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        752,
        256
      ],
      "parameters": {
        "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 dat"
      }
    },
    {
      "id": "e8d919ee-92d1-41b8-8862-6c12e8bff6d5",
      "name": "API Details",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        256
      ],
      "parameters": {
        "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"
      }
    },
    {
      "id": "dc571bb2-e2f0-4a5d-870b-62f388c7609f",
      "name": "Results Update",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1472,
        256
      ],
      "parameters": {
        "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 fil"
      }
    },
    {
      "id": "8e1eeaaf-823b-468b-90c4-6bd03c068a34",
      "name": "Performance Metrics",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        0
      ],
      "parameters": {
        "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 effi"
      }
    }
  ],
  "connections": {
    "Verify Email Address": {
      "main": [
        [
          {
            "node": "Update Verification Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Unverified Emails": {
      "main": [
        [
          {
            "node": "Process Emails in Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monitor New Email Entries": {
      "main": [
        [
          {
            "node": "Filter Unverified Emails",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Emails in Batches": {
      "main": [
        [],
        [
          {
            "node": "Verify Email Address",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Verification Results": {
      "main": [
        [
          {
            "node": "Process Emails in Batches",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}