Migrate Salesforce opportunity line items to GoHighLevel with Google Sheets
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls services.leadconnectorhq.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Sheets - Read Opportunity Records (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- SF - Query Opportunity Line Items (HTTP Request): calls an HTTP API
- Split Out: splits a list into separate items
- Line Items Found? (If): checks a condition and branches into true / false
- Loop Over Line Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Sheets - Update Row Before GHL Sync (Google Sheets): update
- GHL - Create Opportunity Product Custom Object (HTTP Request): calls services.leadconnectorhq.com (POST)
- Wait: waits 30 seconds
- GHL - Associate Opportunity Product to Opportunity (HTTP Request): calls services.leadconnectorhq.com (POST)
…plus 6 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 (8)
- HTTP Request
n8n-nodes-base.httpRequest - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Limit
n8n-nodes-base.limit - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow manually migrates Salesforce Opportunity Line Items into GoHighLevel by creating customobjects.opportunityproducts records and associating them to existing opportunities, using Google Sheets as the batch input and status log. How…