Curated

(5/5)

Survey Insights with Qdrant, Python and Information Extractor

Step 1. Import Survey Responses [Read more about Google Sheets](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets) Our approach requires to import all participant responses as vectors with metadata linking them to the questions being answered. To do this, we'll generate questiona and answer pairs from the survey.

Integrations Used (9)

Embeddingsopenai

Documentdefaultdataloader

Textsplitterrecursivecharactertextsplitter

Workflow Structure (30 nodes)

100%

Manual Trigger

When clicking ‘Test workflow’

Google Sheets

Get Survey Results

Set

Convert to Question Answer Pairs

Split Out

QA Pairs to List

Langchain.embeddings Open Ai

Embeddings OpenAI

Langchain.vector Store Qdrant

Qdrant Vector Store

Langchain.document Default Data Loader

Default Data Loader

Langchain.text Splitter Recursive Character Text Splitter

Recursive Character Text Splitter

Set

Prep Values For Trigger

Execute Workflow

Trigger Insights

Execute Workflow Trigger

Set

Set Variables

Http Request

Get Sheet Details

Google Sheets

Create Insights Sheet

Google Sheets

Get Survey Headers

Set

Extract Questions

Split Out

Questions to List

Split In Batches

For Each Question...

Http Request

Find All Answers

Code

Apply K-means Clustering Algorithm

Has Clusters?

Split Out

Clusters To List

Set

Prep Values For Export

Filter

Only Clusters With 3+ points

Google Sheets

Export To Sheets1

Http Request

Get Payload of Points

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.information Extractor

Survey Insights Agent

Set

Prep Output For Export

Google Sheets

Export To Sheets

Node Types:

default

transform

logic

action

http

trigger

code

Requires credentials

Prerequisites

Required Credentials (3)

Google Sheets

Used by: Get Survey Results, Get Survey Headers +4 more

Docs

OpenAI

Used by: Embeddings OpenAI, OpenAI Chat Model

Docs

Qdrant

Used by: Find All Answers, Get Payload of Points +1 more

Docs

Multiple services required

This workflow needs 3 different credentials. Make sure you have accounts for all services before importing.

Complexity

Advanced

Expert level. Custom code, complex logic, many integrations.

Setup time: ~50 min

Score: 90/100

Custom Code

Conditional Logic

Loops

6 Integrations

When to Use This Workflow

AI-Powered Content Creation

Automate content generation, summarization, or analysis using AI capabilities.

Save hours of manual work while maintaining quality and consistency.

Automated Reporting

Automatically collect and organize data into spreadsheets for analysis.

Spend less time on data entry and more time on insights.

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

workflow.json

{
  "meta": {
    "instanceId": "408f9fb9940c3cb18ffdef0e0150fe342d6e655c3a9fac21f0f644e8bedabcd9"
  },
  "nodes": [
    {
      "id": "0404384b-10b6-4666-84a4-8870db30c607",
      "name": "Embeddings OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        1220,
        280
      ],
      "parameters": {
        "model": "text-embedding-3-small",
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "8gccIjcuf3gvaoEr",
...