GoHighLevel管道速度跟踪器和自动化停滞交易提醒
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 25 个节点。主要使用 If, Code, Gmail, Slack, HighLevel 等节点。 使用GoHighLevel、Gmail和Slack分析管道速度并提醒停滞交易
前置要求
- •Google 账号和 Gmail API 凭证
- •Slack Bot Token 或 Webhook URL
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "7Mu8qjTtj8d94K08",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "GoHighLevel管道速度跟踪器和自动化停滞交易提醒",
"tags": [],
"nodes": [
{
"id": "54615dae-9ea1-4c79-89b8-6227dcf34136",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1472,
-352
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "3c3938c2-468a-48a6-acd8-94ac8c623989",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-944,
-176
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "097bbb09-68d7-42e9-90ee-8b57eb897045",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
464
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "d73469cc-02d5-489d-bece-4a2c4e8fcbb5",
"name": "便签 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
-352
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "9ef8cc7d-fb3f-44a2-ab7d-60b6093d009d",
"name": "便签 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-448
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "02f7278f-9470-48a5-9371-9f798efd333a",
"name": "便签 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
448
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "04beef66-2aa6-4ff1-91e9-f373bb602d82",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-560
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "c9acedd9-4ff3-4275-a3a4-b3bf328fb565",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
-688
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "97b966ff-1f98-4eb6-922f-244112797c93",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
976,
-496
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "c1ff95cb-b8fa-4c4b-a3d5-5a5fa22dd748",
"name": "### 替换 Airtable 连接",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
544
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "5fb06d0a-3f10-46c6-a330-3b5a4c54a513",
"name": "每周触发器 - 周一上午8点",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-768,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f028f20a-6217-4022-ad94-d70e68803ef0",
"name": "获取GHL管道数据",
"type": "n8n-nodes-base.highLevel",
"notes": "Retrieves all opportunities from GoHighLevel. Configure pipeline filter if needed.",
"position": [
-544,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "34e81ae7-95eb-40cf-be7a-2dd8f34672ff",
"name": "转换阶段数据",
"type": "n8n-nodes-base.code",
"notes": "Calculates time spent in each stage and prepares data for Google Sheets",
"position": [
-96,
192
],
"parameters": {},
"typeVersion": 2
},
{
"id": "857a5082-7bd8-4dbc-804a-ef4d6b15a9f4",
"name": "记录到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "Stores historical pipeline data for tracking trends over time",
"position": [
128,
0
],
"parameters": {},
"typeVersion": 4
},
{
"id": "72dbf078-bdee-4aec-af05-6962ba3641e3",
"name": "过滤停滞交易（7天以上）",
"type": "n8n-nodes-base.if",
"notes": "Triggers if deal is in current stage for more than 7 days (configurable)",
"position": [
128,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ca9bc77b-7eec-4708-ab61-d30bc04f0a32",
"name": "计算阶段指标",
"type": "n8n-nodes-base.code",
"notes": "Aggregates metrics and identifies bottleneck stages",
"position": [
352,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "c9804b69-68de-482e-917d-e56772ed4583",
"name": "生成周报",
"type": "n8n-nodes-base.code",
"notes": "Generates HTML and text versions of the weekly report",
"position": [
576,
0
],
"parameters": {},
"typeVersion": 2
},
{
"id": "cd9073d7-7fdc-4d72-b03c-384437f03b87",
"name": "生成停滞交易提醒",
"type": "n8n-nodes-base.code",
"notes": "Creates alert email for deals stuck longer than threshold",
"position": [
352,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "5f6d6e29-edbb-4fa8-bf9d-32c3ba9a5b14",
"name": "发送停滞交易提醒",
"type": "n8n-nodes-base.gmail",
"notes": "Sends alert to sales manager when deals are stuck (SECURITY FIX: no longer sends to customer email)",
"position": [
576,
192
],
"webhookId": "976ecd35-8e62-4774-a66e-be51576b30cb",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "31cb8a69-1047-49aa-af74-96710388b11c",
"name": "发送周报邮件",
"type": "n8n-nodes-base.gmail",
"notes": "Delivers weekly performance report to sales leadership",
"position": [
800,
0
],
"webhookId": "976ecd35-8e62-4774-a66e-be51576b30cb",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e31fdf64-5a5c-45d9-b6d2-5a1b53f73dd8",
"name": "发送消息",
"type": "n8n-nodes-base.slack",
"position": [
576,
384
],
"webhookId": "5d078c59-21d9-4e5c-8c25-61564de2b7d0",
"parameters": {},
"typeVersion": 2.3
},
{
"id": "c6121da5-c974-45da-88dd-761b0ed02941",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
400
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
},
{
"id": "6987988d-84b5-4099-9847-7e3cbd4b5fb9",
"name": "发送错误提醒",
"type": "n8n-nodes-base.gmail",
"notes": "Sends an email when the workflow fails",
"position": [
-96,
384
],
"webhookId": "ce5e05f7-e0df-4dfa-9b60-a83fd46b8ec8",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "dca4366e-332a-4b7e-bf27-36eb61ea490f",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
-320,
288
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "613b3be0-cb7e-4a44-a64e-c8f0587cfb2f",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
576
],
"parameters": {
"content": "Emelia 触发器"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "e5e34994-02a0-4a76-89f0-cb65e5f6374d",
"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
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用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、Gmail 和 Notion 自动化 NPS 调查收集与响应处理
使用GoHighLevel、Gmail和Notion自动化NPS调查收集与响应处理
If
Code
Gmail
+5
27 节点Rahul Joshi
内容创作
客户入职帮助请求（Typeform 到 Gmail 和 Sheets）
客户入职帮助请求（Typeform 到 Gmail 和 Sheets）
If
Code
Gmail
+10
28 节点Rahul Joshi
内容创作
Stripe 税务摘要到 Google Sheets 并附带 Slack 提醒
从 Stripe 生成税务摘要，存储到 Google Sheets，并发送 Slack 提醒
If
Set
Code
+5
17 节点Rahul Joshi
内容创作
监控Zendesk流失风险信号并在Slack中通知CS团队
监控Zendesk流失风险信号，记录到表格，并在Slack中通知团队
If
Code
Slack
+4
12 节点Rahul Joshi
内容创作
工作流信息
难度等级
高级
节点数量25
分类2
节点类型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 查看 →
分享此工作流