Automated Insights from Survey Data Using n8n and AI

This workflow automates the process of analyzing survey responses to generate actionable insights. It begins by importing survey data from Google Sheets, then converts responses into question-answer pairs. Using OpenAI embeddings, responses are vectorized and stored in a Qdrant vector database. The workflow applies K-means clustering to identify patterns and groups of similar answers, which are summarized by an OpenAI chat model. Finally, the insights, including clusters and summaries, are exported back into a Google Sheet for easy review. This process is ideal for large surveys where detailed, data-driven insights are needed without manual analysis.