{"product_id":"sync-npd-product-pricing-from-google-sheets-to-gohighlevel","title":"Sync NPD Product Pricing from Google Sheets to GoHighLevel","description":"\u003ch3\u003eSync NPD Product Pricing from Google Sheets to GoHighLevel—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes your NPD product list from Google Sheets, calculates the correct sell price using your margin rules, and then creates matching \u003cstrong\u003eGoHighLevel\u003c\/strong\u003e product records and \u003cstrong\u003eprice book entries\u003c\/strong\u003e via the LeadConnector API—driven by a simple webhook request.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST webhook\u003c\/strong\u003e with two Google Sheets IDs: the NPD spreadsheet ID and the margin spreadsheet ID.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters NPD products\u003c\/strong\u003e by reading all rows from the NPD Google Sheet and keeping only products where the \u003cstrong\u003e“SKU status”\u003c\/strong\u003e field contains \u003cstrong\u003e“NPD”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates sell price from the margin sheet\u003c\/strong\u003e by processing products one at a time and matching margin rows by \u003cstrong\u003ebrand\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSupports two pricing approaches:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003e“Bespoke”\u003c\/strong\u003e pricing: creates one entry per customer margin rule.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003e“Standard”\u003c\/strong\u003e pricing: uses the \u003cstrong\u003ewholesale price\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates GoHighLevel records\u003c\/strong\u003e for each calculated item:\n    \u003cul\u003e\n      \u003cli\u003eProduct record in \u003cstrong\u003ecustom_objects.products_1\u003c\/strong\u003e using the \u003cstrong\u003eLeadConnector API\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eCorresponding price book entry in \u003cstrong\u003ecustom_objects.price_book_entry\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003eContinues until all filtered items are processed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eKeep \u003cstrong\u003eNPD\u003c\/strong\u003e pricing in sync between your product management spreadsheets and \u003cstrong\u003eGoHighLevel\u003c\/strong\u003e without manual updates.\u003c\/li\u003e\n  \u003cli\u003eApply brand-based margin rules and generate \u003cstrong\u003ebespoke\u003c\/strong\u003e vs \u003cstrong\u003estandard\u003c\/strong\u003e pricing automatically.\u003c\/li\u003e\n  \u003cli\u003eUse n8n as an integration layer for SaaS operators who want consistent product\/price publishing to GoHighLevel custom objects.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e to accept Google Sheets IDs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 credentials for both the NPD sheet and the margin sheet.\u003c\/li\u003e\n  \u003cli\u003eNodes include: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e, and \u003cstrong\u003ehttp request\u003c\/strong\u003e (plus a sticky note).\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eLeadConnector\u003c\/strong\u003e via HTTP Request with:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eAuthorization\u003c\/strong\u003e: \u003ccode\u003eBearer YOUR_GHL_API_TOKEN\u003c\/code\u003e\n\u003c\/li\u003e\n      \u003cli\u003eReplaces \u003ccode\u003eYOUR_GHL_LOCATION_ID\u003c\/code\u003e in each request body.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950283940019,"sku":"N8N-19119","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mSqkYrACYY9CkvDRkC8CR_354FUTXS.png?v=1788514378","url":"https:\/\/buyflowscripts.com\/products\/sync-npd-product-pricing-from-google-sheets-to-gohighlevel","provider":"N8N Commerce","version":"1.0","type":"link"}