This n8n template is one of a 3-part series exploring use cases for clustering vector embeddings:

Survey InsightsCustomer InsightsCommunity Insights

This template demonstrates the Survey Insights scenario where survey participant responses can be quickly grouped by similarity, and an AI agent can generate insights on those groupings.

With this workflow, researchers can save days and even weeks of work breaking down cohorts of participants and identifying frequently mentioned positives and negatives.

How it works
All survey questions and responses are imported from a Google Sheet. Responses are then inserted into a Qdrant collection, carefully tagged with the question and survey metadata.

For each question, all relevant responses are put through a clustering algorithm using the Python Code node. The Qdrant points are returned in clustered groups.

Each group is looped to fetch the payloads of the points and feed them to the AI agent to summarize and generate insights for. The resulting insights and raw responses are then saved to the Google Spreadsheet for further analysis by the researcher.

Requirements
– Survey data and format as shown in the attached Google Sheet.
– Qdrant Vectorstore for storing embeddings.
– OpenAI account for embeddings and LLM.Customizing the Template
Adjust clustering parameters that make sense for your data. Add more clusters for open-ended questions and fewer clusters when responses are multiple choice.