Survey insights with Qdrant Python and Information Extractor
This n8n template is one of a 3-part series exploring use-cases for clustering vector embeddings: Survey Insights Customer Insights Community Insights This t...
🔌 Nodes & Integrations Used (9)
📖 Implementation & Setup Guide
This n8n template is one of a 3-part series exploring use-cases for clustering vector embeddings: * Survey Insights * Customer Insights * Community 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 identify frequently mentioned positives and negatives.
Sample Output: https://docs.google.com/spreadsheets/d/e/2PACX-1vT6m8XH8JWJTUAfwojc68NAUGC7q0lO7iV738J7aO5fuVjiVzdTRRPkMmT1C4N8TwejaiT0XrmF1Q48/pubhtml#
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 response 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 summarise 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.
Customising the Template * Adjust clustering parameters which make sense for your data. Add more clusters for open-ended questions and less clusters when responses are multiple choice.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Survey_insights_with_Qdrant_Python_and_Information_Extractor.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related RAG & Vector DB Workflows
View All in RAG & Vector DB →AI Document Note Generator from Folder
Production-ready n8n automation template for AI Document Note Generator from Folder built by AhiXLight. Seamlessly connects Local File Trigger, Document Default Data Loader, Text Splitter Recursive Character Text Splitter with 42 configured nodes.
AI-Powered Document Note Generator
Production-ready n8n automation template for AI-Powered Document Note Generator built by AhiXLight. Seamlessly connects Local File Trigger, Document Default Data Loader, Text Splitter Recursive Character Text Splitter with 42 configured nodes.
AI crew to automate fundamental stock analysis Q A workflow
How it works: Using a Crew of AI agents (Senior Researcher, Visionary, and Senior Editor), this crew will automatically determine the right questions to ask ...
Amazon Keyword Suggestion Storage Workflow
Production-ready n8n automation template for Amazon Keyword Suggestion Storage Workflow built by AhiXLight. Seamlessly connects Airtable, HTTP Request with 12 configured nodes.