Rahul Joshi This workflow corresponds to n8n.io template #10149 — we link there as the canonical source.
This workflow follows the Google Sheets → Slack 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": "K9qVquFhgKL4K7Sy",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Lead Source Quality Analyzer",
"tags": [],
"nodes": [
{
"id": "d4979a88-400d-4ce0-a27e-e0465b248e7e",
"name": "When clicking \u2018Execute workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
32,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "1a91fc6a-fa5b-4985-ae23-d9e02e2ad1dd",
"name": "Sticky Note - Workflow Overview",
"type": "n8n-nodes-base.stickyNote",
"position": [
-336,
496
],
"parameters": {
"color": 4,
"width": 320,
"height": 280,
"content": "## \ud83d\udcca WORKFLOW START\n\nThis workflow analyzes lead source quality by:\n1. Fetching opportunities from HighLevel\n2. Filtering won deals\n3. Computing conversion metrics\n4. Sending reports to Slack and Google Sheets\n\n**Trigger:** Manual execution"
},
"typeVersion": 1
},
{
"id": "8908da61-371e-4efe-986f-199ef3889a1a",
"name": "Sticky Note - Fetch Data",
"type": "n8n-nodes-base.stickyNote",
"position": [
112,
304
],
"parameters": {
"color": 5,
"width": 280,
"height": 284,
"content": "## \ud83c\udfaf FETCH OPPORTUNITIES\n\nRetrieves all opportunities from HighLevel CRM.\n\nThis is the data source for the entire analysis.\n\n**Output:** List of all opportunities with status, amount, and lead source information."
},
"typeVersion": 1
},
{
"id": "0cf6069e-5d6f-4337-b213-1931fb787104",
"name": "Sticky Note - Filtering Logic",
"type": "n8n-nodes-base.stickyNote",
"position": [
352,
768
],
"parameters": {
"color": 6,
"width": 300,
"height": 296,
"content": "## \u2705 FILTER WON DEALS\n\nSplits the workflow into two paths:\n\n**TRUE Path:** Opportunities with status = 'won'\n\u2192 Goes to analysis and reporting\n\n**FALSE Path:** All other opportunities\n\u2192 Sends individual notifications to Slack\n\nThis ensures only successful deals are analyzed for lead source quality."
},
"typeVersion": 1
},
{
"id": "d751b397-2da7-468c-af32-c469485e9847",
"name": "Sticky Note - Analytics",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
240
],
"parameters": {
"color": 7,
"width": 520,
"height": 240,
"content": "## \ud83d\udcc8 ANALYTICS PIPELINE\n\nProcesses won deals through:\n\n1. **Google Sheets:** Logs raw won deal data\n2. **Metrics Calculation:** Aggregates by lead source\n3. **Slack Report:** Sends summary to team\n\nThis pipeline provides both raw data storage and actionable insights."
},
"typeVersion": 1
},
{
"id": "ba86138e-0226-401c-84c3-22ab9b9baecc",
"name": "Sticky Note - Status Alerts",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
800
],
"parameters": {
"color": 3,
"width": 280,
"height": 268,
"content": "## \ud83d\udd14 NON-WON NOTIFICATION\n\nSends individual Slack messages for opportunities that are NOT won.\n\nUseful for tracking:\n- Lost opportunities\n- Pending deals\n- Other statuses requiring attention"
},
"typeVersion": 1
},
{
"id": "48d32b33-0535-4cda-9f9b-aaf70d494950",
"name": "Log Won Deals to Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
720,
512
],
"parameters": {
"range": "Sheet1!A1:D1",
"options": {},
"sheetId": "<YOUR_GOOGLE_SHEET_ID>",
"authentication": "oAuth2"
},
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "66b4ddec-d5ed-47b7-8392-dc048b75f4cb",
"name": "Calculate Lead Source Metrics",
"type": "n8n-nodes-base.function",
"position": [
944,
512
],
"parameters": {
"functionCode": "const sourceData = items.map(i => i.json);\nconst result = {};\n\nsourceData.forEach(deal => {\n const source = deal.leadSource;\n if (!result[source]) result[source] = { deals: 0, totalAmount: 0 };\n result[source].deals += 1;\n result[source].totalAmount += parseFloat(deal.amount || 0);\n});\n\nreturn [{ json: result }];"
},
"typeVersion": 1
},
{
"id": "8f3105fb-6b5c-4882-8144-6cde4aadb837",
"name": "Send Analytics to Slack",
"type": "n8n-nodes-base.slack",
"position": [
1168,
512
],
"parameters": {
"text": "={{JSON.stringify($json, null, 2)}}",
"channel": "#lead-source-report",
"attachments": [],
"otherOptions": {}
},
"credentials": {
"slackApi": {
"name": "<your credential>"
}
},
"typeVersion": 1
},
{
"id": "c635333b-e2ff-403c-ad24-809d7ff7b2ac",
"name": "Fetch All HighLevel Opportunities",
"type": "n8n-nodes-base.highLevel",
"position": [
272,
608
],
"parameters": {
"filters": {},
"resource": "opportunity",
"operation": "getAll",
"returnAll": true,
"requestOptions": {}
},
"credentials": {
"highLevelOAuth2Api": {
"name": "<your credential>"
}
},
"typeVersion": 2
},
{
"id": "bca4f587-dc3a-4979-9d80-8f172d6f888a",
"name": "Check If Status = Won",
"type": "n8n-nodes-base.if",
"position": [
496,
608
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "101c298b-4c62-4273-9d25-bad055eff980",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "=won"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "5c2b45bc-4c6a-4263-b5a6-f56e796f7aee",
"name": "Alert Non-Won Status to Slack",
"type": "n8n-nodes-base.slack",
"position": [
720,
704
],
"parameters": {
"text": "=Opportuniy id: {{ $json.id }} is {{ $json.status }}",
"select": "channel",
"channelId": {
"__rl": true,
"mode": "list",
"value": "C09GNB90TED",
"cachedResultName": "general-information"
},
"otherOptions": {}
},
"credentials": {
"slackApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.3
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "0baa1992-9f7c-4c69-94bd-25d9fe883283",
"connections": {
"Check If Status = Won": {
"main": [
[
{
"node": "Log Won Deals to Sheets",
"type": "main",
"index": 0
}
],
[
{
"node": "Alert Non-Won Status to Slack",
"type": "main",
"index": 0
}
]
]
},
"Log Won Deals to Sheets": {
"main": [
[
{
"node": "Calculate Lead Source Metrics",
"type": "main",
"index": 0
}
]
]
},
"Calculate Lead Source Metrics": {
"main": [
[
{
"node": "Send Analytics to Slack",
"type": "main",
"index": 0
}
]
]
},
"Fetch All HighLevel Opportunities": {
"main": [
[
{
"node": "Check If Status = Won",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Execute workflow\u2019": {
"main": [
[
{
"node": "Fetch All HighLevel Opportunities",
"type": "main",
"index": 0
}
]
]
}
}
}
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
googleSheetsOAuth2ApihighLevelOAuth2ApislackApi
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Discover which marketing channels actually convert with this n8n automation template. The workflow fetches all opportunities from HighLevel (GHL), filters for “Closed Won” deals, computes lead-to-sale conversion metrics per source, and sends a summary report to Slack while…
Source: https://n8n.io/workflows/10149/ — 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 automates sales contact follow-ups and engagement tracking by integrating HighLevel CRM, Gmail, Slack, and Google Sheets. It fetches all contacts from HighLevel, filters inactive contact
Run professional email campaigns with A/B testing, Google Sheets tracking, and Slack analytics. FEATURES:
Keep your CRM and task system perfectly in sync — automatically. This workflow monitors a Google Sheet for lead reply updates, instantly updates the corresponding contact in GoHighLevel (GHL), and cre
Streamline sales prioritization by automatically identifying, scoring, and routing high-value leads from GoHighLevel CRM to your sales team. This workflow scores contacts daily, flags top prospects, a
This workflow allows you to send multi-step email campaigns using n8n, Gmail and Google Sheets.