Turn recent customer reviews into clear insights with little manual work. The flow collects Trustpilot pages for one company, groups similar comments, and writes the key themes to a Google Sheet. It is a fast way for marketing and product teams to see what customers praise or complain about.

It starts fresh by clearing old entries in the vector store so you analyze clean data. The HTTP Request and HTML nodes pull and parse the latest Trustpilot reviews. Text is split, embedded with OpenAI, and stored in Qdrant with useful metadata like author, rating, and date. A subworkflow then loads reviews by date range, runs a K means clustering step, filters out small groups, fetches the full review payloads, and uses an OpenAI chat model to write short insights for each cluster. The results are formatted and appended to Google Sheets for easy sharing.

You will set the company domain, date window, and sheet details, then test the run to confirm points are saved and insights appear. Teams can track monthly themes, compare time periods, and cut analysis time from hours to minutes. This setup works well for brands that monitor voice of customer, campaign feedback, and common product issues at scale.

• Scrapes recent Trustpilot pages with HTTP Request and parses content with the HTML node using CSS selectors.
• Builds clean review records by zipping fields and splitting arrays into one item per review.
• Loads text with a document loader and splits long text into chunks to improve embedding quality.
• Creates vector embeddings with OpenAI text embedding model and stores them in Qdrant with metadata.
• Runs a subworkflow with a date window to fetch the right records from Qdrant for analysis.
• Applies a K means clustering step in a code node and filters out small clusters to keep signal strong.
• Uses an OpenAI chat model to write clear insights for each cluster of reviews.
• Formats and appends results to Google Sheets for reporting and team access.

• Reduce manual review reading from hours to minutes per report
• Automate about 90 percent of tagging and summarizing work
• Group similar feedback to reveal top themes without bias
• Track changes over time with a simple date range input
• Export insights straight to Google Sheets for easy sharing
• Handle hundreds of reviews in one run without extra effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with OpenAI, Qdrant and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI API Key credential. Use your OpenAI API key from the OpenAI account dashboard. Name the credential clearly, for example OpenAI Main.
4. In the n8n credentials manager, create a Qdrant API credential. Enter your Qdrant base URL and API key from your Qdrant dashboard. Name it Qdrant Production or similar.
5. In the n8n credentials manager, create a Google Sheets OAuth2 credential. Follow the on screen steps to grant access to your Google account. Name it Google Sheets Team.
6. Open the Set Variables node labeled company settings and enter the company domain used by Trustpilot, for example www.example.com. Trustpilot must recognize it in the URL.
7. Open the Qdrant Vector Store node and confirm the collection name is trustpilot_reviews. If it does not exist, let the node create it or create it in Qdrant with the same name.
8. Check the Embeddings OpenAI node and confirm the model text-embedding-3-small is selected and linked to your OpenAI credential.
9. Open the Execute Workflow Trigger and Set Variables nodes in the insights subflow and confirm companyId and the from and to dates are mapped as shown.
10. Review the HTML Extract node selectors. If Trustpilot changes its layout, update the CSS selectors for author, rating, title, text, and date.
11. Connect the Google Sheets node to your target spreadsheet and choose the correct worksheet. Map the output fields you want to record such as theme, summary, and sample reviews.
12. Click Test workflow to run a full pass. Verify new points appear in Qdrant, clusters are created, and rows are appended to your Google Sheet.
13. If clustering returns too few groups, lower the minimum size in the filter node. If results are noisy, raise the minimum size or tune the code node parameters.
14. If you see no reviews, confirm the company domain is correct and that Trustpilot pages load in your region. Adjust the HTTP Request node to fetch additional pages if needed.