Migrate Salesforce product catalog from Google Sheets to GoHighLevel custom objects
Ready for 3.0What this workflow does
This workflow has 19 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Slack, Google Sheets, Telegram and Airtable and 1 more. It also calls services.leadconnectorhq.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Sheets - Read Salesforce Products (Google Sheets): uses Google Sheets
- Slack: uses Slack
- Limit: keeps the first few items
- Validate Input – Check Required Columns (Code): runs custom JavaScript code
- Telegram: uses Telegram
- Wait: waits 2 seconds
- Loop Over Products (Loop Over Items (Split in Batches)): loops over the items in batches
- Build Run Summary (Code): runs custom JavaScript code
- GHL - Create Custom Object Product Record (HTTP Request): calls services.leadconnectorhq.com (POST)
- Slack: uses Slack
…plus 7 more steps. See the full node list below.
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 (12)
- Slack
n8n-nodes-base.slack - Error Trigger
n8n-nodes-base.errorTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Limit
n8n-nodes-base.limit - Code
n8n-nodes-base.code - Telegram
n8n-nodes-base.telegram - Wait
n8n-nodes-base.wait - Airtable
n8n-nodes-base.airtable - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow manually migrates product rows from a Salesforce export in Google Sheets into GoHighLevel custom object records via the LeadConnector API, then updates the source sheet with success or error flags and posts a Slack alert if the…