{
  "name": "Capture leads from forms to Google Sheets and send Gmail reminders",
  "nodes": [
    {
      "id": "98950cec-38f2-4bb6-87f2-225ae7251c4c",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -960,
        112
      ]
    },
    {
      "id": "71a3c48f-48ba-4532-82b9-77c95c85e2d9",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -960,
        368
      ]
    },
    {
      "id": "062f9ffa-97d8-441f-9639-4cb7911ab593",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        -960,
        240
      ]
    },
    {
      "id": "1e3d36e9-3950-4092-aa90-26a284781f20",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        -960,
        496
      ]
    },
    {
      "id": "f6203441-3b59-4f16-ac67-a0c6282a683a",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -720,
        352
      ]
    },
    {
      "id": "254cff56-6317-4784-b647-6ebb2b8e2723",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -544,
        112
      ]
    },
    {
      "id": "a4f72e8e-8964-4875-8384-75e4f8f7f39a",
      "name": "Gmail3",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -544,
        352
      ]
    },
    {
      "id": "fc586f80-00ae-4f07-a5df-d5b10e245698",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -720,
        112
      ]
    },
    {
      "id": "53d096e4-d78a-4e77-87a5-430b2d7457ce",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        128,
        192
      ]
    },
    {
      "id": "c0c978d9-4b17-4b79-9360-9ef7028c8d73",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        256,
        192
      ]
    },
    {
      "id": "e208a08b-59dd-4d0a-bb8c-c0460da3f5de",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -224,
        176
      ]
    },
    {
      "id": "0b391289-7746-46a7-96f4-636a87109308",
      "name": "Filter1",
      "type": "n8n-nodes-base.filter",
      "position": [
        -16,
        400
      ]
    },
    {
      "id": "31e6ac29-d8a2-4c3d-a3fc-ed63b6ea4bd9",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        160,
        400
      ]
    },
    {
      "id": "e83383e1-452d-475e-b9f2-dd828543df86",
      "name": "Filter2",
      "type": "n8n-nodes-base.filter",
      "position": [
        -16,
        192
      ]
    },
    {
      "id": "7e67b596-f9aa-49e4-ae07-d5602466bba9",
      "name": "Google Sheets1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -224,
        304
      ]
    },
    {
      "id": "2427ad1f-250b-4695-97c5-677ee4ee8551",
      "name": "Gmail4",
      "type": "n8n-nodes-base.gmail",
      "position": [
        384,
        192
      ]
    },
    {
      "id": "f5d7ec0d-b155-4414-99a4-be63d6e75762",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        48
      ],
      "parameters": {
        "width": 672,
        "height": 624,
        "content": "# New lead "
      }
    },
    {
      "id": "ef290c2a-8967-4ec6-92bb-8b3abf2ceb11",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -272,
        48
      ],
      "parameters": {
        "width": 848,
        "height": 624,
        "content": "# Lead Reminder"
      }
    },
    {
      "id": "c09a5808-2187-4cce-945c-b63d86f9abc1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1792,
        -272
      ],
      "parameters": {
        "width": 736,
        "height": 1600,
        "content": "# System Overview\n# Workflow Name: New Lead and Reminder System\n\n# What This System Does:\n\nThis n8n automation captures new leads from a form submission and automatically:\n\nSaves them to a Google Shee"
      }
    },
    {
      "id": "021deec3-3ba3-49f4-a1c1-070c46bdc80d",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -880,
        -240
      ],
      "parameters": {
        "width": 384,
        "height": 240,
        "content": "# New Lead Capture\n\n1️⃣ Form submitted by prospect\n2️⃣ Budget filtered (rejects 0-100)\n3️⃣ Lead stored in Google Sheet\n4️⃣ Routed by budget amount\n5️⃣ Personalized email sent\n6️⃣ Admin notified\n"
      }
    },
    {
      "id": "e6b75189-ae45-4329-90e4-f685ffd09d40",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        -240
      ],
      "parameters": {
        "width": 384,
        "height": 240,
        "content": "# Daily Lead Reminder\n\n⏰ Runs at 8 PM every day\n📊 Pulls uncalled leads\n📧 Sends reminder email\n✅ Update \"Called\" when done\n🔄 Auto-removes from next reminder\n"
      }
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Gmail4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail": {
      "main": [
        [
          {
            "node": "Gmail2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail1": {
      "main": [
        [
          {
            "node": "Gmail3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Gmail",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Gmail1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter1": {
      "main": [
        [
          {
            "node": "Google Sheets2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter2": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets1": {
      "main": [
        [
          {
            "node": "Filter1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Google Sheets1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}