What This Workflow Does
This automation solves the critical problem of manually monitoring TrustPilot reviews for SaaS products. Instead of spending hours each week checking review sites, this workflow automatically extracts customer feedback, analyzes sentiment using AI, and delivers structured insights to your team.
The system bypasses anti-bot protections using Bright Data's Web Unlocker, converts messy markdown content into clean text, extracts key information like product ratings and reviewer sentiment with OpenAI's GPT-4, and pushes everything to Google Sheets for easy team access. It also saves raw data locally and can trigger webhook alerts for immediate attention to negative reviews.
How It Works
Step 1: Data Extraction
The workflow starts by accessing TrustPilot product pages through Bright Data's Web Unlocker, which handles anti-scraping protections and CAPTCHAs. This ensures reliable access to review data without getting blocked.
Step 2: Content Processing
Raw markdown content from the reviews is cleaned and converted to plain text using a basic LLM chain. This prepares the unstructured data for accurate analysis by removing formatting noise while preserving the review's meaning.
Step 3: AI-Powered Analysis
OpenAI's Information Extractor node processes each review to identify product names, review dates, star ratings, and sentiment. The system then generates concise summaries of overall trends and common themes across multiple reviews.
Step 4: Data Aggregation & Delivery
Individual review records are merged into a structured dataset, then delivered to three destinations simultaneously: Google Sheets for team collaboration, local disk for backup, and optional webhook notifications for real-time alerts.
Pro tip: Schedule this workflow to run daily or weekly to maintain a constantly updated review dashboard without manual intervention.
Who This Is For
This automation is ideal for SaaS companies, product managers, customer experience teams, and marketing professionals who need systematic review monitoring. Specifically designed for:
- Product teams tracking feature requests and pain points
- Customer support managers identifying urgent issues
- Marketing departments collecting testimonials and monitoring brand perception
- Founders and executives needing aggregated customer sentiment insights
- Data analysts benchmarking against competitors
What You'll Need
- A Bright Data account with Web Unlocker access (for bypassing anti-bot protections)
- An OpenAI API key with GPT-4 access (for sentiment analysis and summarization)
- Google Sheets credentials configured in n8n (for data export)
- A running n8n instance (cloud or self-hosted)
- The TrustPilot URLs for products you want to monitor
Quick Setup Guide
- Download and import the template JSON file into your n8n instance
- Configure Bright Data credentials using Header Authentication with your Web Unlocker token
- Set up OpenAI credentials with your API key in the AI nodes
- Connect Google Sheets by authorizing access and specifying your target spreadsheet
- Update the target URLs in the "Set URL" node to point to your TrustPilot product pages
- Test the workflow with a manual trigger to ensure all connections work properly
- Schedule execution based on your monitoring needs (daily, weekly, etc.)
Pro tip: Start by monitoring just one product to verify the data quality before scaling to multiple products or competitors.
Key Benefits
Save 10+ hours weekly previously spent manually checking and analyzing reviews across multiple products and competitors.
Respond 5x faster to negative feedback with immediate alerts, potentially recovering customer relationships before they churn.
Identify trends early with AI-powered sentiment analysis that spots emerging issues before they become widespread problems.
Centralize insights in Google Sheets where your entire team can access, filter, and visualize customer feedback data.
Benchmark performance against competitors by tracking their review trends alongside your own.