Jurnal Pengabdian Masyarakat
Vol. 3 No. 1 (2026): BESIRU : Jurnal Pengabdian Masyarakat, Januari 2026

IMPLEMENTASI TEKNOLOGI GOOGLE APPS SCRIPT DAN PHP DALAM OTOMATISASI PENGELOLAAN DATA DAN PEMBUATAN DOKUMEN KERJA SAMA (OIA UNKRISWINA)

Hariadi, Fajar (Unknown)
Enda, Riwa Rambu Hada (Unknown)
Prasetyo, Fajar Indra (Unknown)
Bangu, Dhea Ananda Putri (Unknown)



Article Info

Publish Date
27 Jan 2026

Abstract

The management of cooperation documents in higher education institutions requires efficiency, accuracy, and ease of access. However, at the Office of Institutional Advancement (OIA) of Wira Wacana Christian University Sumba, the process of preparing legal documents such as MoU, IA, and PKS is still carried out manually. This condition causes high workloads, the risk of input errors, and difficulty updating documents that are repetitive. To answer these problems, an automation system based on PHP and SQLite was developed that allows users to generate documents instantly through filling in document numbers and selecting partners and implementers. Google Apps Script is also used to deploy cooperation data to the relevant unit Spreadsheet automatically without manual intervention. The system is built with a simple waterfall approach: needs analysis, form generator design, and data automation script integration. The test results showed a reduction in document creation time of up to 70% and a reduction in input errors. In conclusion, this system is able to increase the efficiency, accuracy, and responsiveness of cooperation administration at OIA Wira Wacana Christian University Sumba.

Copyrights © 2026






Journal Info

Abbrev

BESIRU

Publisher

Subject

Computer Science & IT Education Environmental Science Social Sciences Other

Description

BESIRU : Jurnal Pengabdian Masyarakat is an academic journal organized and operated by LPP Manggala Institute which aims to publish conceptual thoughts or ideas and research findings that have been achieved in the field of community development and application of science and technology, including ...