Scrape Trustpilot Reviews with DeepSeek, Analyze Sentiment with OpenAI
This workflow automates the collection of customer reviews from Trustpilot and utilizes AI technology to extract key information from the reviews and perform sentiment analysis. By structuring the review data and analyzing sentiment trends, businesses can quickly gain insights into customer feedback, monitor brand reputation, and simultaneously update the results in real-time to Google Sheets. This enhances the efficiency of data collection and analysis, supporting market research, customer service improvement, and decision-making.
Workflow Name
Scrape Trustpilot Reviews with DeepSeek, Analyze Sentiment with OpenAI
Key Features and Highlights
This workflow automatically scrapes customer reviews from the Trustpilot website, leveraging the DeepSeek model to accurately extract review details—including author, rating, date, title, content, user country, and user review count. It then applies OpenAI’s sentiment analysis model to classify the review text into positive, neutral, or negative sentiments. Finally, all structured review data along with sentiment analysis results are synchronized and updated in Google Sheets, enabling automated data collection, analysis, and storage.
Core Problems Addressed
- Efficiently scrape large volumes of customer reviews, eliminating the tedious manual crawling and organizing process
- Precisely extract key review information to ensure data is structured and accurate
- Automatically perform sentiment analysis to help businesses quickly understand customer feedback trends
- Automatically deduplicate and update review data to maintain real-time accuracy and completeness
Application Scenarios
- Monitoring brand and product reputation to capture authentic customer voices promptly
- Market research and competitive analysis to understand user review trends and key feedback points
- Customer service improvement by identifying negative reviews for rapid response and resolution
- Data-driven decision support to assist marketing and product optimization strategies
Main Workflow Steps
- Configure target company name and number of pages to scrape
- Use HTTP requests to paginate and fetch review list links from Trustpilot
- Extract review URLs, process them in batches, and limit the scraping volume
- Check Google Sheets for existing reviews to avoid duplicate scraping
- Scrape the detailed HTML content of each individual review page
- Use the DeepSeek model to extract structured review information
- Perform sentiment analysis on the review text using the OpenAI model
- Update or append the complete review data and sentiment results into the Google Sheets spreadsheet
Involved Systems and Services
- Trustpilot (data source)
- DeepSeek (AI information extraction model)
- OpenAI (sentiment analysis model)
- Google Sheets (data storage and deduplication verification)
- n8n Automation Platform (workflow orchestration)
Target Users and Value
- Market analysts and brand managers: Quickly obtain customer review data and sentiment trends
- Customer service teams: Timely identify negative feedback to improve customer satisfaction
- Product managers and operations staff: Optimize products and services based on authentic review data
- Automation enthusiasts and data engineers: Build efficient review scraping and analysis pipelines to enhance productivity and data quality
By combining powerful AI-driven information extraction and sentiment analysis, this workflow automates the entire process from data scraping and structuring to intelligent analysis, providing enterprises with precise, real-time, and actionable customer review insights.