Data analysis and insights generation from survey responses to Google Sheets

• Automate the analysis of survey responses for actionable insights.
• Generate sentiment analysis reports from participant feedback.
• Identify trends and patterns in customer responses.
• Streamline data management by exporting insights directly to Google Sheets.

Import survey responses from Google Sheets. Convert responses into structured question-answer pairs. Vectorize responses using Qdrant for clustering. Apply K-means clustering to identify groups of similar answers. Generate insights and sentiment summaries using OpenAI. Export the final insights back to Google Sheets.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets account to retrieve survey data.
3. 3
   Set up OpenAI and Qdrant credentials for AI processing.
4. 4
   Configure the workflow parameters as needed.
5. 5
   Run the workflow to analyze survey responses and generate insights.