Sync Salesforce Pricebook Entries to GoHighLevel Custom Objects

Sync Salesforce Pricebook Entries into GoHighLevel Custom Objects (with Google Sheets logging)

This n8n workflow lets you manually sync Salesforce PricebookEntry records from a Google Sheets list into GoHighLevel (LeadConnector) by creating custom_objects.price_book_entry records, associating them to the related product, and writing back Success/Error statuses in your sheet.

What this workflow does

• Manual trigger: Starts when you manually execute the workflow in n8n.
• Reads unprocessed rows from Google Sheets: Pulls rows from the configured Pricebook Entries tab where the Created column is set to No, then processes them one by one (batch size is limited).
• Status updates in the sheet: Marks each row as “processing started,” then updates it to Yes on success or Error if anything fails.
• Fetches full PricebookEntry details from Salesforce: Uses the Salesforce PricebookEntry Id in the current row to query full record details, including Pricebook2 and Product2.
• Creates GoHighLevel custom objects: Creates a record in custom_objects.price_book_entry using pricing and product fields sourced from Salesforce.
• Creates the association relation: Links the new GoHighLevel price book entry to the configured related record via an association step.
• Retry-friendly behavior: Waits between retries to help reduce rate-limit issues when calls fail.

Use cases

• Move Salesforce pricing data into GoHighLevel when you maintain a price list in Salesforce but need it available in GoHighLevel custom objects.
• Run controlled, on-demand synchronizations using Google Sheets as your processing queue.
• Track sync outcomes per record with clear “Yes/Error” logging for operational visibility.

Technical details

• Trigger: Manual Trigger
• Google Sheets: OAuth2 + read/write row statuses (including Created column control and gid tab selection)
• Salesforce: HTTP Request to query PricebookEntry details by record Id
• GoHighLevel (LeadConnector): HTTP Request to create custom_objects.price_book_entry and create an association to the related record
• Controls: Limit + Wait (to manage batches and reduce rate limits)