FOREO Review Analyzer — AI-powered analytical system

FOREO Review Analyzer — AI-powered analytical system
FOREO Review Analyzer is a Python application that automatically analyzes thousands of customer reviews about FOREO products using the Google Gemini API.
The system classifies each review by sentiment (Positive, Negative, Neutral, Mixed) and category (Design, Effectiveness, Quality, Price, Usability, Customer Service, Delivery, Other), helping marketing teams quickly understand customer sentiment and key pain points.
Technology Stack
Python, Pandas, SQLite3
Google Gemini API
dotenv (API key protection)
JSON Schema (response validation)
Git, Docker (containerized deployment)
REST API integration for external systems
Core Logic
Importing data from CSV (Kaggle dataset) into a local reviews.db.
Batch processing (100 records per batch) to optimize token usage.
Sending structured requests to Gemini API with predefined JSON schema.
Automatically saving analyzed results into sentiment_analysis.db.
Continuous operation mode — the script tracks which reviews have already been processed.
Result
The project fully automates the review analysis process — from data ingestion to actionable insights.
It enables brands to assess product performance, service quality, and overall customer perception efficiently.
Role
Full architecture design and implementation.
Integration with Google Gemini API and development of the data processing pipeline.
Optimization of performance, token efficiency, and system reliability.