Customer feedback analysis with AI, QuickChart & HTML report generator

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.