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
Form Trigger
User enters a search query (e.g., “wireless bluetooth headphones”).
The query is used to build the Amazon search URL.

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

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

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

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

Conditional Check (IF node)
Ensures only valid product URLs are stored.
Helps avoid scraping Amazon navigation links or invalid items.

Insert into Sheet / Data Table
Each valid product is saved in:
title
url

Automatic Looping & Rate Management
A wait step ensures API rate limits are respected while scraping multiple pages.

This workflow gives you a complete, reliable Amazon scraper with no browser automation and no manual copy/paste — everything runs through the Olostep API and n8n.

How to set up
Import this template into your n8n account.
Add your Olostep API key.
Connect your Google Sheets or Data Table.
Deploy the form and start scraping with any Amazon search phrase.

Requirements
Olostep API key
Google Sheets or Data Table
n8n cloud or self-hosted instance

How to customize the workflow
Add more product fields (price, rating, number of reviews, seller name, etc.).
Extend pagination range (1–20 or more pages).
Add filtering logic (e.g., ignore sponsored results).
Send scraped results to Notion, Airtable, or a CRM.
Trigger via Telegram bot instead of a form.

👉 This workflow is perfect for e-commerce research, competitive analysis, or building Amazon product datasets with minimal effort.