Sync NPD Product Pricing from Google Sheets to GoHighLevel

Sync NPD Product Pricing from Google Sheets to GoHighLevel—automatically

This n8n workflow takes your NPD product list from Google Sheets, calculates the correct sell price using your margin rules, and then creates matching GoHighLevel product records and price book entries via the LeadConnector API—driven by a simple webhook request.

What this workflow does

• Receives a POST webhook with two Google Sheets IDs: the NPD spreadsheet ID and the margin spreadsheet ID.
• Filters NPD products by reading all rows from the NPD Google Sheet and keeping only products where the “SKU status” field contains “NPD”.
• Calculates sell price from the margin sheet by processing products one at a time and matching margin rows by brand.
• Supports two pricing approaches:
  • “Bespoke” pricing: creates one entry per customer margin rule.
  • “Standard” pricing: uses the wholesale price.
• Creates GoHighLevel records for each calculated item:
  • Product record in custom_objects.products_1 using the LeadConnector API.
  • Corresponding price book entry in custom_objects.price_book_entry.
• Continues until all filtered items are processed.

Use cases

• Keep NPD pricing in sync between your product management spreadsheets and GoHighLevel without manual updates.
• Apply brand-based margin rules and generate bespoke vs standard pricing automatically.
• Use n8n as an integration layer for SaaS operators who want consistent product/price publishing to GoHighLevel custom objects.

Technical details

• Webhook to accept Google Sheets IDs.
• Google Sheets OAuth2 credentials for both the NPD sheet and the margin sheet.
• Nodes include: if, code, filter, webhook, and http request (plus a sticky note).
• Uses LeadConnector via HTTP Request with:
  • Authorization: Bearer YOUR_GHL_API_TOKEN
  • Replaces YOUR_GHL_LOCATION_ID in each request body.