Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

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

  1. Embeddings OpenAI
  2. Default Data Loader
  3. Convert to Question Answer Pairs
  4. Recursive Character Text Splitter
  5. Get Survey Results
  6. Get Survey Headers
  7. Extract Questions
  8. Questions to List
  9. Find All Answers
  10. Get Payload of Points
  11. Clusters To List
  12. Set Variables
  13. OpenAI Chat Model
  14. Prep Output For Export

30 steps in total.

Similar automations