Applying Google Apps Script with Google Sheet: A Case Study of Budget Plan of Khon Kaen University

Abstract

The objective of this research was to  develop and apply Google Apps Script to create folders, forms, grant permissions to data entry officers, and send automated email notifications in the development of a budget request system through Google Sheet; and to study the satisfaction of users and administrators of the budget request system at Khon Kaen University. The study was conducted in 2 phases: 1) the system development was conducted using system development life cycle (SDLC) methodology and 2) the satisfaction of system users and administrators was assessed using two tools: A questionnaire was used to assess user satisfaction. The population was 138 individuals responsible for recording budget request data. The sample size was determined using simple random sampling (SRS) to be 46 people. A semi-structured interview was used to assess the satisfaction of budget request system administrators. The population was 3 system administrators. The interview allowed administrators to share their thoughts on problems, obstacles, and suggestions.

            The research findings indicate that the system was successfully developed to meet its objectives. Based on the evaluation of user satisfaction, the following results were observed: satisfaction with System Quality was at a high level (  = 4.34, S.D. = 0.69), Service Quality at a high level (  = 4.46, S.D. = 0.68), and User Satisfaction also at a high level (  = 4.46, S.D. = 0.59). Additionally, administrators expressed satisfaction with the implemented commands, although they provided some suggestions for improving system efficiency. Future development should focus on enhancing Google App Script commands to accommodate additional requirements beyond the scope of this research.