Trustpilot Review Scraper & Sentiment Analyzer with Data Visualization

Picture this: Your customers are leaving reviews on Trustpilot right now. Some are praising your service, others might be pointing out issues you could fix immediately. But you only check once a week, maybe less. By the time you see a negative review, the damage is done, and the opportunity to engage is lost.

What if you could automatically capture every single review the moment it goes live, extract all the important details, analyze the sentiment, and get a neat summary delivered straight to your inbox? That's exactly what this powerful N8N workflow does, and today we're going to build it together.

Prerequisites: What You'll Need to Get Started

Before diving into the workflow magic, make sure you have these essential components ready:

• N8N Platform: Either self-hosted or N8N cloud account
• OpenAI API: For intelligent data extraction from review HTML
• Google Gemini API: Powers the sentiment analysis engine
• Google Sheets API: Stores your review data in organized spreadsheets
• Gmail OAuth2: Sends automated email reports with charts
• Trustpilot Company Page: Your business must be listed on Trustpilot

The beauty of this setup is that once configured, it runs completely hands-free. No manual checking, no missed reviews, no forgotten follow-ups.

Key Components: The Workflow Arsenal

This workflow uses 15 specialized N8N nodes, each playing a crucial role:

• HTTP Request nodes: Fetch Trustpilot pages and individual reviews
• HTML Extract nodes: Pull specific data using CSS selectors
• Information Extractor: AI-powered data extraction
• Sentiment Analysis node: Categorizes review emotions
• Google Sheets integration: Data storage with deduplication
• QuickChart generator: Creates visual sentiment reports
• Schedule Trigger: Automates the entire process

Step 1: Set Up Your Review Scraping Foundation

Start with the core scraping mechanism. The workflow begins with a simple parameter setup where you define your company's Trustpilot URL and how many pages to scan.

The HTTP Request node then visits your Trustpilot page, sorts reviews by recency (because fresh feedback matters most), and implements smart pagination. Here's the clever part: it includes a 5-second delay between requests to respect Trustpilot's servers and avoid getting blocked.

img_1.png

"The workflow respects rate limits with 5-second intervals between requests, ensuring stable, long-term operation without triggering anti-bot measures."

Step 2: Extract and Process Individual Reviews

Once the main pages are scraped, the HTML Extract node pulls out individual review URLs using CSS selectors. Think of this as creating a list of specific review pages to visit. The Split Out node then separates each URL for individual processing.

A Limit node caps the processing at 20 reviews per run, keeping things manageable and preventing timeouts. Each review URL gets fetched individually, and another HTML Extract node pulls the complete review article content.

img_2.png

This two-stage approach ensures you get complete, detailed information rather than just summary snippets.

Step 3: Transform HTML into Structured Data

Here's where the magic happens. The Information Extractor node, powered by OpenAI's GPT-4.1-mini model, takes messy HTML and converts it into clean, structured data. It extracts seven specific pieces of information from each review:

• Reviewer's name
• Star rating (1-5 scale)
• Review date in YYYY-MM-DD format
• Review title
• Complete review text
• Total number of reviews by that user
• User's country (two-character code)

img_3.png

The AI is specifically instructed to extract only what's present and not change or interpret anything. This ensures data accuracy and consistency.

Step 4: Analyze Sentiment and Store Everything

With structured data in hand, Google Gemini takes over for sentiment analysis. It categorizes each review as Positive, Neutral, or Negative using natural language processing. This isn't just keyword matching but true understanding of context and emotion.

img_4.png

All this valuable data flows into a Google Sheets document with intelligent deduplication. The system uses the review URL as a unique identifier, so you never get duplicate entries even if you run the workflow multiple times.

Step 5: Generate Automated Intelligence Reports

The second part of this workflow runs on a schedule. It reads your accumulated review data, counts sentiment distributions, and creates a visual pie chart using QuickChart. This chart gets automatically emailed to you with a professional summary.

img_5.png

Imagine opening your email every morning to find a beautiful chart showing your customer sentiment trends, complete with all the raw data stored and organized in your Google Sheet.

Real-World Benefits and Use Cases

This workflow solves multiple business challenges simultaneously:

• Immediate Alert System: Catch negative reviews within hours instead of weeks
• Competitive Intelligence: Adapt the workflow to monitor competitors' reviews
• Trend Analysis: Spot patterns in customer feedback over time
• Team Coordination: Ensure everyone sees the same data at the same time
• Response Strategy: Plan your review responses based on sentiment analysis

Small businesses use this to stay connected with customer feedback without dedicating staff hours to manual monitoring. Larger companies deploy it across multiple brand properties, creating a comprehensive reputation management system.

The workflow is modular and extensible. Want to add Slack notifications? Add a Slack node. Need to store data in a different format? Swap the Google Sheets node for a database connection. Want to analyze review images? Add image processing capabilities.

Your Review Monitoring Future Starts Now

Customer feedback drives business success, but only if you can capture, understand, and act on it quickly. This N8N workflow transforms Trustpilot review monitoring from a manual chore into an intelligent, automated system that works 24/7.

You get complete visibility into what customers are saying, when they're saying it, and how they feel about your business. More importantly, you get this information consistently and reliably, formatted exactly how you need it.

The next time a customer leaves a review, you'll know about it faster than your competitors know about theirs. That's the competitive advantage of automation done right.

Ready to never miss another customer review? This workflow is your starting point for comprehensive, automated reputation management that scales with your business.