Hello everyone!
Today I am going to explain you about my new project. In this project, I will be logging health measurements to Google Sheet. This is a prototype. This project will be more efficient when accurate heart beat and temperature sensors are used to take measurements. The google sheet can be shared with your doctor, who can monitor your measurements to give you proper treatment from afar.
Hardware components used in this project
- NodeMCU devkit V1.0
- Solderless Breadboard - Full +
- DS18B20 Temperature sensor module (You can also use an LM-35 temperature sensor)
- Heart Beat sensor module (KY-039)
- Two colour LED module (KY-011)
- IR sensor module
- Push-buttons (x2)
- Resistors (x2) - 10kΩ
- Male-to-Male Jumper wires - 10cm and 20cm
- Jumpers (to reduce the usage of wires)
Softwares and online services
- Arduino IDE
- PushingBox
- Google Sheets
Hardware setup
Your hardware setup must look somewhat similar to that in the pictures above.
Connections
Heart beat sensor module (KY-039)
- S - A0
- (+) - 5V
- (-) - Ground (GND)
DS18B20 Temperature sensor module
- S - D1
- (+) - 5V
- (-) - Ground (GND)
Two colour LED module (KY-011)
- Red - D2
- Green - D3
- (-) - Ground (GND)
IR sensor module
- S - D4
- (+) - 5V
- (-) - Ground (GND)
Push-button 01 (for Heart beat sensor module)
- S - D6
- (+) - 5V
- (-) - Ground (GND)
Push-button 02 (for Temperature sensor module)
- S - D7
- (+) - 5V
- (-) - Ground (GND)
Coding
The coding will be similar to that of my previous project (IoT Weather station using Arduino). You will be needing the PushingBox online service to act as a trigger to send the data from your NodeMCU microcontroller to the Google sheets.
To measure the heart rate you can use the pulsesensor library by WorldFamousElectronics. If you want more accurate measurements, you could also measure the heart rate using your own functions.
To measure the temperature, I have used OneWire library by Stoffregen and Arduino Temperature control library by Miles Burton.
Google sheet
- You will be needing your gmail address to create a spreadsheet in google sheets.
- Enter your column headings which will be Date and Time, Heart Rate (in BPM), Temperature (in °C) and Temperature (in °F).
- Copy and save your spreadsheets URL key which will be found in the URL between "/d/" and "/edit".
- Go to tools and click on 'Script Editor'.
- The code which will be included in your Gscript is given in the original project. The only change in the codes will be to use 3 cases for the hData, celData and fehrData.
- Save the script
- Deploy as a web app. At first, Google will send you a warning saying that it is unauthorized but it's okay because you are the author.
- Save the web app URL
PushingBox
- Login with your gmail account
- Create a new service by selecting 'CustomURL'
- The root URL within the customURL configuration will be the web app URL saved in the previous step.
- Select 'GET' method
- Now, you must create a scenario using this service.
- For 'GET' method, the statement begins with '?'
- Save your Device ID.
Test your API by typing this statement into your browser's address bar:
http://api.pushingbox.com/pushingbox?devid="Your device ID"&hData=76&celData=33&fehrData=91.4
You only have 100 requests per day.Arduino
Refer to this tutorial to get familiar with the DS18B20 temperature sensor module.
https://randomnerdtutorials.com/guide-for-ds18b20-temperature-sensor-with-arduino/
You can use the 'Getting_BPM_to_Monitor' sketch from the library's examples folder to learn how the heart rate is measured. Before using this sketch, you should use the 'Getting Started' sketch to measure the threshold value.
Watch the youtube video in the last section of this page to see how this project works. I have debounced my push-buttons so that once you press them, you can take the measurements and after you take the proper measurements, you can press it again to record the values.
The IR sensor usually sends a LOW signal when it detects an object, so hovering over the IR sensor should send the recorded values to pushingbox and the values will be logged in Google sheets.
The IR sensor usually sends a LOW signal when it detects an object, so hovering over the IR sensor should send the recorded values to pushingbox and the values will be logged in Google sheets.
If anyone has any questions about the coding, please feel free to comment below or send me an email at arduinoprojectsbyr@gmail.com.
Final Look
If anyone has any questions or suggestions about this project, please feel free to comment below or send me an email at arduinoprojectsbyr@gmail.com.
Comments
Post a Comment