{
  "name": "Automate Apollo lead scraping & email enrichment to Airtable CRM with Apify",
  "nodes": [
    {
      "id": "04b2ce2b-b253-4b8d-a525-7db0fab14c14",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2192,
        368
      ],
      "parameters": {
        "width": 800,
        "height": 1152,
        "content": "# Apollo Lead Scraper to Airtable CRM\n\n## 📋 What This Template Does\nThis workflow scrapes leads from Apollo.io search URLs via Apify, enriches with emails and LinkedIn data, removes duplicates, and sy"
      }
    },
    {
      "id": "2c866dd8-9c17-4205-9b00-cfb2bdcc78cb",
      "name": "Remove Duplicates",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        3856,
        880
      ]
    },
    {
      "id": "9881dcf9-3eea-4cad-a028-3a5e65b79973",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        3648,
        880
      ]
    },
    {
      "id": "3d1aec0f-43b2-4a73-8b2b-81a7e7b6b434",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        4208,
        880
      ]
    },
    {
      "id": "6318a6c1-6722-43f2-9be9-e68669d46c6b",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        4032,
        880
      ]
    },
    {
      "id": "688fa91c-7dad-4e8c-b255-ba70c34bb7a4",
      "name": "Email Absent",
      "type": "n8n-nodes-base.airtable",
      "position": [
        4752,
        1056
      ]
    },
    {
      "id": "32e9cdea-1ba4-44a3-89f8-b8ac41b6084f",
      "name": "Email Present",
      "type": "n8n-nodes-base.airtable",
      "position": [
        4480,
        736
      ]
    },
    {
      "id": "3ee8c096-d969-47e1-b0aa-530cf9a14e0a",
      "name": "IF",
      "type": "n8n-nodes-base.if",
      "position": [
        4480,
        976
      ]
    },
    {
      "id": "8a4ad51c-0369-409e-b48d-5ce46fbfb26a",
      "name": "Personal email present",
      "type": "n8n-nodes-base.airtable",
      "position": [
        4752,
        864
      ]
    },
    {
      "id": "120f0da5-adff-48db-948c-92315ec724fe",
      "name": "Get URL",
      "type": "n8n-nodes-base.airtable",
      "position": [
        3280,
        880
      ]
    },
    {
      "id": "babc3cbd-6d4e-42e8-94e4-c5ada67c1983",
      "name": "Start",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        3088,
        880
      ]
    },
    {
      "id": "85227b65-b0af-4661-887e-d55cc3bc2bfc",
      "name": "Note: Get URL",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3088,
        576
      ],
      "parameters": {
        "width": 392,
        "height": 288,
        "content": "## 📥 Get URL\n\n**Purpose:** Fetches Apollo search URL from Airtable.\n\n**Key Settings:**\n- Base: Your Airtable base ID.\n- Table: \"Apollo URL\" or equivalent.\n- Operation: Search (list all records).\n\n**No"
      }
    },
    {
      "id": "933ce7fc-90d1-453a-902b-49c16ac80047",
      "name": "Note: Scrape Leads",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3344,
        1056
      ],
      "parameters": {
        "width": 376,
        "height": 288,
        "content": "## 🔍 Scrape Leads\n\n**Purpose:** Runs Apify actor to scrape leads from Apollo URL.\n\n**Key Settings:**\n- Actor: Apollo Scraper.\n- Custom Body: Enable personal/work emails, set totalRecords (e.g., 1200)."
      }
    },
    {
      "id": "3c3dfb52-0094-4701-bd73-6c3aa16a3ab0",
      "name": "Note: Edit Fields",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3760,
        576
      ],
      "parameters": {
        "width": 408,
        "height": 256,
        "content": "## ✏️ Node: Edit Fields\n\n**Purpose:** Maps and renames scraped data fields for Airtable.\n\n**Key Settings:**\n- Assignments: Map fields like name, email, company details.\n\n**Note:** Handles nested organ"
      }
    },
    {
      "id": "27e73c0b-a557-4fa7-aec8-aaeae38d369c",
      "name": "Note: Dedupe & Filter",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3904,
        1072
      ],
      "parameters": {
        "width": 376,
        "height": 280,
        "content": "## Remove Duplicates & Filter\n\n**Purpose:** Deduplicates leads and filters those with websites.\n\n**Key Settings:**\n- Remove Duplicates: Default options (compares all fields).\n- Filter: Website exists."
      }
    },
    {
      "id": "5f43c706-b189-4331-b882-076221118801",
      "name": "Note: Conditions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4432,
        1168
      ],
      "parameters": {
        "width": 376,
        "height": 280,
        "content": "## 🔀 Nodes: If & IF\n\n**Purpose:** Branches based on email presence (work/personal).\n\n**Key Settings:**\n- Conditions: Check if email or personal_email exists.\n\n**Note:** Routes to appropriate Airtable "
      }
    },
    {
      "id": "86d2131e-5cf7-4c2d-b58d-5e5367bd4d49",
      "name": "Note: Airtable Creates",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4688,
        560
      ],
      "parameters": {
        "width": 456,
        "height": 272,
        "content": "## 📤 Email Present, Personal email present, Email Absent\n\n**Purpose:** Creates records in Airtable tables based on email availability.\n\n**Key Settings:**\n- Operation: Create.\n- Columns: Mapped fields;"
      }
    },
    {
      "id": "fb8abd64-afd7-4273-a024-9ce48b60dea0",
      "name": "Apollo Scraper",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3456,
        880
      ]
    }
  ],
  "connections": {
    "IF": {
      "main": [
        [
          {
            "node": "Personal email present",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Email Absent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If": {
      "main": [
        [
          {
            "node": "Email Present",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "IF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start": {
      "main": [
        [
          {
            "node": "Get URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get URL": {
      "main": [
        [
          {
            "node": "Apollo Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apollo Scraper": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}