Survey analysis with clustering and AI: insights to Goo

This workflow automatically processes open-ended survey responses by clustering similar answers and generating meaningful AI-powered insights. Designed for professionals working with large volumes of qualitative feedback who want to extract value without manual coding or tagging.

## Who it´s for
- UX researchers collecting and analyzing qualitative survey data
- Product managers needing deep insights from user feedback
- Marketers running large-scale surveys requiring automated processing
- Data analysts handling high volumes of textual responses
- Teams using n8n aiming for AI-powered analysis without writing code

## What the automation does
- Imports survey responses from Google Sheets
- Converts text answers into vectors using OpenAI Embeddings
- Stores vectors in Qdrant with metadata (question, respondent ID)
- Performs K-means clustering for each question
- Generates insights per cluster using GPT-4o-mini
- Exports results (clusters, insights, sample responses) to a new sheet
- Flags outlier or unclustered responses as "no action needed"

## What´s included
- Ready-to-use n8n workflow
- Trigger logic: manual execution or external HTTP call
- Integrations with Google Sheets, Qdrant, and OpenAI
- Basic documentation for setup and adaptation

## Requirements for setup
- n8n instance with access to Python nodes and LangChain
- Google Cloud account with Google Sheets API enabled
- Qdrant instance (local or cloud)
- OpenAI API key with access to GPT-4o-mini and embeddings
- Installed dependencies: scikit-learn, langchain, qdrant-client

## Benefits and outcomes
- Saves hours on manual review of hundreds of open-ended responses
- Reveals hidden patterns and recurring themes in feedback
- Delivers structured, human-readable insights generated by LLM
- Automatically separates significant trends from isolated opinions
- Exports clean results to Google Sheets for reporting and sharing
- Easily reusable across multiple surveys with minimal reconfiguration

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.