Automate Trustpilot Review Data Extraction and Analysis
detail.loadingPreview
Streamline your review management process by automatically extracting and structuring data from Trustpilot. This workflow transforms raw review information into actionable insights, ready for further analysis and integration.
About This Workflow
This n8n workflow is designed to efficiently scrape and process customer reviews from Trustpilot. It begins with a manual trigger, allowing you to initiate the process on demand. The core functionality involves extracting detailed information from each review, including author, rating, title, text, dates, country, review count, and URL. This raw data is then meticulously organized and enriched with contextual information like company ID and formatted dates. Finally, the processed review data is prepared for integration with AI models, leveraging Langchain for document loading, text splitting, and embedding generation, enabling advanced analytics and sentiment analysis.
Key Features
- Automated Review Extraction: Scrapes detailed data points from Trustpilot reviews using CSS selectors.
- Data Structuring & Enrichment: Organizes raw review data into a usable format, adding relevant metadata like company ID and formatted dates.
- AI-Ready Data Preparation: Leverages Langchain nodes to load, split, and generate embeddings for review content, preparing it for AI applications.
- Customizable Company Identification: Easily set and manage the target company for review scraping.
- Manual Trigger: Provides control over when the data extraction process is initiated.
How To Use
- Trigger the Workflow: Click the 'Test workflow' button to initiate the review extraction process.
- Configure Company ID: Update the 'Set Variables' node to specify the
companyIdfor the Trustpilot page you wish to scrape (e.g.,www.freddiesflowers.com). - Adjust HTML Extraction: If Trustpilot's website structure changes, modify the CSS selectors within the 'Extract Reviews' node to ensure accurate data scraping.
- Review Data Structure: Examine the output of the 'Zip Entries' and 'Reviews to List' nodes to understand the structured review data.
- Integrate with AI: Connect the 'Default Data Loader', 'Recursive Character Text Splitter', and 'Embeddings OpenAI' nodes to prepare review content for AI processing. Ensure your OpenAI API credentials are set up correctly.
- Further Processing: The output from the embedding nodes can be used for various downstream AI tasks, such as similarity search or classification.
Apps Used
Workflow JSON
{
"id": "e85c1335-c097-4034-9e90-e32d30e0f548",
"name": "Automate Trustpilot Review Data Extraction and Analysis",
"nodes": 11,
"category": "Operations",
"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: e85c1335-c097...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.