Rahul Joshi This workflow corresponds to n8n.io template #9143 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "7Mu8qjTtj8d94K08",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "GoHighLevel Pipeline Velocity Tracker & Automated Stuck Deal Alerts",
"tags": [],
"nodes": [
{
"id": "54615dae-9ea1-4c79-89b8-6227dcf34136",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1472,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3c3938c2-468a-48a6-acd8-94ac8c623989",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-944,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "097bbb09-68d7-42e9-90ee-8b57eb897045",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-640,
464
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d73469cc-02d5-489d-bece-4a2c4e8fcbb5",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
-352
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9ef8cc7d-fb3f-44a2-ab7d-60b6093d009d",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-192,
-448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "02f7278f-9470-48a5-9371-9f798efd333a",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
64,
448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "04beef66-2aa6-4ff1-91e9-f373bb602d82",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
160,
-560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c9acedd9-4ff3-4275-a3a4-b3bf328fb565",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
544,
-688
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "97b966ff-1f98-4eb6-922f-244112797c93",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
976,
-496
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c1ff95cb-b8fa-4c4b-a3d5-5a5fa22dd748",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
544
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5fb06d0a-3f10-46c6-a330-3b5a4c54a513",
"name": "Weekly Trigger - Monday 8AM",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-768,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "f028f20a-6217-4022-ad94-d70e68803ef0",
"name": "Fetch GHL Pipeline Data",
"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": "Transform Stage Data",
"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": "Log to 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": "Filter Stuck Deals (7+ Days)",
"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": "Calculate Stage Metrics",
"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": "Generate Weekly Report",
"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": "Generate Stuck Deal Alert",
"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": "Send Stuck Deal Alert",
"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
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "31cb8a69-1047-49aa-af74-96710388b11c",
"name": "Send Weekly Report Email",
"type": "n8n-nodes-base.gmail",
"notes": "Delivers weekly performance report to sales leadership",
"position": [
800,
0
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "e31fdf64-5a5c-45d9-b6d2-5a1b53f73dd8",
"name": "Send a message",
"type": "n8n-nodes-base.slack",
"position": [
576,
384
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "c6121da5-c974-45da-88dd-761b0ed02941",
"name": "Sticky Note10",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6987988d-84b5-4099-9847-7e3cbd4b5fb9",
"name": "Send Error Alert",
"type": "n8n-nodes-base.gmail",
"notes": "Sends an email when the workflow fails",
"position": [
-96,
384
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "dca4366e-332a-4b7e-bf27-36eb61ea490f",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
-320,
288
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "613b3be0-cb7e-4a44-a64e-c8f0587cfb2f",
"name": "Sticky Note11",
"type": "n8n-nodes-base.stickyNote",
"position": [
-224,
576
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"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
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Automate your GoHighLevel (GHL) pipeline tracking and deal management process. This workflow fetches all opportunities, calculates the time spent in each stage, logs historical pipeline data in Google Sheets, identifies deals stuck for more than 7 days, generates HTML and text…
Source: https://n8n.io/workflows/9143/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automatically scans AWS accounts for orphaned resources (unattached EBS volumes, old snapshots >90 days, unassociated Elastic IPs) that waste money. It calculates cost impact, validat
Streamline IT and operations change management by automating approval routing, Jira issue creation, audit logging, and real-time Slack alerts. This workflow ensures faster reviews, traceable approvals
Streamline IT and operations change management by automating approval routing, Jira issue creation, audit logging, and real-time Slack alerts. This workflow ensures faster reviews, traceable approvals
Automatically consolidate Zendesk and Freshdesk ticket data into a unified performance dashboard with KPI calculations, Google Sheets logging, real-time Slack alerts, and weekly Gmail email reports. P
E-commerce store owners, product managers, marketplace sellers, and pricing analysts who want to automatically track competitor pricing and get actionable alerts when their products are overpriced or