Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

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

  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

65 steps in total.

Similar automations