Case Studies

Automated Data Cleaning & System

E-Commerce Platform

Developed a solution that automates the generation and distribution of weekly performance reports, saving the team 10 hours per week.

HTML5 & CSS
Google Sheets API
Apps Script
Column/pie charts

Results Achieved:

Time Saved: 15 hours/week
Error Reduction: 95%
Processing Speed: 10x faster

Certificate & Email Generator

Educational Institution

Automate data collection from an Excel sheet, generates certificates from a Google Docs template, converts them to PDF, and populates a status tab with links. A sidebar provides options to send emails with user-defined templates. The system handles all data processing and communication

Google docs API
Apps Script
HTML 5 & CSS
Email Reports

Results Achieved:

Data Accuracy: 100%
Report Generation: Automated
Team Productivity: +40%