ORP Water Quality Detector Creating Data Charts in Google Sheets w/ SIM808

1 Arduino Uno
1 Gravity: Analog ORP Sensor Meter
1 SIM808 GPS/GPRS/GSM Shield For Arduino
1 3-wire Serial LCD Module
1 Analog joystick
1 Battery (7V - 23V)
1 SIM Card
1 Jumper wires


During these unprecedented times, the COVID-19 pandemic, preserving and supporting our immune system is one of the most crucial precautions of protecting ourselves from the severe effects of the coronavirus, as for any other disease caused by viruses or bacteria. Although there are complex elements and processes which are keeping our immune system healthy, I wanted to focus on a dangerous and ubiquitous problem that causes immunodeficiency worldwide - water pollution. But how does water pollution (bad water quality) cause immunodeficiency?

First of all, water pollution harms animals, plants, and the environment. In that regard, it causes immunodeficiency indirectly by devastating food sources, and therefore nutrients: "Historical accounts and recent epidemiologic studies have suggested a mutually aggravating relationship between malnutrition and infection. In protein-energy malnutrition, there is a significant impairment of several aspects of immunity, including cell-mediated immune responses, secretory immunoglobulin A antibody production, phagocyte function, complement system, antibody affinity, and cytokine production. Several micronutrients play a crucial role in the maintenance of optimum immune responses(1)."

Also, contaminated water sources may instigate defects with immunomodulation (regulatory adjustment of the immune system) by effecting the beneficial commensal bacteria in the human body. "Commensal bacteria, in particular, are key participants in the digestion of food, and are responsible for the extraction and synthesis of nutrients and other metabolites that are essential for the maintenance of mammalian health. Many of these nutrients and metabolites derived from commensal bacteria have been implicated in the development, homeostasis and function of the immune system, suggesting that commensal bacteria may influence host immunity via nutrient- and metabolite-dependent mechanisms(2)."

Aside from obliterating the benefits of nutrients and commensal bacteria, unreliable drinking water sources with bad quality can infect the human body with microorganisms causing immunodeficiency: "Recent evidence suggests that many improved drinking water supplies suffer from poor reliability. A Quantitative Microbiological Risk Assessment was conducted on the impact of interruptions in water supplies that forced people to revert to drinking raw water. Data from the literature were used to construct models on three waterborne pathogens common in Africa: Rotavirus, Cryptosporidium and Enterotoxigenic E. coli. Risk of infection by the target pathogens is substantially greater on days that people revert to raw water consumption. Over the course of a few days raw water consumption, the annual health benefits attributed to consumption of water from an improved supply will be almost all lost. Furthermore, risk of illness on days drinking raw water will fall substantially on very young children who have the highest risk of death following infection(3)."

Considering the possibilities, detecting water quality to prevent water pollution from hurting our immune system is of great importance, especially during a pandemic. And, it is salient to determine polluted water sources correctly after detecting water quality. As WHO says, "In order to determine which constituents are, indeed, of concern, it will be necessary to undertake a drinking-water quality assessment. It is important to identify what types of drinking-water systems are in place in the country (e.g., piped water supplies, non-piped water supplies, vended water) and the quality of drinking-water sources and supplies. Additional information that should be considered in the assessment includes catchment type (protected, unprotected), wastewater discharges, geology, topography, agricultural land use, industrial activities, sanitary surveys, records of previous monitoring, inspections and local and community knowledge. The wider the range of data sources used, the more useful the results of the process will be(4)."

Especially for developing and third-world countries, tracking the water quality to detect the contaminated and polluted water sources is remaining as a big problem due to the high-cost detectors and lack of consistent data. And thus, I contemplated this project as a low-cost water quality detector sending data (water quality) to Google Sheets to create data charts (spreadsheets) by location (GPS), available working in any field as long as GSM network provided and enabled.

To detect the water quality, I chose to use an ORP sensor sponsored by DFRobot. ORP (Oxidation-Reduction Potential) is a measure of the ability of oxidation and reduction of an aqueous solution, which the relative degree of oxidizing or reducing. The unit is mV. If the oxidation-reduction potential is high, then chemical oxidation is strong. But if the potential is low, then oxidation is weaker. The positive potential indicates that the solution shows a certain degree of oxidation: while the negative potential means that solution shows a certain degree of reduction. Oxidation-reduction potential (ORP) can be used to detect water contamination with the benefit of a single-value measure of the disinfection potential, showing the activity of the disinfectant rather than the applied dose. For example, E. coli, Salmonella, Listeria, and other pathogens have survival times of under 30 seconds when the ORP is above 665 mV, compared against 300 seconds when it is below 485 mV(5).

To elicit the GSM information and send data over GPRS, I used a SIM808 GSM/GPS/GPRS Shield sponsored by DFRobot. If the GSM network is provided and enabled, the SIM808 is able to send data by making a GET or POST request to a server in any field. In that regard, the water quality detector lets the user collect data (water quality) even outdoors.

And lastly, I developed a webhook, which will be explained later, in PHP to create a spreadsheet and corroborating data chart in the Google Sheets in the hope of detecting unreliable water sources with consistent water quality dataset by location.

Sponsored products by DFRobot:

- Gravity: Analog ORP Sensor Meter For Arduino | Inspect

- SIM808 GPS/GPRS/GSM Shield For Arduino | Inspect

To view all steps and code files, please click here.

All Rights