Amazon Product Data Scraper and AI Analyzer - n8n Workflow

E-commerce Analysts: Professionals needing structured, AI-enhanced competitive data from Amazon listings.
Product Managers: Individuals who require deep market insights and product positioning summaries.
Marketing Agencies: Teams looking to automate the collection and analysis of competitor product listings.
n8n Users: Developers seeking advanced examples of integrating web scraping, multiple LLM calls, and structured output parsing within a complex n8n workflow.

This advanced n8n workflow solves the challenge of turning raw, complex web scraping data into actionable, structured business intelligence. It utilizes the Decodo service to reliably extract detailed information from Amazon product URLs. Crucially, it employs multiple parallel chains of LangChain and OpenAI n8n nodes to perform multi-faceted analysis, including generating product summaries, performing competitive analysis, and mining comprehensive market insights. The entire process, from manual n8n trigger to spreadsheet entry, is fully automated, providing high-quality, normalized data ready for reporting.

The entire process is initiated by the When clicking ‘Execute workflow’ n8n trigger. The first n8n node, Set the Input Fields, defines the specific Amazon URL to be scraped.

1. Scraping: The Decodo Web scrape for Amazon Products n8n node uses the input URL to fetch comprehensive product data, including product details, advertisements, and potentially reviews.


2. Extraction: The output is split into two parallel paths by Extract Product Details and Extract Ads code n8n nodes, ensuring specific data segments are isolated for targeted AI analysis.


3. Parallel AI Analysis (The Core n8n Workflow Logic):

1. Aggregation and Export: The outputs from these three parallel analysis chains are combined using the Merge n8n node. An Aggregate n8n node then prepares the final structured JSON object. The process concludes when the Append or update row in sheet Google Sheets n8n node writes the complete, synthesized product insights to the designated spreadsheet.

To deploy this powerful n8n workflow template, follow these steps:

1. Import the n8n Workflow: Copy the provided JSON code and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Decodo Credential Setup (Community Node): This workflow requires the Decodo community n8n node, typically used on self-hosted instances. Go to 'Credentials', select 'Decodo API', and enter your Decodo API key.


3. OpenAI Credential Setup: Navigate to 'Credentials', add a new credential for 'OpenAI', and input your API key. Ensure all three OpenAI n8n node instances (OpenAI Chat Model, OpenAI Chat Model for Amazon Product Mining, etc.) are linked to this credential.


4. Google Sheets Setup: Configure the Google Sheets n8n node with your required credentials and specify the Document ID and Sheet Name where the final data will be exported.


5. Execution: After linking all credentials and customizing the input URL in the Set the Input Fields n8n node, you can execute the n8n workflow using the manual trigger.

When clicking ‘Execute workflow’ (ManualTrigger n8n trigger): Initiates the entire data processing pipeline for one-time or testing execution.
Set the Input Fields (Set n8n node): Defines the variable product_url containing the target Amazon URL to be scraped.
Decodo Web scrape for Amazon Products (Decodo n8n node): The key scraping component. It takes the URL and uses the specific amazon operation to return rich, structured JSON data from the product page.
Extract Product Details / Extract Ads (Code n8n node): Custom JavaScript code nodes used to precisely pluck the desired data subsets (product details and ad data) from the large Decodo response, preparing them for specialized analysis by the downstream LLM chains.
Product Descriptive Summarizer (ChainLlm n8n node): Uses an OpenAI Chat Model to transform the raw product details into a human-readable, descriptive summary, guided by a system message defining the persona.
Product Insights (InformationExtractor n8n node): This advanced n8n node uses the LangChain framework to perform complex data mining on the extracted ad data, generating metrics like average pricing, duplicate ASIN counts, and detailed product recommendations based on a rigorous JSON schema.
Competitive Analysis (InformationExtractor n8n node): A parallel analysis chain that uses OpenAI to determine the competitive positioning of the product based on its raw details.
Merge (Merge n8n node): Gathers the results from the three parallel AI processes into a single data stream.

• Append or update row in sheet (Google Sheets n8n node): The final action n8n node, configured to write the aggregated output data into the specified Google Sheet, ensuring continuous data logging and analysis.