🤖 System Breakdown: Multi-Route AI Feedback Agent

Category: Operational AI Automations / Sentiment RoutingCore Stack: n8n Cloud, Google Gemini (Advanced Chat Model), Google Workspace, Gmail APIArchitecture Style: Agentic Loop with Type-Safe Structured Parsing

📋 Executive Summary

A production-ready internal automation system built on n8n Cloud designed to ingest, process, categorize, and act upon customer feedback in real-time. By utilizing Google Gemini in an agentic node pattern combined with strict JSON schema parsing, the system autonomously evaluates incoming reviews, updates operational databases, and triggers targeted routing pipelines to specific department heads (Kitchen, Delivery, Service, or a general Fallback channel).

⚙️ Deep-Dive Technical Architecture

1. Ingestion & Pre-Processing (Google Sheets Trigger ➔ Extract Data)

• The Blueprint: Real-time polling via an n8n Google Sheets rowAdded trigger capturing raw review submissions.
• Data Isolation: Passes incoming payloads through a specialized data extraction node to cleanly isolate variables (Customer Name, Rating, Review Text, Order ID) into flat JSON properties before hitting the AI model.

2. Agentic Analysis & Type-Safe Extraction (AI Agent ➔ Structured Output Parser)

• The Orchestration: Instead of using a basic completion endpoint, this architecture uses an n8n Advanced AI Agent Node paired natively with a Google Gemini Chat Model.
• Structured Parsing: Implements a Structured Output Parser. This forces Gemini to output data matching a strict schema. The model doesn't just guess; it outputs a precise JSON object containing:
  • sentimentScore: A normalized rating.
  • targetDepartment: Explicit categorization mapping (Kitchen, Delivery, Service, or Fallback).
  • contextualSummary: A concise breakdown of the core complaint or praise.

3. State Management (Set Values ➔ Update Feedback Row)

• Loop Closing: As soon as Gemini generates its structured response, the pipeline loops down to a Set Values modifier node.
• Database Sync: Writes the AI's classification and analysis variables directly back to the source row in Google Sheets, ensuring internal teams have a synchronized record of the AI's decision history.

4. Logic Gates & Dynamic Routing (If ➔ Switch ➔ Gmail API)

• Conditional Filter: Passes data through an evaluation block (If node) to check system flags.
• Multi-Route Switcher: The core of the operation uses an advanced n8n Switch node governed by strict rules matching the targetDepartment output string.