Automated Survey Insights Generation from Google Sheets

• Automate the extraction of survey responses from Google Sheets.
• Generate insights and sentiment analysis from participant feedback.
• Identify patterns and clusters in survey responses for better decision-making.

Fetch survey results and headers from Google Sheets. Convert responses into question-answer pairs for analysis. Vectorize responses using Qdrant for clustering. Apply K-means clustering to identify similar responses. Summarize insights using OpenAI's language model. Export summarized insights back to Google Sheets.

1. 1
   Import the workflow template into n8n.
2. 2
   Connect your Google Sheets account to fetch survey data.
3. 3
   Set up OpenAI credentials for insights generation.
4. 4
   Configure Qdrant for vector storage and clustering.
5. 5
   Run the workflow to generate insights from your survey.