Survey Data Analysis and Insight Generation Workflow

This n8n workflow is designed for analyzing survey responses to uncover valuable insights. The process begins with importing survey data from Google Sheets, extracting questions and responses, and converting answers into embedding vectors using OpenAI’s embedding model. It then utilizes a Qdrant vector store to cluster similar responses through K-means clustering, helping identify common themes or patterns. Each cluster is further analyzed by an AI language model to generate summaries and insights, which are subsequently exported back into Google Sheets for easy review. This workflow is ideal for organizations seeking to analyze large-scale survey data, reveal hidden response patterns, and generate comprehensive reports, all while maintaining a structured and automated data pipeline.