Fetch BoltPatternHQ vehicle directory data and append to Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Item Lists (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 5 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls boltpatternhq.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch BoltPatternHQ Data (HTTP Request): calls boltpatternhq.com
- Limit to Top (Item Lists): reshapes item lists (legacy Item Lists node)
- Format Vehicle Data (Edit Fields (Set)): sets 2 fields: VehicleName, ProfileURL
- Append to Google Sheets (Google Sheets): append
Services it uses
HTTP calls to: boltpatternhq.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Limit to Top 10: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Limit to Top 10 | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (5)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Item Lists
n8n-nodes-base.itemLists - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow downloads public vehicle directory JSON from BoltPatternHQ - The Automotive Fitment Database for use in your own processing. How it works 1. Starts when you manually execute the workflow in n8n. 2. Sends an HTTP request to…