Analyze pipeline velocity & alert stuck deals with GoHighLevel, Gmail & Slack
Ready for 3.0What this workflow does
This workflow has 13 nodes and runs on a schedule (every day). Along the way it connects HighLevel, Google Sheets, Gmail and Slack.
How it runs
Trigger: On a schedule (every day).
- Fetch GHL Pipeline Data (HighLevel): uses HighLevel
- If: checks a condition and branches into true / false
- Transform Stage Data (Code): runs custom JavaScript code
- Send Error Alert (Gmail): uses Gmail
- Log to Google Sheets (Google Sheets): uses Google Sheets
- Filter Stuck Deals (7+ Days) (If): checks a condition and branches into true / false
- Calculate Stage Metrics (Code): runs custom JavaScript code
- Generate Stuck Deal Alert (Code): runs custom JavaScript code
- Generate Weekly Report (Code): runs custom JavaScript code
- Send Stuck Deal Alert (Gmail): uses Gmail
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HighLevel
n8n-nodes-base.highLevel - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack
From the author
Description 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…