Track marketing channel performance with HighLevel, Google Sheets, and Slack
Needs changesWhat this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Slack and HighLevel.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch All HighLevel Opportunities (HighLevel): get many (opportunity)
- Check If Status = Won (If): checks a condition and branches into true / false
- Log Won Deals to Sheets (Google Sheets): uses Google Sheets
- Alert Non-Won Status to Slack (Slack): uses Slack
- Calculate Lead Source Metrics (Function): runs custom JavaScript (legacy Function node)
- Send Analytics to Slack (Slack): uses Slack
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Function (legacy) in Calculate Lead Source Metrics: replace with Code node, mode 'Run Once for All Items'.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Calculate Lead Source Metrics | Code node, mode 'Run Once for All Items' |
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Function
n8n-nodes-base.function - Slack
n8n-nodes-base.slack - HighLevel
n8n-nodes-base.highLevel - If
n8n-nodes-base.if
From the author
Description: 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…