Customer feedback analysis with AI QuickChart HTML report gen
Generative Customer Insights from Feedback Data using AI Agents & Charts This workflow automates the analysis of customer feedback or social media data from ...
🔌 Nodes & Integrations Used (5)
📖 Implementation & Setup Guide
Generative Customer Insights from Feedback Data using AI Agents & Charts
This workflow automates the analysis of customer feedback or social media data from Google Sheets using DeepSeek LLM, transforming raw text into structured semantic insights. The workflow also generates data visualizations and produces a final HTML report, ready for email delivery.
---
Table of Contents - [What This Workflow Does](#what-this-workflow-does) - [Pre-conditions and Requirements](#pre-conditions-and-requirements) - [Step-by-Step Workflow Explanation](#step-by-step-workflow-explanation) - [Example Results](#Example-Results) - [Customization Guide](#customization-guide)
---
What This Workflow Does
This workflow performs automated semantic analysis on unstructured feedback data (from Google Sheets), using LLM-based agents and a sequence of transformations. It achieves:
- **Prompt proposal generation**: AI generates generalizable prompts for various analysis dimensions.
- **Row-level analysis**: Each row of data is evaluated against all prompts.
- **Output merging and refinement**: Raw analysis outputs are merged, deduplicated, and semantically clustered.
- **Visualization and report generation**: QuickChart is used to create graphs, and an HTML report is produced.
- **Email delivery**: The full report is sent automatically via Gmail.
---
Pre-conditions and Requirements
- **API Keys**
- - DeepSeek API Key
- - Gmail OAuth2 (for sending results)
- **Google Sheet Access**
- - A preformatted Google Sheet containing social listening feedback
- - The sheet must include at least 20 rows for sample prompt generation
- **n8n Configuration**
- - Nodes used: Google Sheets, LangChain (LLM/Agent/Parser), Function, Merge, QuickChart (via URL), Gmail
- - Ensure all credentials are configured properly in n8n’s credential manager
---
Step-by-Step Workflow Explanation
- **Google Sheet Import**
- - Retrieves feedback rows from a specific Google Sheet tab
- - Filters to the first 20 rows for prompt generation
2. **Prompt Proposal Agent** - AI generates 3–6 row-level analysis prompts in a structured JSON format - Prompts must be agnostic to product names and column headers
3. **Prompt Injection and Pairing** - Each row is paired with all prompts - Combined into a single dataset for row-by-row LLM evaluation
4. **First Iteration of Analysis** - An LLM answers all injected prompts row-by-row - Output is parsed and transformed into structured fields
5. **Semantic Merging and Refinement** - Merged lists of values from all rows - AI clusters synonyms and regenerates improved prompt definitions
6. **Second Iteration of Analysis** - The refined prompts are used to re-analyze each row - A new structured output per row is generated and merged into one object
7. **Summarization and Visualization** - AI generates summaries per dimension (e.g., sentiment) - QuickChart visualizations are created and URL-encoded - Cross-dimensional insights and a global narrative are generated
8. **Final Report Generation and Emailing** - A final HTML report is generated - Sent to the specified email using Gmail node
--- ## Example Results  ## Customization Guide
1. Modify Data Source - Change the Google Sheet ID or sheet tab - Add filters for specific time periods or product names
2. Adjust Prompt Definitions - Refine the initial prompt agent instruction to tailor the type of analysis
3. Swap LLM Models - Replace DeepSeek with OpenAI or another LLM via LangChain nodes
4. Visual Styling - Customize QuickChart configurations to adjust chart types, colors, legends
5. Report Format - Update the final HTML prompt to reflect brand design or restructure sections
6. Add Report Destinations - Replace Gmail with Google Drive upload, Notion page creation, or Slack post
---
This end-to-end AI-powered social listening workflow enables scalable, repeatable, and customizable insights generation from unstructured customer feedback.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
Customer_feedback_analysis_with_AI_QuickChart_HTML_report_gen.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....