Collect recent online reviews for a chosen company, group common themes, and send clear insights to a sheet your team can use. Marketing and product teams can spot patterns fast and decide what to fix or promote.

The run starts by clearing old records for that company in the vector database. It pulls a few review pages with an HTTP request and uses an HTML parser to grab author, rating, title, and text. Each review is turned into an embedding with OpenAI and stored in Qdrant with company tags. A linked subflow loads reviews in a date range, clusters similar items, keeps groups with at least three reviews, and fetches full details from Qdrant. A chat model then turns each cluster into short notes that explain what customers are saying. The flow formats the results and appends them to Google Sheets.

You need an OpenAI key, a Qdrant endpoint, and Google Sheets access. Set the company domain and the time window, then run a test. Expect to cut review analysis from hours to minutes and deliver consistent reports for voice of customer, churn clues, and product feedback.

• Scrapes recent review pages and extracts author, rating, title, and text with the HTML node
• Builds clean review items using Zip and Split Out so each review is processed on its own
• Creates embeddings with OpenAI text-embedding-3-small for similarity search
• Stores vectors in Qdrant with companyId metadata to support filtering and date ranges
• Runs a subworkflow via Execute Workflow Trigger to scope insights by from and to dates
• Applies k means clustering in a Code node and filters to clusters with at least three points
• Fetches full review payloads for each cluster from Qdrant using the HTTP Request node
• Generates concise insights with an OpenAI chat model and writes results to Google Sheets

• Reduce manual review reading from 3 hours to 10 minutes per run
• Focus on real issues by keeping clusters with 3 or more reviews
• Handle hundreds of reviews per run without extra effort
• Connect Trustpilot data, Qdrant vectors, OpenAI insights, and Google Sheets reports
• Keep weekly reporting stable with the same format and fields each time

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 Google Sheets, OpenAI and Qdrant. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI credential: click New > OpenAI API > paste your API key from your OpenAI account page > give it a clear name like OpenAI Prod > Save.
4. In the credentials manager, add Qdrant: choose Qdrant API > enter your Qdrant base URL and API key from your Qdrant dashboard > name it Qdrant Prod > Save and test.
5. In the credentials manager, add Google Sheets: choose Google Sheets OAuth2 > Sign in with your Google account > allow access > name it Sheets Prod > Save and test.
6. Open the Set Variables node and update companyId to match the company domain used in the Trustpilot URL, for example www.example.com.
7. Open the Get TrustPilot Page and Extract Reviews nodes. Confirm the URL pattern and CSS selectors match the company pages you want to scrape. Run each node in test mode to see sample data.
8. Open the Qdrant Vector Store node and confirm the collection name trustpilot_reviews. If it does not exist, let Qdrant create it or create it in your Qdrant console.
9. Check the Embeddings OpenAI and OpenAI Chat Model nodes are set to your OpenAI credential and selected models. Keep text-embedding-3-small and gpt-4o-mini unless you have a reason to change.
10. Open the Execute Workflow Trigger and Set Variables1 nodes to confirm the companyId and the from and to dates for your insights window.
11. Click Test workflow. Confirm Clear Existing Reviews succeeds, new points appear in Qdrant, and rows append in your target Google Sheet.
12. Troubleshooting: If no reviews appear, Trustpilot selectors may have changed; recheck the HTML node. If Qdrant calls fail, verify the base URL and API key. If Sheets does not update, ensure the correct spreadsheet ID and tab are set and the OAuth credential has access.