Preprint / Version 1

Microcontroller – Based Fish Freshness Detection Device With Google Sheet Integration

Alat Pendeteksi Kesegaran Ikan Berbasis Mikrokontroler dengan Integrasi Google Sheet

##article.authors##

DOI:

https://doi.org/10.21070/ups.10953

Keywords:

ammonia sensor, ESP32, real-time monitoring, digital logging, fish freshness

Abstract

Indonesia is one of the world’s major fish-producing countries, and common carp (Cyprinus carpio) is an important freshwater fish for daily consumption. However, fish spoilage occurs quickly after harvest, especially at room temperature, due to microbial activity. This study developed a fish freshness detection system using an MQ-135 ammonia sensor and a TCS3200 color sensor connected to an ESP32 microcontroller. The system measures ammonia concentration and RGB color values to classify fish freshness into fresh, less fresh, and spoiled categories using threshold analysis. Experimental results showed ammonia levels increased from 0.60 ppm to 15.63 ppm as spoilage progressed. The data were also transmitted in real time to Google Sheets for digital monitoring and documentation. The findings revealed that ammonia concentration is a more effective freshness indicator than visual color changes. Overall, the proposed system provides a simple, low-cost, and practical solution for supporting fish quality control in small-scale fisheries MSMEs.

Downloads

Download data is not yet available.

References

A. Suharsono and T. Irschlinger, “Fuel Subsidies to Marine Fisheries in Indonesia: An overview,” 2022.

D. A. C. Rasmi, P. Sedijani, and D. Y. Sativa, “Ayo Penuhi Zat Gizi Protein Dengan Konsumsi Ikan,” J. Pengabdi. Magister Pendidik. IPA, vol. 6, no. 4, pp. 1348–1352, 2023, [Online]. Available: https://doi.org/10.29303/jpmpi.v6i4.6679

D. F. Ismuaji, “Pendederan III Ikan Mas Marwana (Cyprinus carpio),” pp. 1–8, 2023.

N. Gajah, E. S. Lubis, A. Arifana, E. L. Roito, H. Harahap, and M. Simamora, “Dampak Eksistensi Kampung Budidaya Ikan Mas

Terhadap Kehidupan Sosial Ekonomi Masyarakat Desa Sibulele Muara Kecamatan Batang Angkola,” J. Ilm. Muqoddimah J. Ilmu Sos. Polit. dan Hum., vol. 9, no. 1, p. 506, 2025, doi: 10.31604/jim.v9i1.2025.506-515.

I. Anshory, I. Sulistiyowati, and L. Hudi, “Technology diffusion: Application of slicer machine in making milkfish crackers in Kampung Tambak Asri, Surabaya,” Community Empower., vol. 8, no. 6, pp. 863–867, 2023, doi: 10.31603/ce.9144.

A. Nurul Aisyah, D. N. Setyowati, and B. H. Astriana, “Potensi Pemanfaatan Daun Singkong (Manihot Utilissima) Terfermentasi Sebagai Bahan Pakan Untuk Meningkatkan Pertumbuhan Ikan Mas (Cyprinus Carpio) Potential Utilization Of Fermented Cassava (Manihot Utilissima) Leaves As Feed Ingredients To Increase Growt,” J. Perikan. , vol. 11, no. 1, pp. 13–25, 2021.

B. Agam et al., “Penyuluhan Manfaat Mengonsumsi Ikan Pada Siswa Di Pondok Pesantren Al-Amin Sungai Kelambu,” J. Pengabdi. Masy. Bangsa, vol. 2, no. 9, pp. 3889–3896, 2024, doi: 10.59837/jpmba.v2i9.1578.

Y. Putri Rahayu, “Kaitan Omega-3 dengan Tumbuh Kembang Otak Diserahkan Untuk Memenuhi Tugas Individu,” pp. 1–7, 2022.

N. Lubis, Y. Srirahayu, and E. C. Junaedi, “Nitrogen cair the nutritional value of goldfish ( Cyprinus carpio ) after freezing,”

Edufortech, vol. 9, no. 2, pp. 137–145, 2024.

D. Kuncoro, “Analisis Risiko Distribusi Makanan Olahan Beku Di Pt. Salimah Prima Cita, Tangerang Selatan,” p. Fakultas Sains dan Teknologi. Jakarta: Universitas, 2020.

G. D. K. Sandi, D. Syauqy, and R. Maulana, “Sistem Pendeteksi Kesegaran Ikan Bandeng Berdasarkan Bau Dan Warna Daging Berbasis Sensor MQ135 Dan TCS3200 Dengan Metode Naive Bayes,” J. Pengemb. Teknol. Inf. dan Ilmu Komput., vol. 3, no. 10, pp. 10110–101117, 2020.

I. Ghali-Mohammed et al., “Food safety knowledge and attitudes among fish vendors in informal markets in Ilorin, Nigeria: a cross- sectional study,” Discov. Food, vol. 4, no. 1, 2024, doi: 10.1007/s44187-024-00232-2.

D. Eka P, “No 主観的健康感を中心とした在宅高齢者における健康関連指標に関する共分散構造分析Title,” vol. 2, no. 4, pp. 1147–1152, 2021.

M. F. Mansyur, M. F. Rustan, and W. Syarifuddin, “Pendeteksi Kesegaran Ikan menggunakan Sensor MQ-135,” J. Comput. Inf. Syst. ( J-CIS ), vol. 5, no. 2, pp. 49–58, 2022, doi: 10.31605/jcis.v5i2.2405.

S. Syahrorini, D. Syamsudin, D. H. R. Saputra, and A. Ahfas, “K-Nearest Neighbor Algorithm to Identify Cucumber Maturity with Extraction of One-Order Statistical Features and Gray-Level Co-Occurrence,” IOP Conf. Ser. Earth Environ. Sci., vol. 819, no. 1, pp. 0–6, 2021, doi: 10.1088/1755-1315/819/1/012010.

M. Sholihin, “Identifikasi Kesegaran Ikan Berdasarkan Citra Insang dengan Metode Convolution Neural Network,” JATISI (Jurnal Tek. Inform. dan Sist. Informasi), vol. 8, no. 3, pp. 1352–1360, 2021, doi: 10.35957/jatisi.v8i3.939.

R. AZZAHRA and G. Setyawan, “Perbandingan Kinerja Sensor Mq135 Pada Pendeteksian Gas Amonia Sampel Uji Menggunakan Atmega 2560,” vol. 70000, pp. 17–23, 2021.

S. Sugiarto and S. Supadi, “Analysis of Digital Archive Management Using Google Spreadsheets in the Educators and Education Personnel Section of the Education Office,” Lembaran Ilmu Kependidikan, vol. 53, no. 2, pp. 284–292, 2024, doi: 10.15294/lik.v53i2.11914.

P. Data, M. Rw, and K. Cilayung, “Pemanfaatan Google Spreadsheet Sebagai Media,” J. EKBIS ( Ekon. Bisnis ) Politek. Piksi Ganesha, vol. 48, no. Desember, pp. 1–7, 2021.

Hasnawati, Muh. Fuad Mansyur, and Chairi Nur Insani, “Deteksi Kesegaran Ikan Selar menggunakan Sensor Warna Dan Sensor Gas Berbasis Web,” J. Comput. Inf. Syst. ( J-CIS ), vol. 6, no. 1, pp. 37–44, 2023, doi: 10.31605/jcis.v6i1.3588.

Posted

2026-05-12