Extract Amazon product data to Sheets with Olostep API

Olostep Amazon Products Scraper

This n8n template automates Amazon product scraping using the Olostep API. Simply enter a search query, and the workflow scrapes multiple Amazon search pages to extract product titles and URLs. Results are cleaned, normalized, and saved into a Google Sheet or Data Table.

Who’s it for - E-commerce analysts researching competitors and pricing - Product sourcing teams - Dropshippers and Amazon sellers - Automation builders who want quick product lists without manual scraping - Growth hackers collecting product data at scale

How it works / What it does 1. Form Trigger - User enters a search query (e.g., “wireless bluetooth headphones”). - The query is used to build the Amazon search URL.

2. Pagination Setup - A list of page numbers (1–10) is generated automatically. - Each number loads the corresponding Amazon search results page.

3. Scrape Amazon with Olostep - For each page, Olostep scrapes Amazon search results. - Olostep’s LLM extraction returns: - title — product title - url — product link

4. Parse & Split Results - The JSON output is decoded and turned into individual product items.

5. URL Normalization - If the product URL is relative, it is automatically converted into a full Amazon URL.