{
  "name": "Automate solar lead qualification & follow-ups with Google Sheets and Gmail",
  "nodes": [
    {
      "id": "3e998cde-b40e-488f-8fec-bd6236739a17",
      "name": "[STEP 2] Upload Utility Bill",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -900,
        200
      ]
    },
    {
      "id": "ff59804e-dffe-44f9-a508-b83c751079b4",
      "name": "[STEP 3] Make Bill Viewable",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -700,
        200
      ]
    },
    {
      "id": "68ed779d-b8ae-42c0-8c2b-5d02be52f1a2",
      "name": "[STEP 4] Create Bill Link",
      "type": "n8n-nodes-base.function",
      "position": [
        -520,
        200
      ]
    },
    {
      "id": "97436bb1-f20d-4922-9be2-297c2f569885",
      "name": "[STEP 5] Save Lead to Spreadsheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        200
      ]
    },
    {
      "id": "65100f33-5e32-4fcc-a54a-5e122f590346",
      "name": "[STEP 7] Check Qualification Criteria",
      "type": "n8n-nodes-base.code",
      "position": [
        -1000,
        680
      ]
    },
    {
      "id": "3eaba98d-43e9-4d5a-9c80-48320c8a66ff",
      "name": "Check Qualification Status",
      "type": "n8n-nodes-base.if",
      "position": [
        -600,
        680
      ]
    },
    {
      "id": "01c128a7-e67e-461f-b7ed-cc0d4275747c",
      "name": "[STEP 10A] Send Acceptance Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -380,
        500
      ]
    },
    {
      "id": "11e46266-d94f-4ec5-adaa-8b6e23cc44bc",
      "name": "[STEP 10B] Send Rejection Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -360,
        740
      ]
    },
    {
      "id": "73b04cb5-c785-49f4-bc16-4c2d84bbf3e0",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1320,
        100
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9b569a4a-f79d-4c05-a088-bd104efdf03d",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        140
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9f35a33d-c7c1-42db-aadf-91104d242ec5",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1320,
        500
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "1370e913-8431-40a3-ae45-5114e7b82511",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -420,
        440
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "0836ce79-f911-4d03-bce7-ce8554d4e580",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "ef923c7c-3583-41fe-8f16-9e08ece43e83",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1180,
        200
      ]
    },
    {
      "id": "6b69501b-83c9-43f0-a3d2-baf5da943df9",
      "name": "[STEP 8] Update Qualification Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -840,
        680
      ]
    },
    {
      "id": "777eff8b-241c-4e4d-9deb-1ee10c8a7a6d",
      "name": "Append row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -160,
        520
      ]
    },
    {
      "id": "6ebb0a11-eef1-4bc4-a88c-02de73c9b734",
      "name": "[STEP 5] Save Lead to Spreadsheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1240,
        680
      ]
    },
    {
      "id": "5831d64b-5f32-44f8-9d90-4b2a59e4af3d",
      "name": "Webhook1",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -1520,
        680
      ]
    },
    {
      "id": "537dbebc-ea70-4e8c-b680-73796cb47a08",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1720,
        560
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "Webhook": {
      "main": [
        [
          {
            "node": "[STEP 2] Upload Utility Bill",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook1": {
      "main": [
        [
          {
            "node": "[STEP 5] Save Lead to Spreadsheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 4] Create Bill Link": {
      "main": [
        [
          {
            "node": "[STEP 5] Save Lead to Spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Qualification Status": {
      "main": [
        [
          {
            "node": "[STEP 10A] Send Acceptance Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "[STEP 10B] Send Rejection Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 3] Make Bill Viewable": {
      "main": [
        [
          {
            "node": "[STEP 4] Create Bill Link",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 2] Upload Utility Bill": {
      "main": [
        [
          {
            "node": "[STEP 3] Make Bill Viewable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 10A] Send Acceptance Email": {
      "main": [
        [
          {
            "node": "Append row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 5] Save Lead to Spreadsheet": {
      "main": [
        [
          {
            "node": "[STEP 7] Check Qualification Criteria",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 5] Save Lead to Spreadsheet1": {
      "main": [
        [
          {
            "node": "[STEP 7] Check Qualification Criteria",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 8] Update Qualification Status": {
      "main": [
        [
          {
            "node": "Check Qualification Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "[STEP 7] Check Qualification Criteria": {
      "main": [
        [
          {
            "node": "[STEP 8] Update Qualification Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}