AutomationMart
Home/Browse/Extract Amazon product data to Sheets with Olostep API
n8n

Extract Amazon product data to Sheets with Olostep API

n8nn8n11 modulesv1.0
NotionAirtableGoogle SheetsTelegram

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 prod

At a glance

Extract Amazon product data to Sheets with Olostep API is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Notion, Airtable, Google Sheets, Telegram. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Notion, Airtable, Google Sheets, Telegram
Modules
11
Price
Free
Version
v1.0
Extract Amazon product data to Sheets with Olostep API workflow diagram

About this workflow

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. 6. Conditional Check (IF node) - Ensures only valid product URLs are stored. - Helps avoid scraping Amazon navigation links or invalid items. 7. Insert into Sheet / Data Table - Each valid product is saved in: - title - url 8. 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 1. Import this template into your n8n account. 2. Add your Olostep API key. 3. Connect your Google Sheets or Data Table. 4. 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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Add Google Sheets rows for new Amazon SES contacts

Make will watch your Amazon SES contacts and add them to your Google Sheets as rows. Here's the [spreadsheet](https://docs.google.com/spreadsheets/d/1FeaALMYAUmUlQssrMVCIyvojkX5V9tpNXgo9rS_9egA/edit?usp=sharing) used in this scenario.

Free

Save new Telegram files to Nextcloud

Every time a new file is posted to your Telegram channel, Make will automatically save that file to a Nextcloud folder you specify.

Free

Create a task with information about a new click from Rebrandly

When a new click in Rebrandly is received, Make searches the Rebrandly link in Google Sheets where the recepients of the links are stored. Then a new task containing all information about the recepient is created in Asana. This scenario is dependent on [this scenario](https://www.integromat.com/en/integration/2953-create-a-link-in-rebrandly-for-each-contact-in-google-sheets-and-send-it-via-gmail).

Free

Generate & schedule social posts with Gemini/OpenAI for X and LinkedIn

LinkedIn Content Machine – AI-Powered Post Generator & Scheduler for X and LinkedIn How it works: This end-to-end workflow automates your personal or brand content strategy by: - 🧠 Using Google Gemini or OpenAI to generate engaging LinkedIn/X content from a title or trending posts. - 🗓️ Posting directly to LinkedIn and X (formerly Twitter). - 📊 Pulling high-performing LinkedIn posts to inspire new ideas. - ✍️ Saving AI-generated drafts to Google Sheets for review. - 🔔 Notifying your

Free

Convert Shopify products into Blog content with DeepSeek and Sheets

( Overview Stop struggling with content creation for your e-commerce store. This workflow acts as your automated AI Content Marketer, instantly transforming your Shopify product details into high-quality, SEO-optimized blog posts. It handles everything from reading product data to writing the article and uploading it directly to your store as a draft. What this workflow does - Fetches Product Data: Automatically pulls product titles and descriptions directly from your Shopify store (configurable

Free

Export Basin submissions to Airtable database

This scenario lets you export submissions from Basin to Airtable. In order for it to work your table has to be the same as [this one](https://airtable.com/shrdYIjW362FMjAVL).

Free

Generate audio documentaries from web articles with ElevenLabs and BrowserAct

Generate audio documentaries from web articles to Telegram with ElevenLabs & BrowserAct This workflow transforms any web article or blog post into a high-production-value audio documentary. It automates the entire production chain—from scraping content and writing an engaging narrative script to generating realistic voiceovers—delivering a listenable MP3 file directly to your Telegram chat. Target Audience Commuters, podcast enthusiasts, content creators, and researchers who prefer listen

Free

Image-based data extraction API using Gemini AI

This n8n workflow provides a ready-to-use API endpoint for extracting structured data from images. It processes an image URL using an AI-powered OCR model and returns the extracted details in a structured JSON format. Use Cases - Document OCR – Extract details from ID cards, invoices, receipts, etc. - Text Extraction from Images – Process screenshots, scanned documents, and photos. - Automated Form Processing – Digitize and capture information from paper forms. - Business Card Data Extracti

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free