What This Workflow Does
The Customer Survey Summary Generator automates the analysis of customer feedback by organizing responses based on sentiment and using AI to identify themes, extract insights, and generate actionable recommendations. This template eliminates manual review of survey data and delivers consolidated reports automatically.
How It Works
The workflow follows a systematic process to transform raw survey data into intelligent summaries:
- A scheduled trigger runs the workflow daily at your specified time
- Survey responses are pulled directly from Google Sheets
- A code node organizes responses into sentiment categories: positive, neutral, and negative
- Responses are split into batches for efficient processing
- An AI agent with OpenRouter analyzes each batch to extract themes and patterns
- A structured output parser formats the results into consistent JSON
- Final reports are sent to Slack or saved back to Google Sheets
Use Cases
- E-commerce Product Feedback: Automatically summarize customer product reviews to identify quality issues and feature requests
- Customer Support Analysis: Consolidate support ticket feedback by satisfaction level to spot common problems and training gaps
- Employee Engagement Surveys: Analyze pulse survey responses to understand team sentiment and workplace concerns
- Market Research Reports: Process focus group transcripts to extract competitive insights and market trends
- Patient Satisfaction Tracking: Organize healthcare feedback by experience category to improve service delivery
Nodes Used
- Sticky Note: Workflow documentation and reference notes
- Schedule Trigger: Activates the workflow on a daily schedule
- Google Sheets: Reads survey responses from your spreadsheet
- Code Node: Sorts and categorizes responses by sentiment
- Split in Batches: Divides responses into manageable groups for processing
- AI Agent (n8n): Intelligent analysis of survey content to extract insights
- LM Chat OpenRouter: Large language model for semantic analysis and theme extraction
- Output Parser Structured: Converts AI results into consistent JSON format
- Slack: Sends formatted summary reports to team channels
Prerequisites
- Active n8n account with workflow creation access
- Google Sheets with survey response data in a defined format
- OpenRouter API key for language model access
- Slack workspace and channel for report distribution
- Survey data containing customer feedback or comments
- Basic understanding of workflow scheduling and data flow
Difficulty Level
Intermediate. This template requires familiarity with n8n workflows, basic code node modifications, and API credential setup. Users should understand how to connect data sources and configure the schedule trigger, but the template handles most complex AI logic automatically.
This workflow template is shared under the n8n fair-code license. Free to use and modify.
Leave a Reply