Trustpilot review sentiment analysis with OpenAI & Bright Data to Google Sheets

This workflow automatically scrapes customer reviews from Trustpilot and performs sentiment analysis to extract valuable customer insights. It saves you time by eliminating the need to manually read through reviews and provides structured data on customer feedback, sentiment, and pain points.

Overview

This workflow automatically scrapes the latest customer reviews from any Trustpilot company page and uses AI to analyze each review for sentiment, extract key complaints or praise, and identify recurring customer pain points. It stores all structured review data in Google Sheets for easy analysis and reporting.

Tools Used

- n8n: The automation platform that orchestrates the workflow - Bright Data: For scraping Trustpilot review pages without being blocked - OpenAI: AI agent for intelligent review analysis and sentiment extraction - Google Sheets: For storing structured review data and analysis results

How to Install

1. Import the Workflow: Download the .json file and import it into your n8n instance 2. Configure Bright Data: Add your Bright Data credentials to the MCP Client node 3. Set Up OpenAI: Configure your OpenAI API credentials 4. Configure Google Sheets: Connect your Google Sheets account and set up your review tracking spreadsheet 5. Customize: Enter target Trustpilot company URLs and adjust review analysis parameters

Use Cases