Design of a Cloud-Based Reporting System for Real-Time Project Monitoring at SS Partner Portal
Department of Digital Business, Faculty of Economics and Business, Universitas Negeri Surabaya.
Department of Digital Business, Faculty of Economics and Business, Universitas Negeri Surabaya
DOI:
https://doi.org/10.55886/infokom.v10i2.563The operational management of infrastructure and visual marketing projects in the field is often hindered by manual data collection, which is prone to location inconsistencies, loss of physical documents, and inefficient report generation. This study aims to address these issues through the design and implementation of the PT. SS Partner Portal, an integrated cloud-based reporting system. The system was developed using an applied software engineering approach with a three-tier serverless architecture within the Google Workspace ecosystem. The frontend was built using HTML and CSS, the backend logic is driven by Google Apps Script (GAS), and data storage utilizes Google Sheets and Google Drive. The results indicate that the system successfully automates the entire reporting workflow, including geotagging, autocomplete search, Base64 image conversion, and dynamic archive routing. Furthermore, the system automatically generates PDF reports via event-driven triggers and provides a real-time project progress monitoring dashboard. This implementation effectively reduces administrative processing time, minimizes human error, and secures field data integrity without burdening the company with server rental costs (zero-cost architecture).
Keywords: DevOps, Infrastructure as Code, CI/CD, Cloud Computing, DevSecOps Google Apps Script Reporting Automation Serverless Architecture Project Management
Sabda Jauhara Hibrizi, Department of Digital Business, Faculty of Economics and Business, Universitas Negeri Surabaya.
Nanang Hoesen Hidroes Abbrori, Department of Digital Business, Faculty of Economics and Business, Universitas Negeri Surabaya
