Sync Salesforce pricebook entries to GoHighLevel custom objects with Google Sheets
Ready for 3.0What this workflow does
This workflow has 15 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 Pricebook Entries (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Sheets - Update Row Before GHL Sync (Google Sheets): update
- SF - Query Pricebook & Product Details (HTTP Request): calls an HTTP API
- Wait: waits 30 seconds
- GHL - Create Price Book Entry Custom Object (HTTP Request): calls services.leadconnectorhq.com (POST)
- Sheets - Log SF Query Error (Google Sheets): update
- GHL - Associate Price Book Entry to Product (HTTP Request): calls services.leadconnectorhq.com (POST)
- Sheets - Log GHL Create Error (Google Sheets): update
…plus 4 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 (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Limit
n8n-nodes-base.limit - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow manually syncs Salesforce PricebookEntry records listed in Google Sheets into GoHighLevel (LeadConnector) as customobjects.pricebookentry records, then creates an association to the related product and logs success or error…