Migrate Salesforce Products to GoHighLevel Custom Objects via Sheets

Migrate Salesforce Products into GoHighLevel Custom Objects—From Google Sheets

This n8n workflow reads product rows exported from Salesforce in Google Sheets, creates matching GoHighLevel custom object records via the LeadConnector API, and then writes back success/error status to the sheet—so your migration stays trackable and safe.

What this workflow does

• Manual trigger: Runs when you execute the workflow manually.
• Reads Salesforce export rows: Pulls product rows from a Google Sheets tab where the Created column is set to No, and processes only up to a configurable batch size.
• Creates GoHighLevel records: For each product row, sends a POST request using n8n’s HTTP Request node to create a record in custom_objects.products_1, mapping product properties from the sheet.
• Updates the source sheet: On success, updates the same Google Sheets row to mark it as created and stores the returned GoHighLevel record ID.
• Continues on errors: If GoHighLevel returns an error, flags the row as error in Google Sheets and continues processing the next product.
• Slack alert on failure: If the workflow fails due to any node-level issue, it posts an error alert to a specified Slack channel.

Use cases

• Move Salesforce product catalogs into GoHighLevel custom objects after an export.
• Run repeatable batch migrations (controlled by batch size) without reprocessing already-created rows.
• Operationally monitor integration health with Slack failure alerts and per-row status written back to Google Sheets.

Technical details

• Nodes / integrations: Limit, Slack, Sticky Note, HTTP Request, Error Trigger, Google Sheets.
• Auth & endpoints: Use a GoHighLevel (LeadConnector) private integration token via environment variables like YOUR_GHL_API_TOKEN and set YOUR_GHL_LOCATION_ID in the HTTP request configuration.
• Schema requirement: Ensure GoHighLevel has a custom object schema named custom_objects.products_1 with fields matching the properties sent in the API request.
• Sheet syncing: Configure Google Sheets OAuth2 credentials, including YOUR_GOOGLE_SHEET_ID_2 and the target sheet tab used to read/update migration status.