{"product_id":"n8n-fetch-boltpatternhq-vehicle-directory-json-to-google-sheets","title":"n8n Fetch BoltPatternHQ Vehicle Directory JSON to Google Sheets","description":"\u003ch3\u003eFetch BoltPatternHQ Vehicle Directory JSON and load it into your workflow\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow downloads the public \u003cstrong\u003eBoltPatternHQ\u003c\/strong\u003e vehicle directory data (JSON) from \u003cem\u003eBoltPatternHQ - The Automotive Fitment Database\u003c\/em\u003e—so you can inspect it and immediately use it in your own automations (including Google Sheets).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManual trigger:\u003c\/strong\u003e You start it by executing the workflow manually in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP request to BoltPatternHQ:\u003c\/strong\u003e The workflow sends an \u003cstrong\u003eHTTP request\u003c\/strong\u003e to BoltPatternHQ’s public endpoint: \u003ccode\u003ehttps:\/\/boltpatternhq.com\/static\/js\/search_index.json\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns downloaded JSON:\u003c\/strong\u003e The full vehicle directory JSON is returned in the workflow output, making it easy to review and pass into downstream steps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNo API keys required:\u003c\/strong\u003e Because the dataset is publicly accessible, you don’t need authentication headers or API credentials.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCatalog enrichment for auto parts e-commerce:\u003c\/strong\u003e Pull public vehicle\/fitment reference data to support compatibility lookups and merchandising workflows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineering:\u003c\/strong\u003e Use the fetched JSON as test input for parsers, transformers, or import routines you’re building in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePopulate Google Sheets:\u003c\/strong\u003e Export or reshape the vehicle directory data for reporting, auditing, or operational tracking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eData pipeline prototyping:\u003c\/strong\u003e Quickly validate connectivity to \u003cstrong\u003eboltpatternhq.com\u003c\/strong\u003e and experiment without setting up any API integration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/tech stack:\u003c\/strong\u003e Manual Trigger, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, Set, Item Lists, Sticky Note, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrimary integration:\u003c\/strong\u003e BoltPatternHQ public JSON endpoint (\u003ccode\u003esearch_index.json\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e Ensure your n8n instance can reach \u003ccode\u003ehttps:\/\/boltpatternhq.com\/static\/js\/search_index.json\u003c\/code\u003e (network\/proxy\/firewall settings as needed).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional maintenance:\u003c\/strong\u003e If BoltPatternHQ changes the endpoint or dataset path, update the request URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938306810035,"sku":"N8N-18930","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kC1un13G8VvgPHWf1ZARQ_Llt83NTK.png?v=1788341656","url":"https:\/\/buyflowscripts.com\/products\/n8n-fetch-boltpatternhq-vehicle-directory-json-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}