Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Group Similar Survey Answers with OpenAI Embeddings
When another workflow calls it or you run it, it embeds question-and-answer pairs with OpenAI and finds groups of similar answers for each question in Google Sheets.
What it does
## Step 6. Find Groups of Similar Answers For Each Question [Learn more about using the Code Node]({{ $env.WEBHOOK_URL }} 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
65 steps in total.
Similar automations
Reports, Analytics & DashboardsGroup Similar Survey Answers with OpenAI Embeddings65 stepsRAG & Knowledge BasesFind Insights in Survey Responses with OpenAI and Qdrant30 stepsRAG & Knowledge BasesFind Survey Insights with Qdrant and OpenAI30 stepsRAG & Knowledge BasesAnalyze Survey Responses Automatically with OpenAI RAG11 steps