Templates / Survey insights with Qdrant, Python and Information Extractor

Survey insights with Qdrant, Python and Information Extractor

Ready for 3.0

by Jimleuk ✓ · 3,718 views · created 2024-08-05 · Market Research, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 30 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Embeddings OpenAI, Google Sheets, OpenAI Chat Model and Qdrant Vector Store.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

  1. Get Survey Results (Google Sheets): uses Google Sheets
  2. Get Sheet Details (HTTP Request): calls an HTTP API
  3. Convert to Question Answer Pairs (Edit Fields (Set)): sets 1 field: data
  4. Set Variables (Edit Fields (Set)): sets 3 fields: collectionName, surveyName, insightsSheetName
  5. QA Pairs to List (Split Out): splits a list into separate items
  6. Create Insights Sheet (Google Sheets): create
  7. Qdrant Vector Store: stores documents in the Qdrant vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
  8. Get Survey Headers (Google Sheets): uses Google Sheets
  9. Prep Values For Trigger (Edit Fields (Set)): sets 2 fields: sheetID, sheetName
  10. Extract Questions (Edit Fields (Set)): sets 1 field: question

…plus 14 more steps. See the full node list below.

Services it uses

Embeddings OpenAIGoogle SheetsOpenAI Chat ModelQdrant Vector Store

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (17)

From the author

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…

Excerpt from Jimleuk's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.