Daily Bean Feedback Agent.json
The Daily Bean Feedback Agent is an automated system that monitors customer feedback, categorizes it using AI, and routes alerts to the appropriate department.
1. Data Collection & Extraction
- Trigger: The workflow polls a Google Sheet called "Copy of Daily Bean Feedback" every minute for new rows.
- Data Extraction: It captures essential fields including the customer’s Name, Feedback, Contact information, and the Timestamp.
2. AI Analysis & Categorization
- AI Processing: Using the Google Gemini Chat Model, an AI agent analyzes the feedback text.
- Classification: The AI assigns each entry into specific categories and business areas:
- Valid Categories: Question, problem, suggestion, or other.
- Valid Areas: Kitchen, delivery, service, or other.
- Structured Output: A parser ensures the AI provides these labels in a clean, standardized format.
3. Record Management
- Sheet Update: The workflow updates the original Google Sheet row with the AI-generated Category and Area labels, using the unique ID to match the record.
- Validation: An If node checks if the AI was unable to determine a category or area (labeled as "unknown") before proceeding to notifications.
4. Smart Routing & Notifications
The workflow uses a Switch node to route the feedback based on the assigned business area:
- Kitchen: Sends a Gmail notification to the team with details on the feedback and category.