Automate Trustpilot Review Extraction and Data Enrichment
detail.loadingPreview
Streamline your review management process by automatically extracting and enriching Trustpilot reviews. This workflow transforms raw review data into structured, ready-to-use information for deeper analysis and integration.
About This Workflow
This n8n workflow automates the extraction of customer reviews from Trustpilot, a leading customer review platform. It begins with a manual trigger, allowing you to initiate the process on demand. The core of the workflow utilizes HTML parsing to meticulously extract various data points from each review, including the reviewer's name, rating, title, text, date of experience, country, review URL, and the reviewer's total review count. Crucially, this raw data is then processed and structured using a 'Set' node, standardizing formats for dates, numerical ratings, and concatenating review URLs with the base domain. Further enrichment occurs with a 'Default Data Loader' and 'Recursive Character Text Splitter,' preparing the review content for potential use with AI models by embedding it and adding valuable metadata like review month, year, and company ID. This comprehensive data pipeline ensures you have clean, organized, and actionable customer feedback at your fingertips.
Key Features
- Automated Review Extraction: Seamlessly pull review details from Trustpilot pages.
- Structured Data Generation: Transforms raw HTML into organized JSON with standardized fields.
- Data Enrichment: Adds valuable metadata like review dates, months, years, and company identifiers.
- AI-Ready Output: Prepares review content for ingestion into AI models and vector databases.
- Flexible Integration: Designed for easy integration into broader data pipelines and analysis tools.
How To Use
- Trigger the Workflow: Click the 'Test workflow' button to initiate the data extraction process.
- Configure URL: Ensure the 'Get TrustPilot Page' node (implied, not shown in snippet) is correctly configured with the target Trustpilot URL.
- Review Node Settings: Verify the CSS selectors in the 'Extract Reviews' node match the current Trustpilot HTML structure. Adjust if necessary.
- Set Company ID: In the 'Set Variables' node, update the
companyIdto reflect the domain of the Trustpilot page you are scraping. - Connect to Downstream Processes: Utilize the output of the 'Embeddings OpenAI' and 'Recursive Character Text Splitter' nodes for further processing, such as storing in a vector database or feeding into an AI model.
Apps Used
Workflow JSON
{
"id": "a78bed38-0efe-4dff-b684-cb5975eb9438",
"name": "Automate Trustpilot Review Extraction and Data Enrichment",
"nodes": 22,
"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: a78bed38-0efe...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
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.