An AI-powered automation workflow that analyzes customer feedback, categorizes issues, and routes alerts to the relevant business team.
The system uses n8n for workflow orchestration and a large language model to classify feedback into categories and operational areas.
- Automated feedback ingestion from Google Sheets
- AI-based feedback classification
- Structured output parsing
- Normalized labels for reliable automation
- Automatic routing to the appropriate team
- Email alerts for actionable feedback
Google Sheets Trigger
→ Extract Feedback Data
→ AI Categorization (LLM)
→ Structured Output Parser
→ Normalize Labels
→ Update Feedback Record
→ Route by Business Area
→ Send Notification Email
- n8n workflow automation
- Google Sheets API
- Google Gemini LLM
- LangChain agent node
- JSON workflow orchestration
Example classification generated by the AI system:
Category: problem
Area: delivery
The workflow then routes the issue to the delivery operations team.
- Import the workflow JSON into n8n.
- Connect credentials for:
- Google Sheets
- Gmail
- Gemini API
- Replace placeholder values for:
- Google Sheet ID
- Email recipient
- Activate the workflow.
All credentials, IDs, and private identifiers have been removed from this repository.