Analyze Amazon Product Performance with OpenAI and Sheets

## 🚀 Amazon Product Performance Analyzer Workflow Automate product research + scoring using AI, scraping, and Google Sheets. --- ### 🔹 SECTION 1: Trigger & Read Product URLs Nodes Combined: * Start Workflow (Manual Trigger) * Fetch Amazon URLs from Google Sheets 📌 What Happens Here: When you click "Execute workflow", the automation kicks off. It reads a list of Amazon product URLs from a connected Google Sheet — each URL representing a product you want to analyze. 🧠 Why This Is Useful: You don't have to input product links manually every time. Just paste your URLs in the Google Sheet, and this step will automatically fetch them all. Perfect for monitoring dozens (or hundreds) of products. 📋 Fields Expected in Google Sheet: * URL (Amazon product link) * *(Other columns will be auto-filled later)* 🔧 Icons Involved: * ⚡ Trigger * 📄 Google Sheets --- ### 🤖 SECTION 2: AI Agent + Scraper + Parser Node: Amazon Product Analyzer (AI Agent) + Sub-nodes: * OpenAI Chat Model * MCP Client (Bright Data) * Structured Output Parser 📌 What Happens Here: 1. 🔍 The AI Agent passes each product URL to: * 🛰️ The MCP Client, which uses Bright Data's Mobile Carrier Proxy to scrape data safely from Amazon (bypassing detection). * 📊 The data collected includes: * Units sold last month * Current price * Stock availability * Review count * Average rating * Sales rank 2. 💬 Then, the OpenAI Chat Model intelligently evaluates this data and gives a performance rating out of 10, simulating a product analyst's decision-making. 3. 📦 Finally, the Structured Output Parser transforms the AI’s natural language response into clean JSON fields that n8n can write back to your Google Sheet. 🧠 Why This Is Useful: This section automates competitive product research, letting you know which products are worth stocking, promoting, or avoiding — without manually checking every listing. 🛠️ Icons Involved: * 🤖 AI Agent * 🧠 OpenAI Chat * 🌐 MCP Scraper (Bright Data) * 📤 JSON Parser --- ### 📈 SECTION 3: Update Google Sheet with Final Data Node: Update Sheet with Product Insights 📌 What Happens Here: Once scraping and AI evaluation are done, the workflow updates the original Google Sheet with all the new fields: | Column | Description | | ----------------------- | -------------------------------------------------- | | Units Sold | Estimated n