Create GoHighLevel business custom fields from Google Sheets with Slack alerts
Ready for 3.0What this workflow does
This workflow has 10 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and Slack. It also calls services.leadconnectorhq.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Sheets - Read Account Custom Fields (Google Sheets): uses Google Sheets
- GHL - Get Business Custom Fields (HTTP Request): calls services.leadconnectorhq.com
- Slack: uses Slack
- Loop Over Account Custom Fields (Loop Over Items (Split in Batches)): loops over the items in batches
- Field Already Exists? (If): checks a condition and branches into true / false
- GHL - Create Business Custom Field (HTTP Request): calls services.leadconnectorhq.com (POST)
- Sheets - Log Field Created (Success) (Google Sheets): append or update
- Sheets - Log Field Creation Error (Google Sheets): append or update
Services it uses
HTTP calls to: services.leadconnectorhq.com
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)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Error Trigger
n8n-nodes-base.errorTrigger - Slack
n8n-nodes-base.slack
From the author
Quick overview This workflow uses Google Sheets as a source of truth to create GoHighLevel (LeadConnector) business custom fields in bulk, skipping fields that are already marked as done, and posts a Slack alert if the workflow errors. How it works 1.…