Library / RAG & Knowledge Bases
RAG & Knowledge Bases
Find Survey Insights with Qdrant and OpenAI
When you run it, it embeds survey answers from Google Sheets in Qdrant, groups similar answers per question and extracts insights with OpenAI.
What it does
## Step 6. Find Groups of Similar Answers For Each Question Learn more about using the Code Node Giving all the responses to an LLM to analyse is the common but naive approach; the summarisation is usually too high level for real insights and loses a lot of detail such as the number and identity of respondants. What we want to do instead is find and group popular answers for each question to ensure all perspectives are considered. Our approach does this by mapping our answer vectors to a 2D grid and then identifying where the vector points are "clustered"; where a group of points are within close proximity to each other.
The steps
- Embeddings OpenAI
- Default Data Loader
- Convert to Question Answer Pairs
- Recursive Character Text Splitter
- Get Survey Results
- Get Survey Headers
- Extract Questions
- Questions to List
- Find All Answers
- Get Payload of Points
- Clusters To List
- Set Variables
- OpenAI Chat Model
- Prep Output For Export
30 steps in total.
Similar automations
RAG & Knowledge BasesFind Insights in Survey Responses with OpenAI and Qdrant30 stepsRAG & Knowledge BasesAnalyze Survey Responses Automatically with OpenAI RAG11 stepsReports, Analytics & DashboardsMine Customer Insights from Reviews with Qdrant and OpenAI24 stepsForms & SurveysReceive SurveyMonkey Survey Responses2 steps