n8n Fetch BoltPatternHQ Vehicle Directory JSON to Google Sheets

Fetch BoltPatternHQ Vehicle Directory JSON and load it into your workflow

This n8n workflow downloads the public BoltPatternHQ vehicle directory data (JSON) from BoltPatternHQ - The Automotive Fitment Database—so you can inspect it and immediately use it in your own automations (including Google Sheets).

What this workflow does

• Manual trigger: You start it by executing the workflow manually in n8n.
• HTTP request to BoltPatternHQ: The workflow sends an HTTP request to BoltPatternHQ’s public endpoint: https://boltpatternhq.com/static/js/search_index.json.
• Returns downloaded JSON: The full vehicle directory JSON is returned in the workflow output, making it easy to review and pass into downstream steps.
• No API keys required: Because the dataset is publicly accessible, you don’t need authentication headers or API credentials.

Use cases

• Catalog enrichment for auto parts e-commerce: Pull public vehicle/fitment reference data to support compatibility lookups and merchandising workflows.
• Automation engineering: Use the fetched JSON as test input for parsers, transformers, or import routines you’re building in n8n.
• Populate Google Sheets: Export or reshape the vehicle directory data for reporting, auditing, or operational tracking.
• Data pipeline prototyping: Quickly validate connectivity to boltpatternhq.com and experiment without setting up any API integration.

Technical details

• Nodes/tech stack: Manual Trigger, HTTP Request, Set, Item Lists, Sticky Note, Google Sheets.
• Primary integration: BoltPatternHQ public JSON endpoint (search_index.json).
• Setup requirement: Ensure your n8n instance can reach https://boltpatternhq.com/static/js/search_index.json (network/proxy/firewall settings as needed).
• Optional maintenance: If BoltPatternHQ changes the endpoint or dataset path, update the request URL.