Reply Status Sync to GHL
描述
分类
⚙️ Automation
使用的节点
n8n-nodes-base.ifn8n-nodes-base.setn8n-nodes-base.setn8n-nodes-base.mergen8n-nodes-base.clickUpn8n-nodes-base.highLeveln8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNote
价格免费
浏览量0
最后更新11/28/2025
workflow.json
{
"id": "UG6m2I5WqfBDRROW",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "Reply Status Sync to GHL",
"tags": [],
"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 Sheet for replies\n2. Updates GHL contact records\n3. Creates ClickUp tasks\n4. Marks sync status in Sheet"
},
"typeVersion": 1
},
{
"id": "ee10373f-7df7-4acc-ab0f-96d95659b06b",
"name": "Monitor Reply Status Changes",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-384,
880
],
"parameters": {
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hoAwuZ7Dn_VL02zs-064EKK0mOzx0oUlwbkJLZZTUzs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1hoAwuZ7Dn_VL02zs-064EKK0mOzx0oUlwbkJLZZTUzs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hoAwuZ7Dn_VL02zs-064EKK0mOzx0oUlwbkJLZZTUzs/edit?usp=drivesdk",
"cachedResultName": "Reply Status Sheet"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "tjY8nawuuRO1rxAE",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"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- Name\n- GHL_ID\n- Replied (Yes/No)\n- Email\n\n*Checks: Every 60 seconds*"
},
"typeVersion": 1
},
{
"id": "6ca6963e-c9bf-44bd-8fa2-97fbab1373d7",
"name": "Filter: Only Process Replies",
"type": "n8n-nodes-base.if",
"position": [
-160,
880
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{$json[\"Replied\"]}}",
"value2": "Yes"
}
]
}
},
"typeVersion": 1
},
{
"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*"
},
"typeVersion": 1
},
{
"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 simultaneously*"
},
"typeVersion": 1
},
{
"id": "e24a9517-64bf-4316-82f6-0c6f99129806",
"name": "Update GHL Contact Status",
"type": "n8n-nodes-base.highLevel",
"position": [
64,
784
],
"parameters": {
"contactId": "={{ $json.GHL_ID }}",
"operation": "update",
"updateFields": {},
"requestOptions": {}
},
"credentials": {
"highLevelOAuth2Api": {
"id": "5QWHSi134dLIBEsC",
"name": "HighLevel account"
}
},
"typeVersion": 2
},
{
"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*"
},
"typeVersion": 1
},
{
"id": "d3164500-55a1-43d5-94a7-3874e58fa26e",
"name": "Set GHL Success Status",
"type": "n8n-nodes-base.set",
"position": [
336,
784
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3e9b0c90-494f-4c17-b7f0-878343c39e77",
"name": "Next_Step",
"type": "string",
"value": "GHL Updated ✓"
},
{
"id": "b2f8a1c3-5d6e-4f7a-8b9c-0d1e2f3a4b5c",
"name": "Sync_Timestamp",
"type": "string",
"value": "={{ $now.toISO() }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"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*"
},
"typeVersion": 1
},
{
"id": "f477df98-457c-4d24-9527-853d4f656362",
"name": "Create Follow-Up Task",
"type": "n8n-nodes-base.clickUp",
"position": [
64,
976
],
"parameters": {
"list": "901611225386",
"name": "=Follow-up: {{ $json.Name }} replied!",
"team": "90161261705",
"space": "90165174252",
"folderless": true,
"additionalFields": {
"priority": 3
}
},
"credentials": {
"clickUpApi": {
"id": "mcOAWijv7qCSnkNx",
"name": "ClickUp account-test anuj"
}
},
"typeVersion": 1
},
{
"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*"
},
"typeVersion": 1
},
{
"id": "cc263cbd-5074-45b2-842c-b823418684b3",
"name": "Set ClickUp Success Status",
"type": "n8n-nodes-base.set",
"position": [
336,
976
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "3e9b0c90-494f-4c17-b7f0-878343c39e77",
"name": "Next_Step",
"type": "string",
"value": "ClickUp Task Created ✓"
},
{
"id": "c4d5e6f7-8a9b-0c1d-2e3f-4a5b6c7d8e9f",
"name": "Sync_Timestamp",
"type": "string",
"value": "={{ $now.toISO() }}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4
},
{
"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*"
},
"typeVersion": 1
},
{
"id": "78d9431a-a0f0-471c-8faf-553cbb027f78",
"name": "Merge Both Paths",
"type": "n8n-nodes-base.merge",
"position": [
656,
880
],
"parameters": {},
"typeVersion": 3.2
},
{
"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*"
},
"typeVersion": 1
},
{
"id": "b7d68642-c6c0-4d52-8ced-6132efa52aab",
"name": "Update Sheet - Log Sync Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
944,
880
],
"parameters": {
"options": {},
"fieldsUi": {
"values": [
{
"column": "Next_Step",
"fieldValue": "={{ $json.Next_Step }}"
},
{
"column": "Sync_Timestamp",
"fieldValue": "={{ $json.Sync_Timestamp }}"
},
{
"column": "Sync_Status",
"fieldValue": "Completed"
}
]
},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 595839936,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hoAwuZ7Dn_VL02zs-064EKK0mOzx0oUlwbkJLZZTUzs/edit#gid=595839936",
"cachedResultName": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1hoAwuZ7Dn_VL02zs-064EKK0mOzx0oUlwbkJLZZTUzs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hoAwuZ7Dn_VL02zs-064EKK0mOzx0oUlwbkJLZZTUzs/edit?usp=drivesdk",
"cachedResultName": "Reply Status Sheet"
},
"valueToMatchOn": "={{ $json.GHL_ID }}",
"columnToMatchOn": "GHL_ID"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "s4dP1fNuVZ2gWvs3",
"name": "Google Sheets account"
}
},
"typeVersion": 3
},
{
"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:** Audit trail & prevents duplicate processing\n\n*Workflow complete! ✨*"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "8acccf7e-7fba-453e-a6a2-2254b4a28527",
"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
}
]
]
}
}
}