Components and supplies
DHT22 Temperature & Humidity Sensor
DS3231 RTC Module
3.7V LiPo Battery (2000 mAh or greater)
Arduino UNO
Basic Starter Kit with Assorted LEDs & Resistors
Logic Level Converter - BSS138 - 4-channel I2C-safe Bi-directional
Voltage Step-up Converter
Breadboard (generic)
Pressure Transducer (0-150 psi)
Arduino MKR GSM 1400
Apps and platforms
Google Sheets
Arduino IoT Cloud
Arduino IDE
Arduino Web Editor
Project description
Code
InstrumentReader - Sketch for Arduino Uno
arduino
InstrumentReader - Sketch for Arduino Uno
arduino
GoogleSheetsScript.js
javascript
Downloadable files
Schematic
Schematic
Schematic
Schematic
Comments
Only logged in users can leave comments
Anonymous user
2 years ago
Great Project, I'm working on using Google sheets in tandem with a ESP8266 so I think this will give me some idea's of how to get the data where i need it.
Anonymous user
2 years ago
Amazing project!!! Thanks for sharing. I'd like to know what did you use to test the pressure output. I can see that you used an analogic pressure gauge. Can you lst the other components and if possible share where can i find them?
Anonymous user
2 years ago
Hi Wahltharvey, I am currently trying to replicate this project, I have bought all the required items and electrical components needed already. However, while setting up my first few prototypes, I realized that my Arduino UNOs were getting fried, any idea on where in my setup might be going wrong? Also am i able to carry out this project without using the voltage step up converter? Is there any other way to contact you such as your email, I have many more queries.
Anonymous user
2 years ago
Is it possible using only one MKR GSM 1400?
wahltharvey
2 years ago
This is a tough question. The short answer is yes. It is possible. If you search for ways to read values from a 5V sensor with a board that runs at 3.3V you’ll find several options.
Anonymous user
2 years ago
Quite impressive. I was planning a project where a reading is taken every 24 hours and a text sent. A rtc will turn it on with a mosfet once per day. I am hoping for a year or more. I could not figure out how to use the cloud. I will look at your work to learn this. Thank you - great job
Anonymous user
2 years ago
An amazing project and very helpful, full of info that can be used with other projects with a similar outcomes. thanks for sharing
Anonymous user
3 years ago
hi? can i replace Arduino MKR1400 with Arduino MKR1000? what is the different?
firasayyash
3 years ago
An amazing project and very helpful, full of info that can be used with other projects with a similar outcomes. thanks for sharing
Anonymous user
4 years ago
Hi Wahltharvey, I am currently trying to replicate this project, I have bought all the required items and electrical components needed already. However, while setting up my first few prototypes, I realized that my Arduino UNOs were getting fried, any idea on where in my setup might be going wrong? Also am i able to carry out this project without using the voltage step up converter? Is there any other way to contact you such as your email, I have many more queries.
airestoni
4 years ago
Amazing project!!! Thanks for sharing. I'd like to know what did you use to test the pressure output. I can see that you used an analogic pressure gauge. Can you lst the other components and if possible share where can i find them?
Anonymous user
5 years ago
Quite impressive. I was planning a project where a reading is taken every 24 hours and a text sent. A rtc will turn it on with a mosfet once per day. I am hoping for a year or more. I could not figure out how to use the cloud. I will look at your work to learn this. Thank you - great job
achanalb
5 years ago
Hi wahltharvey, thanks for the tutorial. I am currently stuck at step 4 to get my google sheet updated using webhooks. I tried your google script and the one you referenced from the other tutorial but no success so far. I have been adjusting the COMM_TIME to see if my wifi signal plays a role into it, and published a new version when I made an update. Were you having issues to see the sheet updating in real-time when you first started? Or is this webhooks feature only available for maker plan users? Thanks in advance!
wahltharvey
2 years ago
Is new data from your device showing up on the dashboard in the Arduino Cloud, and it is not populating in your Google Sheets file? If yes, I had trouble there too when I was getting started. Your Google Sheets file should show new data every time new data shows up on the dashboard in the Arduino Cloud. If your Google Sheets file is not updating odds are that there is something wrong in the script. I'd recommend going through step 4 in this project again using an exact copy of the code. Another potential issue is that the name of the sheet in your code does not match the name of one of the sheets in your Google Sheets file. If you are using an exact copy of the code make sure that one of the sheets in your Google Sheets file is named "RawData". The exact name isn't important as long as it matches what is in your code. Part of what makes this difficult is that there is not a simple way to see the data being output to the webhook. It would be convenient if the most recent JSON object was displayed on the webhook tab in the Arduino Cloud. Since that is not available, if you're interested in seeing what the JSON object looks like I'd recommend setting up a webhook on Zapier. It allows you to do a generic setup that will display the actual data coming from the Arduino Cloud.
viktor_laitinen
5 years ago
Is it possible using only one MKR GSM 1400?
wahltharvey
2 years ago
This is a tough question. The short answer is yes. It is possible. If you search for ways to read values from a 5V sensor with a board that runs at 3.3V you’ll find several options.
Anonymous user
5 years ago
Great Project, I'm working on using Google sheets in tandem with a ESP8266 so I think this will give me some idea's of how to get the data where i need it.
Anonymous user
2 years ago
hi? can i replace Arduino MKR1400 with Arduino MKR1000? what is the different?