Scrape Trustpilot Reviews and Analyze Sentiment with OpenAI and DeepSeek
detail.loadingPreview
This workflow automates scraping Trustpilot reviews for a specific company. It uses the Information Extractor node with DeepSeek to parse review details and OpenAI to analyze sentiment, saving valuable business intelligence.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This n8n workflow is designed to automate the process of gathering and analyzing customer feedback from Trustpilot. It begins by setting up parameters for the company to scrape and the maximum number of pages to fetch reviews from.
The Get reviews HTTP Request node retrieves review data from Trustpilot. The Extract node then parses the HTML content to extract individual review links. These links are subsequently split using the Split Out node for individual processing.
The core of the analysis happens with the Information Extractor node, powered by DeepSeek. It meticulously extracts structured data from each review, including author, rating, date, title, text, number of reviews, and country. Simultaneously, the Get Google Sheets node checks if a review has already been processed by looking for a matching ID in your Google Sheet, preventing duplicates.
An If node determines if a review needs further processing based on whether it's already in the Google Sheet. If not, the extracted review details are sent to an analysis step, likely involving sentiment analysis (though not explicitly detailed in the provided snippet for sentiment analysis itself, it's implied by the workflow title and the Sticky Note3). Finally, the workflow aims to consolidate this analyzed data, potentially for reporting or further business intelligence actions.
This workflow solves the problem of manual data collection and analysis of customer reviews, providing a scalable and efficient way to gain insights into customer satisfaction and identify areas for improvement.
Key Features
- Automates scraping of Trustpilot reviews for a specified company.
- Uses DeepSeek via the Information Extractor node for robust structured data extraction from HTML.
- Integrates with Google Sheets to check for existing reviews and prevent data duplication.
- Facilitates sentiment analysis of reviews (implied by workflow title and sticky notes).
- Configurable scraping parameters for company ID and maximum pages.
How To Use
- Configure
Set Parametersnode: Updatecompany_idwith the target company's identifier on Trustpilot andmax_pagewith the desired number of pages to scrape. - Set up
Get reviewsnode: Ensure thehttpRequestis correctly configured to fetch reviews from the specified company URL. - Connect
Extractnode: Verify the CSS selectors in theExtractnode are accurate for capturing review links. - Configure
Get Google Sheetsnode: Link your Google Sheet and specify thesheetNameanddocumentId. Ensure the column names in the workflow match your sheet's headers. - Review
Information Extractornode: Confirm thesystemPromptTemplateandattributesare correctly defined for DeepSeek to extract the desired review details. - Adjust
Ifnode: Ensure the condition correctly checks for the existence of a review ID in your Google Sheet to avoid redundant processing. - Integrate Sentiment Analysis: If sentiment analysis is not directly configured, add nodes (e.g., OpenAI text analysis) after the
Ifnode's 'true' branch to process and analyze the sentiment of new reviews.
Apps Used
Workflow JSON
{
"id": "f02c4bb0-5428-42bc-aacc-6faab95c2be3",
"name": "Scrape Trustpilot Reviews and Analyze Sentiment with OpenAI and DeepSeek",
"nodes": 0,
"category": "AI Research, RAG, and Data Analysis",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: f02c4bb0-5428...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Hacker News 'Who Is Hiring?' Jobs AI Parser
Scrape Hacker News 'Ask HN: Who is hiring?' posts, extract job details using an AI model, and structure them. This workflow automates the tedious task of finding and organizing job opportunities from a popular tech community.
Scrape and Summarize Latest Paul Graham Essays with n8n
Automate the scraping of Paul Graham's essays using n8n's HTTP Request and HTML nodes. Then, leverage Langchain nodes for summarization.
Build a RAG Chatbot for Movie Recommendations with Qdrant and OpenAI
Develop an AI-powered RAG chatbot for movie recommendations. This workflow uses GitHub for data, OpenAI for embeddings and chat, and Qdrant as a vector store.