自动化从GoHighLevel到Slack、Sheets和Calendar的高价值潜在客户提醒
高级
这是一个Lead Generation领域的自动化工作流，包含 17 个节点。主要使用 If, Code, Slack, HighLevel, GoogleSheets 等节点。 将GoHighLevel的高价值潜在客户提醒自动发送至Slack、Sheets和Calendar
前置要求
- •Slack Bot Token 或 Webhook URL
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "S65jfvMZZfPk7EKf",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "自动化从 GoHighLevel 到 Slack、Sheets 和 Calendar 的高价值潜在客户提醒",
"tags": [],
"nodes": [
{
"id": "6539d6c2-4beb-42db-af71-48fa1853d0aa",
"name": "工作流概览",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2608,
-320
],
"parameters": {
"color": 4,
"width": 390,
"height": 464,
"content": "## 🎯 高价值潜在客户评分与提醒系统"
},
"typeVersion": 1
},
{
"id": "c922fb0a-b1fd-468f-90e5-4aa414efc93c",
"name": "计划设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2176,
-304
],
"parameters": {
"width": 280,
"height": 220,
"content": "## ⏰ 每日触发器"
},
"typeVersion": 1
},
{
"id": "5180b1c3-1f23-4101-918e-cf970e5a19ac",
"name": "HighLevel 设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1872,
-368
],
"parameters": {
"width": 300,
"height": 280,
"content": "## 📥 获取所有联系人"
},
"typeVersion": 1
},
{
"id": "ff5451e2-b740-4c16-a7b9-879083678689",
"name": "过滤逻辑说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1712,
80
],
"parameters": {
"width": 280,
"height": 220,
"content": "## 🔍 过滤具有自定义字段的联系人"
},
"typeVersion": 1
},
{
"id": "51cf93d7-a03e-4eed-b4c2-0cf0821d8536",
"name": "代码配置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1472,
-384
],
"parameters": {
"width": 300,
"height": 300,
"content": "## ⚙️ 转换联系人数据"
},
"typeVersion": 1
},
{
"id": "6f3ad72f-c5d5-476d-90dc-3ffc5181dca1",
"name": "分数阈值说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1328,
96
],
"parameters": {
"width": 280,
"height": 220,
"content": "## 🎯 潜在客户分数过滤器"
},
"typeVersion": 1
},
{
"id": "ead078ba-ec45-4702-bf08-d14d2fed451d",
"name": "Slack 配置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1056,
-512
],
"parameters": {
"width": 300,
"height": 332,
"content": "## 🚨 Slack 提醒设置"
},
"typeVersion": 1
},
{
"id": "81620101-5cd3-477e-aa1f-265fee1765ac",
"name": "Google Sheets 设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
144
],
"parameters": {
"width": 340,
"height": 380,
"content": "## 📊 Google Sheets 记录"
},
"typeVersion": 1
},
{
"id": "708a9b3f-9dc4-4e79-9457-7e4524d4c22e",
"name": "日历设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-544,
-368
],
"parameters": {
"width": 320,
"height": 348,
"content": "## 📅 自动安排跟进"
},
"typeVersion": 1
},
{
"id": "c29fd9ed-1582-488b-b4a6-0f02de537e46",
"name": "每日上午 8 点触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2064,
-64
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"typeVersion": 1.2
},
{
"id": "3a243805-b158-479c-afd4-431d5989fa24",
"name": "获取 HighLevel 联系人",
"type": "n8n-nodes-base.highLevel",
"position": [
-1840,
-64
],
"parameters": {
"filters": {},
"options": {},
"operation": "getAll",
"requestOptions": {}
},
"typeVersion": 2
},
{
"id": "03ed8e64-6a5f-48ac-a025-e379ab7d6b56",
"name": "过滤有效联系人",
"type": "n8n-nodes-base.if",
"position": [
-1616,
-64
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a49be490-38c5-4620-b29f-8150655f32ba",
"operator": {
"type": "array",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.customFields }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f006b6bf-4b73-45c6-802d-4cfa0e8e8584",
"name": "转换联系人数据",
"type": "n8n-nodes-base.code",
"position": [
-1392,
-64
],
"parameters": {
"jsCode": "// Process all items from the input\nconst items = $input.all();\n\n// Map through all items and extract/transform data\nreturn items.map(item => {\n const customFields = item.json.customFields || [];\n \n // ⚠️ IMPORTANT: Replace these field IDs with YOUR HighLevel custom field IDs\n // Find the lead score field (Replace 'sEic9OWa5yndTAitjgoe' with your field ID)\n const leadScoreField = customFields.find(field => field.id === 'YOUR_LEAD_SCORE_FIELD_ID');\n const leadScore = leadScoreField ? parseFloat(leadScoreField.value) : 0;\n \n // Extract assigned rep (Replace 'YHJqNOSAvMbI08mnabNb' with your field ID)\n const assignedRepField = customFields.find(field => field.id === 'YOUR_ASSIGNED_REP_FIELD_ID');\n const assignedRep = assignedRepField ? assignedRepField.value : 'Unassigned';\n \n return {\n json: {\n contact_id: item.json.id,\n contact_name: item.json.contactName,\n first_name: item.json.firstName,\n last_name: item.json.lastName,\n email: item.json.email || 'No email provided',\n phone: item.json.phone || 'No phone provided',\n company_name: item.json.companyName || 'N/A',\n lead_score: leadScore,\n assigned_rep: assignedRep,\n assigned_rep_slack_id: assignedRep, // TODO: Map to actual Slack member IDs\n location_id: item.json.locationId,\n source: item.json.source || 'Unknown',\n tags: Array.isArray(item.json.tags) ? item.json.tags.join(', ') : '',\n country: item.json.country,\n date_added: item.json.dateAdded,\n date_updated: item.json.dateUpdated,\n is_high_priority: leadScore > 80 // Boolean flag for workflow filtering\n }\n };\n});"
},
"typeVersion": 2
},
{
"id": "2bad2795-7f45-4170-8c9d-829193c25828",
"name": "检查是否为高价值潜在客户",
"type": "n8n-nodes-base.if",
"position": [
-1168,
-64
],
"parameters": {
"conditions": {
"number": [
{
"value1": "={{ $json.lead_score }}",
"value2": 80,
"operation": "larger"
}
]
}
},
"typeVersion": 1
},
{
"id": "1f2a561f-228b-4793-9823-413f0fd7cea3",
"name": "向销售团队发送 Slack 提醒",
"type": "n8n-nodes-base.slack",
"position": [
-944,
-160
],
"webhookId": "488b7831-8067-4c78-a12a-ab6b897e7528",
"parameters": {
"text": "=🚨 **High-Value Lead Alert**\n\n👤 **Contact:** {{ $json.contact_name }}\n📊 **Lead Score:** {{ $json.lead_score }}\n⏰ **Action Required:** Follow-up within 1 hour\n\n**Contact Details:**\n📧 Email: {{ $json.email }}\n📞 Phone: {{ $json.phone }}\n🏢 Company: {{ $json.company_name }}\n👨💼 Assigned Rep: {{ $json.assigned_rep }}\n📍 Location: {{ $json.country }}\n🏷️ Tags: {{ $json.tags }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "id",
"value": "YOUR_SLACK_CHANNEL_ID"
},
"otherOptions": {}
},
"typeVersion": 2.1
},
{
"id": "263b6c15-a8fb-44ee-b883-97964cde7176",
"name": "记录到 Google Sheets 跟踪器",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
48
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "contact_id",
"type": "string",
"display": true,
"required": false,
"displayName": "contact_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "contact_name",
"type": "string",
"display": true,
"required": false,
"displayName": "contact_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_name",
"type": "string",
"display": true,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "lead_score",
"type": "string",
"display": true,
"required": false,
"displayName": "lead_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "assigned_rep",
"type": "string",
"display": true,
"required": false,
"displayName": "assigned_rep",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "assigned_rep_slack_id",
"type": "string",
"display": true,
"required": false,
"displayName": "assigned_rep_slack_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "location_id",
"type": "string",
"display": true,
"required": false,
"displayName": "location_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source",
"type": "string",
"display": true,
"required": false,
"displayName": "source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tags",
"type": "string",
"display": true,
"required": false,
"displayName": "tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_added",
"type": "string",
"display": true,
"required": false,
"displayName": "date_added",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_updated",
"type": "string",
"display": true,
"required": false,
"displayName": "date_updated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_high_priority",
"type": "string",
"display": true,
"required": false,
"displayName": "is_high_priority",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "High Priority Leads"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_GOOGLE_SHEET_ID"
}
},
"typeVersion": 4
},
{
"id": "bd644f55-c61e-4e4d-8a9a-438749d094a7",
"name": "创建跟进日历事件",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-720,
-160
],
"parameters": {
"end": "={{ $now.plus(1.5, 'hours').toISO() }}",
"start": "={{ $now.plus(1, 'hours').toISO() }}",
"calendar": {
"__rl": true,
"mode": "list",
"value": "YOUR_CALENDAR_EMAIL"
},
"additionalFields": {
"description": "=**High-Priority Lead Follow-up**\n\nContact: {{ $json.contact_name }}\nEmail: {{ $json.email }}\nPhone: {{ $json.phone }}\nCompany: {{ $json.company_name }}\nLead Score: {{ $json.lead_score }}\nAssigned Rep: {{ $json.assigned_rep }}\n\nAction: Reach out within 1 hour to maintain engagement.",
"sendUpdates": "all"
}
},
"typeVersion": 1.3
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "be04a62e-8c04-4ee9-9bf1-ef74ae725aa5",
"connections": {
"Daily 8AM Trigger": {
"main": [
[
{
"node": "Fetch HighLevel Contacts",
"type": "main",
"index": 0
}
]
]
},
"Filter Valid Contacts": {
"main": [
[
{
"node": "Transform Contact Data",
"type": "main",
"index": 0
}
]
]
},
"Transform Contact Data": {
"main": [
[
{
"node": "Check If High-Value Lead",
"type": "main",
"index": 0
}
]
]
},
"Check If High-Value Lead": {
"main": [
[
{
"node": "Send Slack Alert to Sales Team",
"type": "main",
"index": 0
},
{
"node": "Log to Google Sheets Tracker",
"type": "main",
"index": 0
}
]
]
},
"Fetch HighLevel Contacts": {
"main": [
[
{
"node": "Filter Valid Contacts",
"type": "main",
"index": 0
}
]
]
},
"Send Slack Alert to Sales Team": {
"main": [
[
{
"node": "Create Follow-up Calendar Event",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 潜在客户开发
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
GoHighLevel管道速度跟踪器和自动化停滞交易提醒
使用GoHighLevel、Gmail和Slack分析管道速度并提醒停滞交易
If
Code
Gmail
+5
25 节点Rahul Joshi
内容创作
从 GoHighLevel 自动发送客户续约提醒到 Gmail 和 Slack
从GoHighLevel自动发送客户续约提醒到Gmail、Slack和Google Sheets
If
Code
Gmail
+7
19 节点Rahul Joshi
客户关系管理
使用GoHighLevel、Gmail、Slack和Sheets的每周客户互动自动化
每周客户再互动系统（GoHighLevel、Gmail、Sheets和Slack）
If
Code
Gmail
+7
23 节点Rahul Joshi
内容创作
使用 Google Drive、Gmail 和 Slack 的 GoHighLevel 客户入职流程
使用Google Drive、Gmail、Calendar和Slack自动化GoHighLevel客户入职
If
Code
Gmail
+6
23 节点Rahul Joshi
内容创作
从GoHighLevel自动清理非活跃交易到Slack和Sheets
将GoHighLevel中的非活跃交易自动清理至Slack和Sheets
Code
Slack
Filter
+4
15 节点Rahul Joshi
客户关系管理
潜在客户培育流失检测器
使用HighLevel、Gmail、Slack和Google表格的自动化销售跟进系统
If
Code
Wait
+6
23 节点Rahul Joshi
客户培育
工作流信息
难度等级
高级
节点数量17
分类1
节点类型8
作者
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
外部链接
在 n8n.io 查看 →
分享此工作流