Create GoHighLevel product and pricebook records from Google Sheets
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets. It also calls services.leadconnectorhq.com over HTTP.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Sheets - Read Product Rows (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- GHL - Create Product Custom Object (HTTP Request): calls services.leadconnectorhq.com (POST)
- Sheets - Update Product Row Status (Google Sheets): update
- Split Pricebooks into Loop Items (Code): runs custom JavaScript code
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- GHL - Search Pricebook by Name (HTTP Request): calls services.leadconnectorhq.com (POST)
- GHL - Associate Product to Named Pricebook (HTTP Request): calls services.leadconnectorhq.com (POST)
- GHL - Associate PBE to Pricebook (HTTP Request): calls services.leadconnectorhq.com (POST)
- GHL - Associate PBE to Product (HTTP Request): calls services.leadconnectorhq.com (POST)
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)
- HTTP Request
n8n-nodes-base.httpRequest - Webhook
n8n-nodes-base.webhook - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Filter
n8n-nodes-base.filter
From the author
Quick overview This workflow uses a webhook to sync selected product rows from Google Sheets into GoHighLevel (LeadConnector) custom objects by creating a product record, then creating price book entry records and associating them to the corresponding…