Survey insights with Qdrant, Python and Information Extractor
Ready for 3.0What 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).
- Get Survey Results (Google Sheets): uses Google Sheets
- Get Sheet Details (HTTP Request): calls an HTTP API
- Convert to Question Answer Pairs (Edit Fields (Set)): sets 1 field: data
- Set Variables (Edit Fields (Set)): sets 3 fields: collectionName, surveyName, insightsSheetName
- QA Pairs to List (Split Out): splits a list into separate items
- Create Insights Sheet (Google Sheets): create
- Qdrant Vector Store: stores documents in the Qdrant vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
- Get Survey Headers (Google Sheets): uses Google Sheets
- Prep Values For Trigger (Edit Fields (Set)): sets 2 fields: sheetID, sheetName
- Extract Questions (Edit Fields (Set)): sets 1 field: question
…plus 14 more steps. See the full node list below.
Services it uses
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)
- Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Edit Fields (Set)
n8n-nodes-base.set - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Google Sheets
n8n-nodes-base.googleSheets - Split Out
n8n-nodes-base.splitOut - HTTP Request
n8n-nodes-base.httpRequest - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - If
n8n-nodes-base.if - Manual Trigger
n8n-nodes-base.manualTrigger - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - Qdrant Vector Store
@n8n/n8n-nodes-langchain.vectorStoreQdrant - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor
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…