{
  "name": "Zip code-based business lead generation with Google Maps and Sheets",
  "nodes": [
    {
      "id": "507dc85c-b723-4b05-be87-5f7e20a4266c",
      "name": "Update Status to Success",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3728,
        -80
      ]
    },
    {
      "id": "b5e6bc2d-a50a-4b85-999e-9bc90b49501b",
      "name": "Add rows in Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3312,
        240
      ]
    },
    {
      "id": "97e06f42-050d-4898-bc42-140033b1f06f",
      "name": "Exponential Backoff",
      "type": "n8n-nodes-base.code",
      "position": [
        3520,
        384
      ]
    },
    {
      "id": "5d8705b6-f1ac-48bd-be5f-f7a919798b1e",
      "name": "Remove Duplicates",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        3104,
        240
      ]
    },
    {
      "id": "4bb95a05-6557-4abb-8da2-64b77b6beed0",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        3728,
        384
      ]
    },
    {
      "id": "67e90cf7-a87f-4eed-a37b-a7a49bd30460",
      "name": "Exponential Backoff1",
      "type": "n8n-nodes-base.code",
      "position": [
        3936,
        -64
      ]
    },
    {
      "id": "c25ff94f-011e-4246-88bb-d969c99eec94",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "position": [
        4128,
        -64
      ]
    },
    {
      "id": "1a3a55d3-6e22-453d-b88d-4c5b994a431e",
      "name": "Loop Subcats",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1968,
        208
      ]
    },
    {
      "id": "35b2779d-5745-4515-9842-058934ce0e30",
      "name": "Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        512,
        192
      ]
    },
    {
      "id": "c2884cbb-2b87-43d6-a7fd-afe4abc689ed",
      "name": "Check maximum retries.",
      "type": "n8n-nodes-base.if",
      "position": [
        4336,
        -64
      ]
    },
    {
      "id": "09eb6137-4c14-4935-a580-df4b03efd68e",
      "name": "get subcategory",
      "type": "n8n-nodes-base.set",
      "position": [
        1760,
        208
      ]
    },
    {
      "id": "50710916-319a-409e-93e3-4c0b25441c71",
      "name": "Filter subcategori",
      "type": "n8n-nodes-base.filter",
      "position": [
        1568,
        208
      ]
    },
    {
      "id": "b888bd3f-1166-4da4-a413-d59eeede1cec",
      "name": "Get Subcategory form sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        208
      ]
    },
    {
      "id": "c5ca9c40-3537-4693-9002-c296b68b2400",
      "name": "Loop",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1136,
        192
      ]
    },
    {
      "id": "890b873f-6fd8-4431-ab3d-465b66d95321",
      "name": "Get All Zip Code",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        720,
        192
      ]
    },
    {
      "id": "35a75787-2383-4b4d-b4d9-048885f5cc6e",
      "name": "Limit",
      "type": "n8n-nodes-base.limit",
      "position": [
        912,
        192
      ]
    },
    {
      "id": "ddeefc20-17d9-423e-8da3-44933a0fc492",
      "name": "Send a text message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        4720,
        224
      ]
    },
    {
      "id": "6f71af28-d998-4a20-aa89-85ed93da6634",
      "name": "Do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        3728,
        208
      ]
    },
    {
      "id": "e7882f43-9b0a-431c-8c73-75f8a104a7d0",
      "name": "Rapiwa",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        4720,
        64
      ]
    },
    {
      "id": "db6087d7-7272-47d2-a24e-bbc23824bbf1",
      "name": "Send a message",
      "type": "n8n-nodes-base.discord",
      "position": [
        4720,
        384
      ]
    },
    {
      "id": "a51b12b1-25d6-4cd9-912a-5b8cd66cba43",
      "name": "Set Place",
      "type": "n8n-nodes-base.set",
      "position": [
        2912,
        240
      ]
    },
    {
      "id": "7ccc0596-37d3-44d5-b89e-3fc232800e11",
      "name": "Place",
      "type": "n8n-nodes-base.code",
      "position": [
        2704,
        240
      ]
    },
    {
      "id": "18664203-7d59-4f75-b8f0-f7236e52ee28",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        2512,
        224
      ]
    },
    {
      "id": "4cd68340-ce43-4c06-bc96-9954933bec0f",
      "name": "Google Map API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2336,
        224
      ]
    },
    {
      "id": "bb80ca1e-c624-47b8-866a-6accfe2d1189",
      "name": "Set zip",
      "type": "n8n-nodes-base.set",
      "position": [
        2176,
        224
      ]
    },
    {
      "id": "dfda9422-e3b0-43bf-801c-15cf7c697d27",
      "name": "Get Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3520,
        64
      ]
    },
    {
      "id": "14e185cd-a84c-4fa5-bf18-7feb1be939e9",
      "name": "Check Max Retries",
      "type": "n8n-nodes-base.if",
      "position": [
        3920,
        384
      ]
    },
    {
      "id": "456f4737-6192-40ff-860f-d307478b0024",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -48
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "26e57562-9e64-4e30-ac7e-fa3c9169ded8",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2144,
        -112
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "eabc445a-4437-4772-987c-a7aba14f90f6",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3296,
        -272
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "d4a7fced-aa50-44b9-bc9f-0380bfe8a3b0",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2256,
        48
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "384ae244-fbe4-43bd-82e5-89e4f2a71c26",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4688,
        -112
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "a5156836-8469-4fb6-8226-a6622eab10f5",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        -128
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Loop Subcats",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Place",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop": {
      "main": [
        [],
        [
          {
            "node": "Get Subcategory form sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait": {
      "main": [
        [
          {
            "node": "Check Max Retries",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Limit": {
      "main": [
        [
          {
            "node": "Loop",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Place": {
      "main": [
        [
          {
            "node": "Set Place",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "Check maximum retries.",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set zip": {
      "main": [
        [
          {
            "node": "Google Map API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule": {
      "main": [
        [
          {
            "node": "Get All Zip Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Place": {
      "main": [
        [
          {
            "node": "Remove Duplicates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Do nothing": {
      "main": [
        [
          {
            "node": "Rapiwa",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Status": {
      "main": [
        [
          {
            "node": "Update Status to Success",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Do nothing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Subcats": {
      "main": [
        [
          {
            "node": "Loop",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Set zip",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Map API": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get subcategory": {
      "main": [
        [
          {
            "node": "Loop Subcats",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Zip Code": {
      "main": [
        [
          {
            "node": "Limit",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Max Retries": {
      "main": [
        [
          {
            "node": "Do nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Add rows in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Remove Duplicates": {
      "main": [
        [
          {
            "node": "Add rows in Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter subcategori": {
      "main": [
        [
          {
            "node": "get subcategory",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Exponential Backoff": {
      "main": [
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Exponential Backoff1": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check maximum retries.": {
      "main": [
        [
          {
            "node": "Do nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Update Status to Success",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Status to Success": {
      "main": [
        [
          {
            "node": "Loop Subcats",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Exponential Backoff1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add rows in Google Sheets": {
      "main": [
        [
          {
            "node": "Get Status",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Exponential Backoff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Subcategory form sheet": {
      "main": [
        [
          {
            "node": "Filter subcategori",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}