Automated Trustpilot Review Scraping and Analysis
detail.loadingPreview
Effortlessly scrape and analyze customer reviews from Trustpilot to gain valuable insights into customer sentiment and feedback. Automatically categorize and store this data for strategic business decisions.
About This Workflow
This n8n workflow automates the process of gathering customer feedback from Trustpilot. It begins with a manual trigger and allows you to specify the Trustpilot company URL. An AI agent, powered by Langchain and utilizing Bright Data's MCP tool, then scrapes the latest 5 reviews. The agent intelligently analyzes each review, extracting key information such as the reviewer, date, rating, sentiment (positive, neutral, negative), main issue, and the full review text. The output is a structured JSON array, which is then processed to split each review into individual records. Finally, this valuable customer data is seamlessly appended to a Google Sheet for easy access and further analysis.
Key Features
- Automated Review Scraping: Efficiently collect recent reviews from any Trustpilot company page.
- AI-Powered Sentiment Analysis: Automatically determine the sentiment (positive, neutral, negative) of each review.
- Intelligent Data Extraction: Extracts crucial review components like reviewer, date, rating, and main issues.
- Seamless Google Sheets Integration: Automatically saves scraped and analyzed data to your Google Sheets for easy reporting.
- Configurable Review Count: Easily adjust the number of reviews to scrape.
How To Use
- Trigger the Workflow: Manually start the workflow by clicking the "Execute workflow" button in n8n.
- Set Company URL: In the "Set Trustpilot company URL" node, replace the placeholder
https://www.trustpilot.com/review/hubspot.comwith the actual Trustpilot URL of the company you wish to analyze. - Configure AI Agent: Review the
textparameter in the "Agent : Fetch and analyze reviews" node. Adjustmax_itemsto control the number of reviews scraped. Ensure thescrape_as_markdowntool parameters correctly reference the provided URL. - Connect Google Sheets: In the "Save Reviews to Google Sheets" node, ensure your Google Sheets credentials are correctly set up. Verify the
documentIdandsheetNamepoint to your desired Google Sheet where the data will be stored. - Run and Analyze: Execute the workflow and check your Google Sheet for the scraped and analyzed review data.
Apps Used
Workflow JSON
{
"id": "0d01f590-6e91-4865-80e3-a4c6f85460fa",
"name": "Automated Trustpilot Review Scraping and Analysis",
"nodes": 13,
"category": "Marketing",
"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: 0d01f590-6e91...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.