{
  "name": "Sync lead replies from Google Sheets to GHL CRM & create ClickUp follow-up tasks",
  "nodes": [
    {
      "id": "e78a2e67-01a7-4ac5-a8db-0816762c323e",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        1248
      ],
      "parameters": {
        "width": 400,
        "height": 300,
        "content": "## 🔄 Auto-Sync Workflow\n\n**Purpose:** Automatically syncs lead reply status from Google Sheets to GoHighLevel (GHL) and creates follow-up tasks.\n\n**Runs:** Every minute\n\n**What happens:**\n1. Monitors "
      }
    },
    {
      "id": "ee10373f-7df7-4acc-ab0f-96d95659b06b",
      "name": "Monitor Reply Status Changes",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -384,
        880
      ]
    },
    {
      "id": "ce448037-48d8-4cf6-8a6e-03a4776873dd",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        752
      ],
      "parameters": {
        "width": 320,
        "height": 424,
        "content": "## 👀 Step 1: Watch for Changes\n\nMonitors Google Sheet every minute for new/updated rows.\n\n**Triggers when:**\n- New row added\n- Existing row updated\n- 'Replied' column changes\n\n**Expected columns:**\n- "
      }
    },
    {
      "id": "6ca6963e-c9bf-44bd-8fa2-97fbab1373d7",
      "name": "Filter: Only Process Replies",
      "type": "n8n-nodes-base.if",
      "position": [
        -160,
        880
      ]
    },
    {
      "id": "25f544db-9ee8-45a9-bd3d-c1666479fded",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        576
      ],
      "parameters": {
        "width": 300,
        "height": 272,
        "content": "## 🔍 Step 2: Filter Leads\n\nChecks if 'Replied' column = 'Yes'\n\n**TRUE path:** Lead replied → Continue processing\n\n**FALSE path:** No reply → Stop (do nothing)\n\n*Only processes leads who have responded"
      }
    },
    {
      "id": "d86b26b1-bfef-4909-9098-33643249f7a7",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -848,
        416
      ],
      "parameters": {
        "width": 300,
        "height": 284,
        "content": "## 🔀 Split Processing\n\nWorkflow branches into TWO parallel paths:\n\n**Path A (TRUE - Top):**\nUpdates GoHighLevel contact\n\n**Path B (FALSE - Bottom):**\nCreates ClickUp follow-up task\n\n*Both paths run si"
      }
    },
    {
      "id": "e24a9517-64bf-4316-82f6-0c6f99129806",
      "name": "Update GHL Contact Status",
      "type": "n8n-nodes-base.highLevel",
      "position": [
        64,
        784
      ]
    },
    {
      "id": "3c403ef6-8691-4b24-ac72-66455e83d5ee",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -32,
        432
      ],
      "parameters": {
        "width": 280,
        "height": 336,
        "content": "## 📊 Path A: Update GHL\n\nUpdates contact in GoHighLevel CRM.\n\n**Uses:** GHL_ID from sheet\n\n**Updates:**\n- Contact status\n- Custom fields\n- Last activity timestamp\n\n*Keeps GHL database in sync*"
      }
    },
    {
      "id": "d3164500-55a1-43d5-94a7-3874e58fa26e",
      "name": "Set GHL Success Status",
      "type": "n8n-nodes-base.set",
      "position": [
        336,
        784
      ]
    },
    {
      "id": "6b812adc-1c9c-4383-a3de-85ed07978236",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        320,
        480
      ],
      "parameters": {
        "width": 260,
        "height": 248,
        "content": "## ✏️ Mark GHL Complete\n\nAdds tracking fields:\n\n**Next_Step:** \"GHL Updated ✓\"\n**Sync_Timestamp:** Current date/time\n\n*Prepares data for sheet update*"
      }
    },
    {
      "id": "f477df98-457c-4d24-9527-853d4f656362",
      "name": "Create Follow-Up Task",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        64,
        976
      ]
    },
    {
      "id": "bbc67101-4351-48ba-a2dd-398e7d6f1152",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -96,
        1152
      ],
      "parameters": {
        "width": 280,
        "height": 336,
        "content": "## ✅ Path B: Create Task\n\nCreates ClickUp task for follow-up.\n\n**Task includes:**\n- Lead name\n- Reply notification\n- Contact details\n- GHL ID reference\n- Priority: High\n\n*Ensures timely follow-up*"
      }
    },
    {
      "id": "cc263cbd-5074-45b2-842c-b823418684b3",
      "name": "Set ClickUp Success Status",
      "type": "n8n-nodes-base.set",
      "position": [
        336,
        976
      ]
    },
    {
      "id": "4d5fcaef-197c-43b9-973e-d7c22a77dd01",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        352,
        1152
      ],
      "parameters": {
        "width": 260,
        "height": 280,
        "content": "## ✏️ Mark Task Complete\n\nAdds tracking fields:\n\n**Next_Step:** \"ClickUp Task Created ✓\"\n**Sync_Timestamp:** Current date/time\n\n*Prepares data for sheet update*"
      }
    },
    {
      "id": "78d9431a-a0f0-471c-8faf-553cbb027f78",
      "name": "Merge Both Paths",
      "type": "n8n-nodes-base.merge",
      "position": [
        656,
        880
      ]
    },
    {
      "id": "5278ddb8-86be-448c-a457-4f299247dbb7",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        688,
        528
      ],
      "parameters": {
        "width": 280,
        "height": 288,
        "content": "## 🔗 Step 3: Merge Results\n\nCombines data from both paths:\n- GHL update status\n- ClickUp task status\n- Timestamps\n\n**Result:** Single data stream with all updates\n\n*Ready for final sheet update*"
      }
    },
    {
      "id": "b7d68642-c6c0-4d52-8ced-6132efa52aab",
      "name": "Update Sheet - Log Sync Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        944,
        880
      ]
    },
    {
      "id": "9cb0b3aa-8478-472b-b399-e20eafc3411e",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        784,
        1088
      ],
      "parameters": {
        "width": 300,
        "height": 376,
        "content": "## 📝 Step 4: Update Sheet\n\nWrites sync results to Sheet2.\n\n**Matches by:** GHL_ID\n\n**Updates columns:**\n- Next_Step (action taken)\n- Sync_Timestamp (when)\n- Sync_Status (\"Completed\")\n\n**Purpose:** Aud"
      }
    }
  ],
  "connections": {
    "Merge Both Paths": {
      "main": [
        [
          {
            "node": "Update Sheet - Log Sync Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Follow-Up Task": {
      "main": [
        [
          {
            "node": "Set ClickUp Success Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set GHL Success Status": {
      "main": [
        [
          {
            "node": "Merge Both Paths",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update GHL Contact Status": {
      "main": [
        [
          {
            "node": "Set GHL Success Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set ClickUp Success Status": {
      "main": [
        [
          {
            "node": "Merge Both Paths",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Filter: Only Process Replies": {
      "main": [
        [
          {
            "node": "Update GHL Contact Status",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Create Follow-Up Task",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monitor Reply Status Changes": {
      "main": [
        [
          {
            "node": "Filter: Only Process Replies",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}