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

Nessa Wulan Rosdiana ; Roni Faslah ; Rayi Dwipanilih
Saturnus: Jurnal Teknologi dan Sistem Informasi 📅 2026 Vol 4, No 2 🔗 DOI: 10.61132/saturnus.v4i2.1535
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.
Keywords
Google Sheets; Information System; Inventory Management; Stock Taking; Warehouse Inventory
How to Cite

Nessa Wulan Rosdiana, et al. (2026). Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management. Saturnus: Jurnal Teknologi dan Sistem Informasi, 4(2). https://doi.org/10.61132/saturnus.v4i2.1535

Nessa Wulan Rosdiana; Roni Faslah; Rayi Dwipanilih, "Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management," Saturnus: Jurnal Teknologi dan Sistem Informasi, vol. 4, no. 2, 2026.

Nessa Wulan Rosdiana; Roni Faslah; Rayi Dwipanilih. "Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management." Saturnus: Jurnal Teknologi dan Sistem Informasi, vol. 4, no. 2, 2026.

Nessa Wulan Rosdiana; Roni Faslah; Rayi Dwipanilih. "Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management." Saturnus: Jurnal Teknologi dan Sistem Informasi 4, no. 2 (2026).

Nessa Wulan Rosdiana, et al. (2026) 'Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management', Saturnus: Jurnal Teknologi dan Sistem Informasi, 4(2). doi: 10.61132/saturnus.v4i2.1535.

Nessa Wulan Rosdiana; Roni Faslah; Rayi Dwipanilih. Penerapan Google Sheets sebagai Sistem Otomatisasi Pencatatan Barang untuk Stok Opname di Gudang Cresta Management. Saturnus: Jurnal Teknologi dan Sistem Informasi. 2026;4(2).

Artikel Terkait

Rancang Bangun Website BUMDes Kabupaten Cilacap Menggunakan Metode Scrum

Tazakka Pribadi, Fadhil; Intan Surya Saputra, Dhanar

Sistem Informasi Penyaluran Bantuan langsung Tunai (BLT) Dana Desa pada Kecamatan Alu Berbasis WEB

Harlin Harlin; Basri Basri; Sapriadi Sapriadi

Sistem Informasi Geografis untuk Pemilihan Lokasi Terdekat ATM pada Wilayah Kecamatan Wonomulyo Berbasis Web

Muh Sadik; Reski Idrus; Basri Basri; Noer Ekafitri Sam

Sistem Informasi Masjid Imam Malik Koppe Menggunakan Fasilitas Platform Emasjid

Muhtar Muhtar; Eka Fitrisam; Reski Idrus; Basri Basri

Sistem Informasi Pengelolaan Kegiatan Perpustakaan Samatutu pada Desa Jambu Malea Berbasis Web

Fitriani Fitriani; Basri Basri; Kamaluddin Kamaluddin

Evaluasi Usability Sistem E-Voting Menggunakan System Usability Scale Pasca Perancangan Ulang Antarmuka

David Sam Limbong; Hermawan Setiawan; Satria Tegar Bimantara; Reza Ardiansyah Yudhanegara
Tren Sitasi Jurnal