Temp/Humidity Data Analysis Using Ubidots and Google-Sheets

In this tutorial, we will measure different temperature and humidity data using temperature and humidity sensor. You will also learn how to send this data to Ubidots. So that you can analyze it from anywhere for different application. Also by sending this data to google sheets predictive analysis can be achieved.

Hardware

• ESP-32: The ESP32 makes it easy to use the Arduino IDE and the Arduino Wire Language for IoT applications. This ESp32 IoT Module combines Wi-Fi, Bluetooth, and Bluetooth BLE for a variety of diverse applications. This module comes fully-equipped with 2 CPU cores that can be controlled and powered individually, and with an adjustable clock frequency of 80 MHz to 240 MHz. This ESP32 IoT WiFi BLE Module with Integrated USB is designed to fit in all ncd.io IoT products.Monitor sensors and control relays, FETs, PWM controllers, solenoids, valves, motors and much more from anywhere in the world using a web page or a dedicated server.We manufactured our own version of the ESP32 to fit into NCD IoT devices, offering more expansion options than any other device in the world! Integrated USB port allows easy programming of the ESP32. The ESP32 IoT WiFi BLE Module is an incredible platform for IoT application development. This ESP32 IoT WiFi BLE Module can be programmed using Arduino IDE.
• IoT Long Range Wireless Temperature and Humidity Sensor: Industrial Long Range Wireless Temperature Humidity Sensor. Grade with a Sensor Resolution of ±1.7%RH ±0.5°C.Up to 500, 000 Transmissions from 2 AA Batteries.Measures -40°C to 125°C with Batteries that Survive these Ratings.Superior 2-Mile LOS Range & 28 miles with High-Gain Antennas. Interface to Raspberry Pi, Microsoft Azure, Arduino and more.
• Long Range Wireless Mesh Modem with USB Interface

Software Used

• Arduino IDE
• Ubidots

Library Used

• PubSubClient Library
• Wire.h

Arduino Client for MQTT

This library provides a client for doing simple publish/subscribe messaging with a server that supports MQTT.

For more information about MQTT, visit mqtt.org.

Download

The latest version of the library can be downloaded from GitHub

Documentation

The library comes with a number of example sketches. See File > Examples > PubSubClient within the Arduino application.Full API Documentation.

Compatible Hardware

The library uses the Arduino Ethernet Client api for interacting with the underlying network hardware. This means it Just Works with a growing number of boards and shields, including:

• Arduino Ethernet
• Arduino Ethernet Shield
• Arduino YUN – use the included YunClient in place of EthernetClient, and be sure to do a Bridge.begin() first
• Arduino WiFi Shield - if you want to send packets greater than 90 bytes with this shield, enable the MQTT_MAX_TRANSFER_SIZE option in PubSubClient.h.
• Sparkfun WiFly Shield – when used with this library
• Intel Galileo/Edison
• ESP8266
• ESP32The library cannot currently be used with hardware based on the ENC28J60 chip – such as the Nanode or the Nuelectronics Ethernet Shield. For those, there is an alternative library available.

Wire Library

The Wire library allows you to communicate with I2C devices, often also called "2 wire" or "TWI" (Two Wire Interface), can download from Wire.h

Basic Usage

• Wire.begin()Begin using Wire in master mode, where you will initiate and control data transfers. This is the most common use when interfacing with most I2C peripheral chips.
• Wire.begin(address)Begin using Wire in slave mode, where you will respond at "address" when other I2C masters chips initiate communication.

Transmitting

• Wire.beginTransmission(address)Start a new transmission to a device at "address". Master mode is used.
• Wire.write(data)Send data. In master mode, beginTransmission must be called first.
• Wire.endTransmission()In master mode, this ends the transmission and causes all buffered data to be sent.

Receiving

• Wire.requestFrom(address, count)Read "count" bytes from a device at "address". Master mode is used.
• Wire.available()Retuns the number of bytes available by calling receive.
• Wire.read()Receive 1 byte.

Steps to send data to LabVIEW temperature and humidity platform using IoT Long Range Wireless Temperature and Humidity Sensor and Long Range Wireless Mesh Modem with USB Interface:

• First, we need a Labview utility application which is ncd.io Wireless Temperature And Humidity Sensor.exe file on which data can be viewed.
• This Labview software will work with ncd.io wireless Temperature sensor only
• To use this UI, you will need to install following drivers Install run time engine from here 64bit
• 32 bit
• Install NI Visa Driver
• Install LabVIEW Run-Time Engine and NI-Serial Runtime
• Getting started guide for this product.

Uploading the Code to ESP32 Using Arduino IDE

• Download and include the PubSubClient Library and Wire.h Library.
• You must assign your unique Ubidots TOKEN, MQTTCLIENTNAME, SSID (WiFi Name) and Password of the available network.
• Compile and upload the temp_humidity.ino code.
• To verify the connectivity of the device and the data sent, open the serial monitor.If no response is seen, try unplugging your ESP32 and then plugging it again. Make sure the baud rate of the Serial monitor is set to the same one specified in your code 115200.

Serial Monitor Output

Making the Ubidots Work

• Create the account on Ubidots
• Go to my profile and note down the token key which is a unique key for every account and paste it to your ESP32 code before uploading.
• Add a new device to your ubidot dashboard name ESP32.

 Click on devices and select devices in ubidot.

 Now you should see the published data in your Ubidots account, inside the device called "ESP32".

• Inside device create new variable name sensor in which your temperature reading will be shown.

Now you are able to view the Temperature and other sensors data which was previously viewed in serial monitor .This  happened because the value of  different sensor readings  is passed as a string and store in variable and publish to variable inside  device esp32. 

Create Dashboard in Ubidots

• Click on add new dashboard.

• Name your dashboard.

• Now select Widget.

• Now select all required option and your widget will create.On which you can view your temp and humidity data.

Output

Export Your Ubidots Data to Google Sheets

In this we can extract the data stored in the Ubidots cloud for further analysis. The possibilities are enormous; for instance, you could create an automatic report generator and send it to your customers every week.

Another application would be device provisioning; if you have thousands of devices to deploy, and their information is in a Google Sheet, you could create a script to read the sheet and create a Ubidots data source for every line on the file.

Steps to do this:

• Create a Google Sheet and add two sheets to it with these names:
• Variables
• Values
• From your Google Sheet, click on "Tools" then "Script Editor...", then "Blank Project":
• Open the Script Editor:

• Add the code below (in the code section) to the script Script.
• Also add the Token Id, device Id taken from your Ubidots account to the following code.

• Done! now open your Google Sheet again and you'll see a new menu to trigger the functions.

Result