Analyze Trustpilot Reviews with Bright Data and OpenAI

Analyze Review Site Sentiment ✨ Built in n8n | AI-Powered | No-Code Automation 🚀 Workflow Overview This workflow automates the process of retrieving, analyzing, summarizing, and saving customer reviews from any Trustpilot company page. It enables you to extract key insights from real users without manual effort or coding. 🛠️ Tools Used: n8n (No-code automation builder) Bright Data MCP (Mobile proxy scraper) OpenAI (for AI-powered reasoning and sentiment analysis) Google Sheets (for storing the results) 🧩 Workflow Sections 🔹 SECTION 1: 🟢 Start & Input Company URL 🧩 Nodes: 🔘 Manual Start 🏢 Set Trustpilot Company URL 🎯 Description: This section allows the user to trigger the workflow manually and provide a specific Trustpilot company profile URL as input. 📌 Key Benefits: Simple to use — just paste the company URL Reusable for any business No backend modifications required to target a new company 🤖 SECTION 2: 🧠 AI Agent — Scrape, Analyze & Summarize 🧩 Nodes: 🤖 Agent: Fetch and Analyze Reviews 🧠 Chat Model (AI Reasoning) 🌐 Bright Data MCP Scraper (executeTool) 🧾 JSON Review Formatter (Output Parser) 🎯 Description: This is the intelligence core of the workflow. It uses the AI agent and Bright Data proxy tool to: Access the Trustpilot page and scrape the 5 most recent customer reviews Analyze each review for sentiment (positive, neutral, or negative) Identify recurring topics or issues mentioned in reviews Generate a brief summary representing the general customer sentiment 📌 Key Benefits: No scraping scripts required Intelligent insight extraction Works reliably using real mobile IPs (bypasses protection) 📊 SECTION 3: 🔍 Split Reviews & 📥 Save to Google Sheets 🧩 Nodes: 🔍 Splits Reviews into Separate Objects 📄 Save Reviews to Google Sheets 🎯 Description: This section structures and stores the data. After the AI returns reviews in array format, the function node splits them into separate objects. Each review is then stored as an individual row in Google Sheets. 📌 Key Benefits: Clean, row-by-row storage for easy review Compatible with reporting and dashboard tools Maintains historical record of customer feedback ✅ Workflow Summary Section What It Does 1️⃣ Input Allows user to manually trigger and set company URL 2️⃣ AI Agent Scrapes, analyzes, identifies themes, and summarizes data 3️⃣ Output Splits and saves review data to a structured spreadsheet