Melola Discovery

← Melola Discovery

Journal

IMPLEMENTATION OF INTERNET OF THINGS (IoT) BASED ON GOOGLE SHEETS FOR WATER QUALITY MONITORING SYSTEM

JOURNAL ONLINE OF PHYSICS · Vol. 9 No. 1 (2023) · pp. 85–89

DOI
10.22437/jop.v9i1.28689
ISSN
2502-2016
Published
2023-11-02
Publisher
Prodi Fisika FST UNJA
Language
en

Abstract

Temperature, pH, and TDS are important indicators of water quality that affect various aspects. This research aims to develop a water quality monitoring system by implementing Internet of Things (IoT) technology based on Google Sheets. Based on the tests for each sensor - temperature, pH, and TDS - the results show that the system has an excellent level of measurement precision, with an average precision value of above 95%. The findings also indicate that Google Sheets can be utilized in IoT technology and can operate on more than one distinct computer device at the same time. The use of Google Sheets in IoT technology is highly effective, flexible, and user-friendly. The measured data can be automatically stored and can be visualized effectively.".

Keywords

Collaboration network of the authors

40 authors · 158 co-authorship links · showing the 40 most connected

Hover or tap a name to highlight its co-authors. Double-click to open the author's page.

  • Universitas Muslim Indonesia
  • Universitas Gadjah Mada
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
Samsidar SamsidarUniversitas Muslim Indonesia10
Rustan RustanAffiliation unknown10
Yoza FendrianiAffiliation unknown9
Mardian PeslinofAffiliation unknown9
M. Ficky AfriantoAffiliation unknown7
Pradita Eko Prasetyo UtomoUniversitas Gadjah Mada6
Frastica DeswardaniAffiliation unknown6
Tika RestianingsihAffiliation unknown6
RustanAffiliation unknown5
Maison MaisonAffiliation unknown5
Ardiyaningsih Puji LestariAffiliation unknown5
Alrizal AlrizalAffiliation unknown4
. SamsidarAffiliation unknown4
Faizar FaridAffiliation unknown3
Novita SariAffiliation unknown2
Sigit IndrawijayaAffiliation unknown2
Ardiyaningsih Puji LestariAffiliation unknown2
Tedjo SukmonoAffiliation unknown2
Tia WulandariAffiliation unknown2
Cindy Nur SyaqilaAffiliation unknown2
Ilham Jaya WindhanuAffiliation unknown2
Ade OctaviaAffiliation unknown2
Fitriyanti Retno SiwiAffiliation unknown1
Buhaira BuhairaAffiliation unknown1
Fairuz Athaya zahran Tane TaneAffiliation unknown1
Nurhidayah NurhidayahAffiliation unknown1
M. Ficky ApriantoAffiliation unknown1
Nurhidayah NurhidayahAffiliation unknown1
Nurhidayah NurhidayahAffiliation unknown1
Rista Mutia AnggrainiAffiliation unknown1
Nurhidayah NurhidayahAffiliation unknown1
Revis AsraAffiliation unknown1
Ade Adriadi AdriadiAffiliation unknown1
Hasnaul MaritsaAffiliation unknown1
Defrizal DefrizalAffiliation unknown1
Sugih SuhartiniAffiliation unknown1

Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.

Metadata source: OAI-PMH (metadata jurnal) https://online-journal.unja.ac.id/index.php/jop/oai, first harvested 6 Nov 2026, last seen 8 Nov 2026.
Original metadata (oai_dc) 
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/  http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
	<dc:title xml:lang="en">IMPLEMENTATION OF INTERNET OF THINGS (IoT) BASED ON GOOGLE SHEETS FOR WATER QUALITY MONITORING SYSTEM</dc:title>
	<dc:creator xml:lang="en">Pebralia, Jesi</dc:creator>
	<dc:creator xml:lang="en">Handayani, Linda</dc:creator>
	<dc:creator xml:lang="en">Suprayogi, Dawam</dc:creator>
	<dc:creator xml:lang="en">Amri, Iful</dc:creator>
	<dc:subject xml:lang="en">Google sheet</dc:subject>
	<dc:subject xml:lang="en">Internet of Things (IoT)</dc:subject>
	<dc:subject xml:lang="en">pH</dc:subject>
	<dc:subject xml:lang="en">TDS</dc:subject>
	<dc:subject xml:lang="en">Temperature</dc:subject>
	<dc:description xml:lang="en">Temperature, pH, and TDS are important indicators of water quality that affect various aspects. This research aims to develop a water quality monitoring system by implementing Internet of Things (IoT) technology based on Google Sheets. Based on the tests for each sensor - temperature, pH, and TDS - the results show that the system has an excellent level of measurement precision, with an average precision value of above 95%. The findings also indicate that Google Sheets can be utilized in IoT technology and can operate on more than one distinct computer device at the same time. The use of Google Sheets in IoT technology is highly effective, flexible, and user-friendly. The measured data can be automatically stored and can be visualized effectively.".</dc:description>
	<dc:publisher xml:lang="en">Prodi Fisika FST UNJA</dc:publisher>
	<dc:date>2023-11-02</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://online-journal.unja.ac.id/jop/article/view/28689</dc:identifier>
	<dc:identifier>10.22437/jop.v9i1.28689</dc:identifier>
	<dc:source xml:lang="en">JOURNAL ONLINE OF PHYSICS; Vol. 9 No. 1 (2023): JOP (Journal Online of Physics) Vol 9 No 1; 85-89</dc:source>
	<dc:source>2502-2016</dc:source>
	<dc:language>en</dc:language>
	<dc:relation>https://online-journal.unja.ac.id/jop/article/view/28689/16636</dc:relation>
	<dc:rights xml:lang="en">Copyright (c) 2023 JOURNAL ONLINE OF PHYSICS</dc:rights>
</oai_dc:dc>