{"product_id":"sync-salesforce-pricebook-entries-to-gohighlevel-custom-objects","title":"Sync Salesforce Pricebook Entries to GoHighLevel Custom Objects","description":"\u003ch3\u003eSync Salesforce Pricebook Entries into GoHighLevel Custom Objects (with Google Sheets logging)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow lets you manually sync Salesforce \u003cstrong\u003ePricebookEntry\u003c\/strong\u003e records from a Google Sheets list into \u003cstrong\u003eGoHighLevel (LeadConnector)\u003c\/strong\u003e by creating \u003cstrong\u003ecustom_objects.price_book_entry\u003c\/strong\u003e records, associating them to the related product, and writing back \u003cem\u003eSuccess\u003c\/em\u003e\/\u003cem\u003eError\u003c\/em\u003e statuses in your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e Starts when you manually execute the workflow in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads unprocessed rows from Google Sheets:\u003c\/strong\u003e Pulls rows from the configured \u003cstrong\u003ePricebook Entries\u003c\/strong\u003e tab where the \u003cstrong\u003eCreated\u003c\/strong\u003e column is set to \u003cstrong\u003eNo\u003c\/strong\u003e, then processes them one by one (batch size is limited).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStatus updates in the sheet:\u003c\/strong\u003e Marks each row as “processing started,” then updates it to \u003cstrong\u003eYes\u003c\/strong\u003e on success or \u003cstrong\u003eError\u003c\/strong\u003e if anything fails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches full PricebookEntry details from Salesforce:\u003c\/strong\u003e Uses the Salesforce PricebookEntry \u003cstrong\u003eId\u003c\/strong\u003e in the current row to query full record details, including \u003cstrong\u003ePricebook2\u003c\/strong\u003e and \u003cstrong\u003eProduct2\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates GoHighLevel custom objects:\u003c\/strong\u003e Creates a record in \u003cstrong\u003ecustom_objects.price_book_entry\u003c\/strong\u003e using pricing and product fields sourced from Salesforce.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates the association relation:\u003c\/strong\u003e Links the new GoHighLevel price book entry to the configured related record via an association step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetry-friendly behavior:\u003c\/strong\u003e Waits between retries to help reduce rate-limit issues when calls fail.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMove Salesforce pricing data into GoHighLevel when you maintain a price list in Salesforce but need it available in GoHighLevel custom objects.\u003c\/li\u003e\n  \u003cli\u003eRun controlled, on-demand synchronizations using Google Sheets as your processing queue.\u003c\/li\u003e\n  \u003cli\u003eTrack sync outcomes per record with clear “Yes\/Error” logging for operational visibility.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e Manual Trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e OAuth2 + read\/write row statuses (including \u003cstrong\u003eCreated\u003c\/strong\u003e column control and \u003cstrong\u003egid\u003c\/strong\u003e tab selection)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSalesforce:\u003c\/strong\u003e HTTP Request to query PricebookEntry details by record \u003cstrong\u003eId\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoHighLevel (LeadConnector):\u003c\/strong\u003e HTTP Request to create \u003cstrong\u003ecustom_objects.price_book_entry\u003c\/strong\u003e and create an association to the related record\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eControls:\u003c\/strong\u003e Limit + Wait (to manage batches and reduce rate limits)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974302621875,"sku":"N8N-19309","price":17.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/E-wmC-kPHg5RayljhwdZV_sGt3xJg6.png?v=1788771801","url":"https:\/\/buyflowscripts.com\/products\/sync-salesforce-pricebook-entries-to-gohighlevel-custom-objects","provider":"N8N Commerce","version":"1.0","type":"link"}