Amazon product search scraper with BrightData, GPT-4, and Google Sheets

This workflow automates web scraping of Amazon search result pages by retrieving raw HTML, cleaning it to retain only the relevant product elements, and then using an LLM to extract structured product data (name, description, rating, reviews, and price), before saving the results back to Google Sheets.

It integrates Google Sheets to supply and collect URLs, BrightData to fetch page HTML, a custom n8n Function node to sanitize the HTML, LangChain (OpenRouter GPT-4) to parse product details, and Google Sheets again to store the output.

 URL to scape

.

 Result

Who Needs Amazon Search Result Scraping?

This scraping workflow is ideal for teams and businesses that need to monitor Amazon product listings at scale:

- E-commerce Analysts – Track competitor pricing, ratings, and inventory trends. - Market Researchers – Collect data on product popularity and reviews for market analysis. - Data Teams – Automate ingestion of product metadata into BI pipelines or data lakes. - Affiliate Marketers – Keep affiliate catalogs up to date with latest product details and prices.