Jabu Review Bot.json

The Jabu Review Bot is an automated system designed to collect customer reviews via API, classify them using AI, and route notifications to the relevant departments.

1. Data Collection & Extraction

• Schedule: The workflow triggers automatically on the 30th of every month.
• Review Retrieval: It fetches review data from an external source (Apify) using an HTTP Request.
• Database Logging: New reviews are automatically appended or updated in a Google Sheet called "Copy of Daily Bean Feedback".
• Data Preparation: The system extracts key information such as the customer's Name, Feedback, Contact info, and Timestamp.

2. AI Analysis & Categorization

• AI Processing: An AI Agent, powered by Google Gemini, analyzes the feedback text.
• Smart Classification: The AI assigns each review to a specific Category (Question, Problem, Suggestion, etc.) and Business Area (Kitchen, Delivery, Service, etc.).
• Structured Output: A parser ensures the AI's findings are formatted correctly before being written back to the Google Sheet.

3. Smart Routing & Notifications

The system checks the identified business area and routes the feedback accordingly:

• Kitchen: Sends a detailed Gmail alert to the team including the feedback text, AI-assigned category, and timestamp.