Migrate Salesforce Opportunity Line Items to GoHighLevel

Migrate Salesforce Opportunity Line Items into GoHighLevel (with a Google Sheets batch log)

This n8n workflow manually migrates your Salesforce Opportunity Line Items into GoHighLevel by creating custom_objects.opportunity_products records and linking them to existing GoHighLevel opportunities—using Google Sheets to track processing status from start to success/error.

What this workflow does

• Manual trigger: Runs when you execute the workflow manually in n8n.
• Reads batch inputs: Pulls unprocessed opportunity rows from Google Sheets where Created = "No", then limits the run to a defined batch size.
• Fetches Salesforce line items: For each Salesforce Opportunity ID in the sheet, queries Salesforce for up to 200 related OpportunityLineItem records.
• Processes item-by-item: Splits results into individual line items, skips records missing a Salesforce line item ID, and processes the remaining items sequentially.
• Updates sheet status: Marks the row as “processing started,” then paces API calls to avoid rate issues.
• Creates GoHighLevel products: Creates a GoHighLevel custom_objects.opportunity_products record populated with fields from the Salesforce line item.
• Associates to the parent opportunity: Creates a GoHighLevel association linking the new opportunity product to the corresponding GoHighLevel opportunity.
• Logs success or errors: Writes results back to Google Sheets and retries with waits between attempts when needed.

Use cases

• Moving active deals from Salesforce to GoHighLevel while preserving line-item details.
• Incremental migrations driven by a Google Sheets queue (process only rows not yet marked Created).
• Batch-controlled backfills to reduce load on Salesforce and GoHighLevel APIs.

Technical details

• Salesforce OAuth2: HTTP requests to query OpportunityLineItems (replace your org domain in the URL).
• GoHighLevel Private Integration: Uses your token, location ID, and association ID for record creation and linking.
• n8n nodes used: http request, if, limit, split out, wait, plus a sticky note for workflow clarity.

Setup: Add Salesforce OAuth2 credentials, update the Salesforce request URL with your org domain, and provide GoHighLevel Private Integration values (YOUR_GHL_API_TOKEN, YOUR_GHL_LOCATION_ID, YOUR_GHL_ASSOCIATION_ID).