{
  "name": "Generate and enrich Google Maps leads with Apify, Hunter and Google Sheets",
  "nodes": [
    {
      "id": "55c1f689-8754-4e0e-8edd-f27d01633153",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1616,
        2112
      ]
    },
    {
      "id": "3117fc69-cee0-4162-b0fc-ec19beb02bb0",
      "name": "Check Existing Leads1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2256,
        2080
      ]
    },
    {
      "id": "cd1b6504-e882-4f6a-952a-4a32e86b5356",
      "name": "Deduplicate Leads1",
      "type": "n8n-nodes-base.code",
      "position": [
        2480,
        2080
      ]
    },
    {
      "id": "46d29568-b67e-4ec9-9659-ee2ad9358120",
      "name": "Has New Leads?1",
      "type": "n8n-nodes-base.if",
      "position": [
        2688,
        2080
      ]
    },
    {
      "id": "432aa161-a06c-4598-91af-a6856b49facd",
      "name": "Batch for AI Processing1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2928,
        2064
      ]
    },
    {
      "id": "bc54b297-24b5-420f-b85e-7d3f0ebcfeea",
      "name": "High Confidence Leads?1",
      "type": "n8n-nodes-base.if",
      "position": [
        3600,
        2192
      ]
    },
    {
      "id": "f415402a-ee16-4acb-a0e2-e679c439d6ea",
      "name": "Build Email Report1",
      "type": "n8n-nodes-base.code",
      "position": [
        3824,
        2064
      ]
    },
    {
      "id": "94ae26d3-9678-4359-9d75-b9ccbacd7152",
      "name": "Send Email Report1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        4048,
        2064
      ]
    },
    {
      "id": "ebdcc92f-3024-4552-ab49-9970d785341e",
      "name": "Prepare Sheet Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        3824,
        2304
      ]
    },
    {
      "id": "b8409e14-5207-4703-ba47-fc3f2bfa8a0b",
      "name": "Error Notification1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2480,
        2256
      ]
    },
    {
      "id": "1c52a82e-7920-4130-8e1e-02dce69b8b30",
      "name": "Format Error Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        2256,
        2256
      ]
    },
    {
      "id": "cac998e5-0833-4cde-af12-a6c11bba7c8c",
      "name": "No New Leads Notification1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2944,
        2240
      ]
    },
    {
      "id": "b8fec60e-f259-425b-89c9-0cda80f60e9a",
      "name": "Google Maps Scraper",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1824,
        2112
      ]
    },
    {
      "id": "79777419-e672-418b-b212-ab10b00054aa",
      "name": "Save to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        4048,
        2304
      ]
    },
    {
      "id": "6bd27424-c52b-404d-bc04-19cb2df24f66",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        4304,
        2272
      ]
    },
    {
      "id": "855d644f-ec7e-495d-a40c-cf8d4acbfa6b",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "position": [
        4512,
        2272
      ]
    },
    {
      "id": "868478ce-bf78-4891-8614-a79f5e938bb6",
      "name": "Merge & Validate Results",
      "type": "n8n-nodes-base.code",
      "position": [
        3392,
        2192
      ]
    },
    {
      "id": "e2198f9f-49eb-4c31-ab3a-53bc94915efa",
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3168,
        2208
      ]
    },
    {
      "id": "7ce2505d-803a-4f47-9117-fb4186520ad1",
      "name": "Format & Validate Data",
      "type": "n8n-nodes-base.code",
      "position": [
        2032,
        2096
      ]
    },
    {
      "id": "72aa0265-471d-4ef8-9c00-435a899f54dd",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1008,
        1824
      ],
      "parameters": {
        "width": 544,
        "height": 736,
        "content": "## Google Maps Lead Scraper with Enrichment & Email Reporting\nThis workflow is an automated lead generation system that scrapes businesses from Google Maps, enriches them with verified emails, and del"
      }
    },
    {
      "id": "4115017c-26d7-429f-a31d-c33a5571238e",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1584,
        1824
      ],
      "parameters": {
        "width": 1024,
        "height": 736,
        "content": "## Step 1 – Scrape & Deduplicate\nRuns on schedule, scrapes Google Maps businesses, cleans and scores data, and removes duplicates already stored in Google Sheets.\n"
      }
    },
    {
      "id": "8644ab9c-a89d-4373-aee3-11f21f9a5e26",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2656,
        1824
      ],
      "parameters": {
        "width": 880,
        "height": 736,
        "content": "## Step 2 – Enrich Emails\nNew leads are processed in batches and enriched using Hunter domain search to find and verify business emails.\n"
      }
    },
    {
      "id": "8e1a1460-42e6-47e0-b177-9a6d8e0b1a3d",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3568,
        1824
      ],
      "parameters": {
        "width": 1120,
        "height": 736,
        "content": "## Step 3 – Report & Store\nLeads are classified by confidence, emailed as a daily report, and saved to Google Sheets for long-term tracking.\n"
      }
    }
  ],
  "connections": {
    "Wait1": {
      "main": [
        [
          {
            "node": "Batch for AI Processing1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge1": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "Merge & Validate Results",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Format Error Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Has New Leads?1": {
      "main": [
        [
          {
            "node": "Batch for AI Processing1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "No New Leads Notification1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Google Maps Scraper",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Deduplicate Leads1": {
      "main": [
        [
          {
            "node": "Has New Leads?1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Error Data1": {
      "main": [
        [
          {
            "node": "Error Notification1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Report1": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Email Report1": {
      "main": [
        [
          {
            "node": "Send Email Report1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Maps Scraper": {
      "main": [
        [
          {
            "node": "Format & Validate Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Format Error Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Sheet Data1": {
      "main": [
        [
          {
            "node": "Save to Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Existing Leads1": {
      "main": [
        [
          {
            "node": "Deduplicate Leads1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save to Google Sheets": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ],
        [
          {
            "node": "Format Error Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format & Validate Data": {
      "main": [
        [
          {
            "node": "Check Existing Leads1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Format Error Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "High Confidence Leads?1": {
      "main": [
        [
          {
            "node": "Build Email Report1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Prepare Sheet Data1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Prepare Sheet Data1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Build Email Report1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Batch for AI Processing1": {
      "main": [
        [],
        [
          {
            "node": "HTTP Request1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge & Validate Results": {
      "main": [
        [
          {
            "node": "High Confidence Leads?1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}