Automated Trustpilot Review Analysis with AI
detail.loadingPreview
Streamline your customer feedback analysis by automatically scraping Trustpilot reviews, extracting key details using DeepSeek, and performing sentiment analysis with OpenAI. Save valuable insights directly to Google Drive.
About This Workflow
This n8n workflow automates the process of gathering and understanding customer feedback from Trustpilot. It begins by setting parameters for the company you want to analyze and the number of pages to scrape. The workflow then fetches reviews from Trustpilot, processes each review using the DeepSeek Information Extractor to pull out author, rating, date, title, text, review count, and country. Following this, it leverages OpenAI to analyze the sentiment of each review. Conditional logic is included to check if reviews have already been processed, preventing duplicates. Finally, the workflow can limit the number of processed reviews and save them to Google Drive for further analysis or reporting.
Key Features
- Automated Web Scraping: Efficiently gather reviews from Trustpilot without manual intervention.
- AI-Powered Data Extraction: Utilize DeepSeek to extract structured information from review text.
- Sentiment Analysis: Gain insights into customer sentiment with OpenAI's advanced language capabilities.
- Duplicate Prevention: Logic to ensure reviews aren't processed multiple times.
- Google Drive Integration: Seamlessly store analyzed review data for easy access and reporting.
How To Use
- Configure Initial Parameters: In the 'Set Parameters' node, define
company_idwith the name of the company on Trustpilot andmax_pageto set the scraping depth. - Set Base URL for DeepSeek: Locate the 'Information Extractor' node and ensure the
base_urlin its configuration is set tohttps://api.deepseek.com/v1. - Define Extraction Schema: Within the 'Information Extractor' node, customize the
attributesto specify exactly which pieces of information you want to extract from each review (e.g., author, rating, date, text). - Connect to OpenAI: Configure the 'OpenAI' node (if used separately for sentiment, or ensure it's integrated within the extractor if applicable) with your API key and desired model for sentiment analysis.
- Set Up Google Drive Output: Configure a node (e.g., 'Google Drive' node) to save the extracted and analyzed data. Ensure you have connected your Google Drive account.
- Test and Deploy: Use the 'Test workflow' trigger to run the workflow and verify that data is being extracted and analyzed correctly. Adjust configurations as needed before activating the workflow for continuous operation.
Apps Used
Workflow JSON
{
"id": "6d8d1139-4293-4f18-9ef6-f61a560e45c1",
"name": "Automated Trustpilot Review Analysis with AI",
"nodes": 20,
"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: 6d8d1139-4293...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
Statistics
Related Workflows
Discover more workflows you might like
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.
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.
Automate LinkedIn Content Promotion for Your Ghost Blog with AI
Effortlessly promote your latest Ghost blog posts on LinkedIn. This workflow leverages AI to generate engaging, professional LinkedIn messages based on your article content and saves them, along with article metadata, directly to a Google Sheet.