Utilized Google Apps Script to generate a dummy dataset, create Business KPIs and dashboard visualization, automate data quality checks (null and duplicate values), and to monitor and automate application processes.