IoT Pressure Sensor: MKR GSM + Arduino Cloud + Google Sheets

IoT device to remotely monitor pressure (0-150 psi) using cellular data. Get notifications for pressures above/below high/low set-points.

Sep 19, 2019

•

28320 views

•

29 respects

Components and supplies

1

DHT22 Temperature & Humidity Sensor

1

DS3231 RTC Module

2

3.7V LiPo Battery (2000 mAh or greater)

1

Arduino UNO

1

Basic Starter Kit with Assorted LEDs & Resistors

1

Logic Level Converter - BSS138 - 4-channel I2C-safe Bi-directional

1

Voltage Step-up Converter

1

Breadboard (generic)

1

Pressure Transducer (0-150 psi)

1

Arduino MKR GSM 1400

Apps and platforms

1

Google Sheets

1

Arduino IoT Cloud

1

Arduino IDE

1

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

hi? can i replace Arduino MKR1400 with Arduino MKR1000? what is the different?

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.