{
  "name": "Analyze pipeline velocity & alert stuck deals with GoHighLevel, Gmail & Slack",
  "nodes": [
    {
      "id": "54615dae-9ea1-4c79-89b8-6227dcf34136",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1472,
        -352
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "3c3938c2-468a-48a6-acd8-94ac8c623989",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -944,
        -176
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "097bbb09-68d7-42e9-90ee-8b57eb897045",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -640,
        464
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "d73469cc-02d5-489d-bece-4a2c4e8fcbb5",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -528,
        -352
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "9ef8cc7d-fb3f-44a2-ab7d-60b6093d009d",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        -448
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "02f7278f-9470-48a5-9371-9f798efd333a",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        64,
        448
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "04beef66-2aa6-4ff1-91e9-f373bb602d82",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        160,
        -560
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "c9acedd9-4ff3-4275-a3a4-b3bf328fb565",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        544,
        -688
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "97b966ff-1f98-4eb6-922f-244112797c93",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -496
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "c1ff95cb-b8fa-4c4b-a3d5-5a5fa22dd748",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        432,
        544
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "5fb06d0a-3f10-46c6-a330-3b5a4c54a513",
      "name": "Weekly Trigger - Monday 8AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -768,
        288
      ]
    },
    {
      "id": "f028f20a-6217-4022-ad94-d70e68803ef0",
      "name": "Fetch GHL Pipeline Data",
      "type": "n8n-nodes-base.highLevel",
      "position": [
        -544,
        288
      ]
    },
    {
      "id": "34e81ae7-95eb-40cf-be7a-2dd8f34672ff",
      "name": "Transform Stage Data",
      "type": "n8n-nodes-base.code",
      "position": [
        -96,
        192
      ]
    },
    {
      "id": "857a5082-7bd8-4dbc-804a-ef4d6b15a9f4",
      "name": "Log to Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        128,
        0
      ]
    },
    {
      "id": "72dbf078-bdee-4aec-af05-6962ba3641e3",
      "name": "Filter Stuck Deals (7+ Days)",
      "type": "n8n-nodes-base.if",
      "position": [
        128,
        288
      ]
    },
    {
      "id": "ca9bc77b-7eec-4708-ab61-d30bc04f0a32",
      "name": "Calculate Stage Metrics",
      "type": "n8n-nodes-base.code",
      "position": [
        352,
        0
      ]
    },
    {
      "id": "c9804b69-68de-482e-917d-e56772ed4583",
      "name": "Generate Weekly Report",
      "type": "n8n-nodes-base.code",
      "position": [
        576,
        0
      ]
    },
    {
      "id": "cd9073d7-7fdc-4d72-b03c-384437f03b87",
      "name": "Generate Stuck Deal Alert",
      "type": "n8n-nodes-base.code",
      "position": [
        352,
        288
      ]
    },
    {
      "id": "5f6d6e29-edbb-4fa8-bf9d-32c3ba9a5b14",
      "name": "Send Stuck Deal Alert",
      "type": "n8n-nodes-base.gmail",
      "position": [
        576,
        192
      ]
    },
    {
      "id": "31cb8a69-1047-49aa-af74-96710388b11c",
      "name": "Send Weekly Report Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        800,
        0
      ]
    },
    {
      "id": "e31fdf64-5a5c-45d9-b6d2-5a1b53f73dd8",
      "name": "Send a message",
      "type": "n8n-nodes-base.slack",
      "position": [
        576,
        384
      ]
    },
    {
      "id": "c6121da5-c974-45da-88dd-761b0ed02941",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        400
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    },
    {
      "id": "6987988d-84b5-4099-9847-7e3cbd4b5fb9",
      "name": "Send Error Alert",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -96,
        384
      ]
    },
    {
      "id": "dca4366e-332a-4b7e-bf27-36eb61ea490f",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -320,
        288
      ]
    },
    {
      "id": "613b3be0-cb7e-4a44-a64e-c8f0587cfb2f",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        576
      ],
      "parameters": {
        "width": null,
        "height": null,
        "content": ""
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Transform Stage Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Error Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheets": {
      "main": [
        [
          {
            "node": "Calculate Stage Metrics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transform Stage Data": {
      "main": [
        [
          {
            "node": "Log to Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter Stuck Deals (7+ Days)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Weekly Report": {
      "main": [
        [
          {
            "node": "Send Weekly Report Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Stage Metrics": {
      "main": [
        [
          {
            "node": "Generate Weekly Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch GHL Pipeline Data": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Stuck Deal Alert": {
      "main": [
        [
          {
            "node": "Send Stuck Deal Alert",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Weekly Trigger - Monday 8AM": {
      "main": [
        [
          {
            "node": "Fetch GHL Pipeline Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Stuck Deals (7+ Days)": {
      "main": [
        [
          {
            "node": "Generate Stuck Deal Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}