GoHighLevel Product Sync from Google Sheets via Webhook

Sync Google Sheets Products into GoHighLevel (LeadConnector) via Webhook

This n8n workflow listens for a webhook request, then pulls only selected product rows from Google Sheets and syncs them into GoHighLevel (LeadConnector) by creating product records and the related price book entries—automatically.

What this workflow does

• Starts via webhook: Receives a POST request through an n8n webhook node to trigger the product sync.
• Reads products from Google Sheets: Loads product rows and filters to rows where the Select column is set to true.
• Avoids duplicates: Further filters to only rows where Creation Status is empty (so previously processed rows won’t be reprocessed).
• Creates products in GoHighLevel: Creates a product record in GoHighLevel using the custom_objects.products endpoint.
• Marks the source row as processed: Updates the Google Sheets row to set Creation Status to Yes and clears Select to false.
• Creates price book entries per price book: Splits the row’s comma-separated Pricebook field into individual price book names and loops through them.
• Finds matching price books and builds associations: For each price book, searches GoHighLevel for the matching record, creates a price_book_entry, and creates the required associations between:
  • the product and the price book, and
  • the price book entry and its related record.

Use cases

• Ops teams publish new products in Google Sheets and want them synced into GoHighLevel immediately.
• SaaS operators batch-manage product/pricing lists in Sheets while keeping GoHighLevel updated.
• Automation engineers need a reliable, idempotent-style sync that uses “Creation Status” to prevent duplicate imports.

Technical details

• Webhook trigger (n8n webhook node) to receive POST requests
• Google Sheets OAuth2 (Google Sheets node)
• Filtering logic via filter and code nodes (Select=true, Creation Status empty)
• GoHighLevel API calls using HTTP Request nodes with a GoHighLevel (LeadConnector) Private Integration token

Setup required: Add your GoHighLevel Private Integration token, set YOUR_GHL_LOCATION_ID and the two association IDs in request bodies, and connect Google Sheets OAuth2 credentials.