AutomationMart
Home/Browse/Amazon product search scraper with BrightData, GPT-4, and Google Sheets
n8n

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

n8nn8n10 modulesv1.0
chainLlmcodegoogleSheetshttpRequestlmChatOpenRoutermanualTriggeroutputParserStructuredsplitInBatchessplitOut

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 G

At a glance

Amazon product search scraper with BrightData, GPT-4, and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects chainLlm, code, googleSheets, httpRequest. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
chainLlm, code, googleSheets, httpRequest, lmChatOpenRouter, manualTrigger
Modules
10
Price
Free
Version
v1.0
Amazon product search scraper with BrightData, GPT-4, and Google Sheets workflow diagram

About this workflow

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. If you need reliable, structured data from Amazon search results delivered directly into your spreadsheets, this workflow saves you hours of manual copy-and-paste. Why Use This Workflow? - End-to-End Automation – From URL list to clean JSON output in Sheets. - Robust HTML Cleaning – Strips scripts, styles, unwanted tags, and noise. - Accurate Structured Parsing – Leverages GPT-4 via LangChain for reliable extraction. - Scalable & Repeatable – Processes thousands of URLs in batches. Step-by-Step: How This Workflow Scrapes Amazon 1. Get URLs from Google Sheets – Reads a list of search result URLs. 2. Loop Over Items – Iterates through each URL in controlled batches. 3. Fetch Raw HTML – Uses BrightData’s Web Unlocker proxy to retrieve the page. 4. Clean HTML – A Function node removes doctype, scripts, styles, head, comments, classes, and non-whitelisted tags, collapsing extra whitespace. 5. Extract with LLM – Passes cleaned HTML into LangChain → GPT-4 to output JSON for each product: - name, description, rating, reviews, price 6. Save Results – Appends the JSON fields as columns back into a “results” sheet in Google Sheets. Customization: Tailor to Your Needs - Adaptable Sites – This workflow can be adapted to any e-commerce or other website, for example Walmart or eBay. - Whitelist Tags – Modify the allowedTags array in the Code node to keep additional HTML elements. - Schema Changes – Update the Structured Output Parser schema to include more fields (e.g., availability, SKU). - Alternate Data Sink – Instead of Sheets, route output to a database, CSV file, or webhook. 🔑 Prerequisites - Google Sheets Credentials – OAuth credentials configured in n8n. - BrightData API token – Stored in n8n credentials as BRIGHTDATATOKEN. - OpenRouter API Key – Configured for the LangChain node to call GPT-4. - n8n Instance – Self-hosted or cloud with sufficient quota for HTTP requests and LLM calls. 🚀 Installation & Setup - Configure Credentials 1. In n8n, set up Google Sheets OAuth under “Credentials.” 2. Add BrightData token as a new HTTP Request credential. 3. Create an OpenRouter API key credential for the LangChain node. - Import the Workflow 1. Copy the JSON workflow into n8n’s “Import” dialog. 2. Map your Google Sheet IDs and GIDs to the {{WEBSHEETID}}, {{TRACKSHEETGID}}, and {{RESULTSSHEETGID}} placeholders. 3. Ensure the BRIGHTDATATOKEN credential is selected on the HTTP Request node. - Test & Run 1. Add a few Amazon search URLs to your “track” sheet. 2. Execute the workflow and verify product data appears in your “results” sheet. 3. Tweak batch size or parser schema as needed. ⚠ Important - API Rate Limits – Monitor your BrightData and OpenRouter usage to avoid throttling. - Amazon’s Terms – Ensure your scraping complies with Amazon’s policies and legal requirements. Summary This workflow delivers a fully automated, scalable solution to extract structured product data from Amazon search pages directly into Google Sheets—streamlining your competitive analysis and data collection. 🚀 . --- Phil | Inforeole | Linkedin 🇫🇷 Contactez nous pour automatiser vos processus

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

Analyze brand visibility in AI SERPs with SE Ranking and OpenAI GPT-4.1 mini

This workflow automates brand intelligence analysis across AI-powered search results by combining SE Ranking’s AI Search data with structured processing in n8n. It retrieves real AI-generated prompts, answers, and cited sources where a brand appears, then normalizes and consolidates this data into a clean, structured format. The workflow eliminates manual review of AI SERPs and makes it easy to understand how AI search engines describe, reference, and position a brand. Who this is for

Free

Chat with your email history using Telegram, Mistral and Pgvector for RAG

Who is this for? Everyone! Did you dream of asking an AI "what hotel did I stay in for holidays last summer?" or "what were my marks last semester like?". Dream no more, as vector similarity searches and this workflow are the foundations to make it possible (as long as the information appears in your e-mails 😅). 100% Local and Open Source! This workflow is designed to use locally-hosted open source. Ollama as LLM provider, nomic-embed-text as the embeddings model, and pgvector as the vector data

Free

AI-powered Telegram bot for data extraction with Bright Data MCP

AI Agent Template with Bright Data MCP Tool Integration This template enables natural-language-driven automation using Bright Data MCP tools. It extracts all available tools from MCP, processes the user’s query through an AI agent, then dynamically selects and executes the appropriate tool. --- ❓ Problem It Solves Traditional automation often requires users to understand APIs, interfaces, or scripts to perform backend tasks. The Bright Data MCP integration solves this by allowing natural languag

Free

Summarize the new documents from Google Drive and save summary in Google Sheet

This workflow is created by AI developers at WeblineIndia. It streamlines the process of managing content by automatically identifying and fetching the most recently added Google Doc file from your Google Drive. It extracts the content of the document for processing and leverages an AI model to generate a concise and meaningful summary of the extracted text. The summarized content is then stored in a designated Google Sheet, alongside relevant details like the document name and the date it was a

Free

Automate LinkedIn profile search & cold email outreach with OpenAI and Hunter

Problem 🚨 LinkedIn search is BROKEN. I waste hours on LinkedIn manually filtering profiles, reading summaries, hoping they’d reply—tedious, frustrating, inefficient. I wish LinkedIn had built an agent that would get me to the right profile with one click! If only I could just type: "Product managers working on YouTube Shorts' generative AI features." and seconds later, have LinkedIn URLs, names, emails, and full context about them. Introducing LinkGPT, a LinkedIn Agent, an automated agentic wor

Free

AI-powered WhatsApp chatbot for text, voice, images, and PDF with RAG

Who is this for? This template is designed for internal support teams, product specialists, and knowledge managers in technology companies who want to automate ingestion of product documentation and enable AI-driven, retrieval-augmented question answering via WhatsApp. What problem is this workflow solving? Support agents often spend too much time manually searching through lengthy documentation, leading to inconsistent or delayed answers. This solution automates importing, chunking, an

Free

Track HDFC credit card transactions with Google Sheets and Telegram notifications

Problem This Solves Managing credit card expenses can be tricky, especially when you want to stay transparent and keep your spouse in the loop. Most banks don't offer real-time notification sharing with family members, and manually updating expenses takes time and effort. This n8n workflow automates the entire process: tracking your HDFC credit card usage, logging it in Google Sheets, and sending an instant Telegram notification to your spouse. 👥 Who This Template Is For Couples who want shared

Free

Real-time PulsePoint emergency alerts to iMessage with AI summaries

Emergency Alerts Reporter to iMessage This n8n template fetches real-time emergency incident alerts from PulsePoint for a specific agency and delivers them directly to any phone number via iMessage using the Blooio API. It's designed to keep users informed with clear, AI-summarized reports of emergency activity near them—automatically and reliably. Use cases are powerful and immediate: - Get real-time fire/medical alerts for your neighborhood. - Use it for family, local safety groups, or even

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