Saturnus: Jurnal Teknologi dan Sistem Informasi
Vol. 4 No. 2 (2026): April : Saturnus: Jurnal Teknologi dan Sistem Informasi

Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management

Nessa Wulan Rosdiana (Unknown)
Roni Faslah (Unknown)
Rayi Dwipanilih (Unknown)



Article Info

Publish Date
15 Apr 2026

Abstract

This research was conducted with the aim of developing an automation system for recording warehouse inventory based on Google Sheets to improve the effectiveness and efficiency of the stocktaking process at the Cresta Management warehouse. This research was based on problems in the semi-manual process that used logbooks and separate files for each group of goods, which caused problems such as data duplication, limited data access, lack of data transparency, and lengthy recapitulation process. This research used the Research and Development method using the ADDIE model (Analyze, Design, Develop, Implement, and Evaluate). Data were collected through observastion, interviews, questionnaires, and documentation. The result of this development is a system consisting of a login page, goods transcation recording, warehouse dashboard, stock reports, stock cards, and PDF report exports. This study also produced evaluation scores regarding the system’s feasibilty: 93,3% from the first media expert, 80% from the second media expert, 73,3% from the material expert, and 91,75% from users through User Acceptance Testing. These evaluation results indicate that the system is feasible for use and implementation in supporting warehouse operations, as it provides real time data updates, improves the efficiency of goods reporting, and enhances warehouse transactions.

Copyrights © 2026






Journal Info

Abbrev

Saturnus

Publisher

Subject

Computer Science & IT

Description

Saturnus : Jurnal Teknologi dan Sistem Informasi memuat naskah hasil-hasil penelitian di bidang Teknologi, dan Sistem ...