AI Agent for Automated Trustpilot Review Analysis & Insights

Unlock Deep Customer Insights from Trustpilot with this AI Agent

Stop manually sifting through hundreds of customer reviews. This powerful AI Agent automates the entire feedback analysis pipeline. It starts by scraping the latest reviews for your company from Trustpilot, then uses AI to process, understand, and categorize them. The agent's core ability is 'insight generation'. It intelligently groups reviews into thematic clusters using machine learning, then deploys an LLM to analyze each cluster, summarizing the core feedback, identifying the sentiment, and suggesting concrete improvements. The final, structured insights are neatly organized and exported to a Google Sheet, giving you a real-time pulse on customer feedback.

Key Features & Benefits

• Automated Data Scraping: Continuously fetches the latest company reviews from Trustpilot.
• AI-Powered Clustering: Uses OpenAI embeddings and a K-means clustering algorithm to automatically group similar reviews, uncovering hidden topics and trends without manual tagging.
• Deep Insight Generation: Leverages OpenAI's GPT-4o mini to analyze each review cluster, providing a summary, sentiment score, and actionable improvement suggestions.
• Vector Database Integration: Stores vectorized reviews in Qdrant, creating a powerful, searchable knowledge base of all your customer feedback.
• Automated Reporting: Delivers structured, easy-to-digest insights directly to a Google Sheet, ready for your team to analyze and act upon.

• An n8n instance (Cloud or self-hosted).
• OpenAI API Key with access to a model like gpt-4o-mini and text-embedding-3-small.
• Access to a Qdrant vector store instance (e.g., via Docker or Cloud).
• Google Sheets API credentials.
• Python environment enabled in your n8n instance for the Code node.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. In the 'Set Variables' node, update the companyId with the target company's Trustpilot URL slug (e.g., www.yourcompany.com).
4. Configure the 'Embeddings OpenAI' and 'OpenAI Chat Model' nodes with your OpenAI credentials.
5. Configure the 'Qdrant Vector Store' node and all HttpRequest nodes that call Qdrant with your Qdrant instance URL and API credentials.
6. Configure the 'Export To Sheets' node with your Google Sheets credentials, spreadsheet ID, and sheet name.
7. Activate the workflow. Note: The first run of the 'Apply K-means...' node may be slow as it installs required Python packages.