The Problem

Zone Fitness was making use of multiple Google Sheets to collect and manage employee details. Multiple looks had bee setup in order to provide some sort of reporting on the data.

The Solution I Built

I developed a Google Apps Script that could easily be inserted (with minimal changes to the script) into all their sheets and various processes and would push the submitted data to Cloud SQL, where Looker Studio would be implemented to provide reporting the required reporting.

Challenges

• Developing a script that was easily reusable no matter the process that was running.