Automate Survey Insights: Google Sheets to Qdrant Vector DB with OpenAI

How it works

This n8n workflow automates the process of extracting insights from survey data stored in Google Sheets. It begins by fetching survey responses and their headers. The data is then transformed into question-answer pairs, with metadata including the participant and survey name. These pairs are vectorized using OpenAI's embeddings and stored in a Qdrant vector database. The workflow then iterates through unique questions, queries Qdrant for relevant answers using a filter based on the question and survey name, retrieves detailed payloads, and prepares a consolidated output. Finally, the generated insights are exported to a new sheet in the original Google Sheet document, including response counts, participant IDs, and raw responses. Sticky notes guide through the four main steps: importing data, vectorizing responses, triggering insights analysis, and creating the insights sheet.