Extract and Analyze TrustPilot Reviews for Insights

• Automate the collection of customer reviews from TrustPilot.
• Analyze sentiment and extract insights from customer feedback.
• Generate reports on customer opinions for strategic decision-making.
• Identify trends and patterns in customer reviews over time.

Clear existing reviews from the database to ensure fresh data. Fetch the latest reviews from TrustPilot using HTTP requests. Extract relevant data from the HTML content of the reviews. Store the extracted reviews in a Qdrant vector database for analysis. Apply K-means clustering to group similar reviews. Utilize AI models to generate insights and summarize customer feedback. Export the insights and review data to Google Sheets for reporting.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Set your company ID in the 'Set Variables' node.
3. 3
   Run the workflow to clear existing reviews and fetch new data.
4. 4
   Monitor the workflow execution for successful data extraction and analysis.