Description
Automate the full pipeline of scraping Trustpilot reviews, extracting structured review details, running sentiment analysis with OpenAI, and storing results in Google Sheets. Perfect for reputation monitoring, competitor research, and voice-of-customer programs.
Ideal for customer success teams, data analysts, and product managers looking to analyze public feedback efficiently.
🧠 How It Works:
✅ 🌐 Scrape reviews from Trustpilot using HTTP requests ✅ 🔁 Paginate through multiple pages (customizable max page count) ✅ 🧩 Parse HTML with CSS selectors to extract review links ✅ 📥 Fetch each review’s detailed content using DeepSeek or LLM-based extractor ✅ 🧑💻 Extract structured fields: Author, Rating, Date, Title, Text, Total Reviews, Country ✅ 📊 Run OpenAI-powered sentiment analysis to classify reviews ✅ 📈 Store enriched reviews with sentiment results in Google Sheets
🔍 It Automates:
✅ Real-time scraping of Trustpilot reviews for any company ✅ Extraction of meaningful review fields for analysis ✅ Sentiment detection (Positive, Neutral, Negative) using LLMs ✅ Confidence scoring for sentiment predictions ✅ Seamless data storage and updating in Google Sheets
💡 Why Choose This Workflow:
✅ Avoid manual review scraping or browser extensions ✅ Analyze customer sentiment at scale across multiple reviews ✅ Generate structured review datasets for dashboards or reports ✅ Track customer experience trends over time ✅ Adaptable to different domains or review platforms with minor tweaks
👤 Who Is This For:
✅ Product managers monitoring customer feedback ✅ CX and Support teams tracking sentiment shifts ✅ Analysts running NPS or voice-of-customer analysis ✅ Marketing teams benchmarking competitors ✅ Founders who care about public reputation insights
🔗 Integrations:
✅ Trustpilot (web-based scraping, no API required) ✅ OpenAI (sentiment classification + text structuring) ✅ Google Sheets (for storing final structured output) ✅ Optional: DeepSeek / Claude for advanced text parsing
🔧 Setup Instructions:
🛠️ Set Max Pages: In the pagination logic, define how many pages of reviews to scrape
🔐 Add Your API Keys: Replace OpenAI and Google Sheets credentials with your own
📋 Customize CSS Selectors: Adjust review selectors based on Trustpilot structure updates
🎛️ Tune LLM Prompt: Refine your extraction prompt to match the fields you care about
🧪 Test with Multiple Companies: Try switching company IDs to validate the scraper on various domains
🧠 Sentiment Intelligence — Powered by Trustpilot, OpenAI & Google Sheets Get deep insights into public opinion by transforming raw reviews into meaningful data. From customer praise to constructive criticism, this workflow helps you act on what truly matters.
Link : [https://lovable.dev/projects/cf97eb64-d6ef-4444-9984-8a670e5d4f96]
