Sending IoT Long Range Wireless Temperature and Humidity Sensor Data to Google Sheet

We are using here NCD's Temperature and Humidity sensor, but the steps stay the equal for any of the ncd product, so if you have other ncd wireless sensors, experience free to observe alongside besides. By means of the stop of this text, you need to have a stable understanding of how to set up the sensors, configure node-red, and see the data on a dashboard like the one pictured right here.

Step 1: Hardware and Software Required:

Hardware:

Software:

Node-Red

Step 2: Setting Up Node-red

Now that you have sensors running, we need a way to do something useful with that data.

First of all, you'll have to install Node-Red.

Once that’s done, you’ll need to enter your command line, or Power Shell for Windows users, navigate to the directory Node-RED is installed in.
Now type “npm i ncd-red-wireless node-red-dashboard“. This will install the nodes required to receive data from your wireless sensors and you can start Node-RED once this is done.
To start node server write node-red in the command prompt or terminal and press enter.

Step 3: Steps to Create the Flow

At this point you’ll be viewing a large blank flow with a long list of nodes on the left-hand side, this sidebar is called the palette.

Step 4: Go Ahead and Drag a Wireless Gateway Node Over to Your Flow Canvas to Get Started.

ncd-red-wireless Provides the nodes that manage the serial connection, parse incoming sensor data, filter it by specific parameters, and allow you to configure the wireless sensors.

Step 5: Finding Your Wireless Sensors:

When you’ve delivered the node you’ll be able to view the info tab, which contains records about the node’s capability, this tab is well-populated for maximum node-red packages and consists of treasured statistics, often you will now not want to view any other documentation outdoor of the info tab, so hold it in thoughts even as you're building your flows when you have a question approximately how a node works. The next element we want to do is configure the node, when you first add it you’ll note that there is a small triangle at the top right corner next to a blue dot, the triangle indicates that the node wishes extra configuration, the blue dot indicates that the node has no longer but been deployed as part of the flow.

Double click on the node to open up the configuration options.
Click on the pencil icon next to the Serial Device field to configure your USB router, this will open a second configuration panel that only has a few options.

Step 6: Click on the Magnifying Glass Next to the Serial Port Field and Select the Port That Corresponds With Your Router, Then Click the “Add” Button on Top.

Click on the Magnifying Glass Next to the Serial Port Field and Select the Port That Corresponds With Your Router, Then Click the “Add” Button on Top.

Step 7: Serial Device Field Will Now Be Populated Based on That Selection, and You Can Click “Done”, You Now Have Direct Access to Your Wireless Sensors! to View the Data Coming In.

Serial Device Field Will Now Be Populated Based on That Selection, and You Can Click “Done”, You Now Have Direct Access to Your Wireless Sensors! to View the Data Coming In.

Step 8: Now Go Back to Your Palette and Type “debug” Into the Search Field at the Top, Grab One of These Nodes and Drag It to the Right of Your Wireless Gateway

Now Go Back to Your Palette and Type “debug” Into the Search Field at the Top, Grab One of These Nodes and Drag It to the Right of Your Wireless Gateway

Step 9: Double Click on It and Change “msg.” to “complete Msg Object” Click Done

Step 10: Now Draw a Line Between the Two Nodes, and Click “Deploy” on the Top Right of the Window..

Step 11: Working With the Data:

Now out of your wireless sensors data is gathered and it is output to the “debug” tab, this "debug tab" is placed within the right sidebar subsequent to the information tab. To see the information is available to hit the reset button. In node-red records is surpassed among nodes in a json packet. When the msg object comes into the debug tab you may make bigger it to view the overall list of information that comes with it. This is extraordinarily useful in case you need to quickly see which sensors are checking in. The other issue this node gives is an easy way to interchange your router to the network identity that devices in configuration mode document on, simply hit the button on the left of the node and the tool will switch to the configuration network, hit it once more to return it to listening mode. Once we get the wi-fi tool nodes set up, they may be set to routinely configure a sensor whilst it enters configuration mode, so it’s always available to maintain such gateway nodes present at the flow for speedy configuring a device.

Step 12: Adding the Wireless Sensors:

we need to separate wireless sensor records domestically in order that we are able to display it, we could use a switch node to split out the messages from the gateway based totally on the mac address with or sensor type, but as I referred to, the wireless nodes truly incorporate extra functionality for configuring the sensors, so we’ll start with them to give you an extra entire image of how those structures can work. In case you haven’t already seen packets coming in from both of your sensors, cross in advance and hit the reset button on the only that hasn’t started. While a sensor assessment in through any serial device configuration node, the mac address and kind of sensor is cached in a pool so we are able to quickly find it for the duration of this next step.

Grab a Wireless Node from the palette and drag it onto the flow, double click on it to get it configured.

Step 13: Select the Serial Device From the Drop Down That You Used for the Wireless Gateway, Now Click the Magnifying Glass Next to “Mac Address” and Select One of the Available Options.

Select the Serial Device From the Drop Down That You Used for the Wireless Gateway, Now Click the Magnifying Glass Next to “Mac Address” and Select One of the Available Options.

Step 14: Click Done

You’ll notice this automatically sets the sensor type for you, you can also give it a name to make it easier to identify. As noted in the info tab, the Serial Device for Config field is optional, and we won’t worry about it right now. The node you have just added effectively works as a filter on incoming sensor data, only passing through data for the mac address, or sensor type if no mac address is present.

Step 15: Now Go Back to Your Palette and Type “debug” Into the Search Field at the Top, Grab One of These Nodes and Drag It to the Right of Your Wireless Gateway

Step 16: Double Click on It and Click Done

Step 17: Adding the Function Nodes

The function node is used to run JavaScript code against the msg object. The function node accepts a msg object as input and can return 0 or more message objects as output. This message object must have a payload property (msg.payload) and usually has other properties depending on the proceeding nodes.

Now grab a “function” node from the palette, and place it to the right of the Temp/Hum node.

Step 18: Double Click on the Node to Edit the Function Node.

Here you have to write little javascript code to create a condition, so the temperature and humidity values will be written in the excel.

Step 19: Now Add “http Request” Node From the Palette.

If you double click on it edit http node, you’ll see a “URL” field, here you have to enter the respective link of the google sheet. Now create a google sheet to store the values of temperature and humidity.

Step 20: Steps to Create a Google Sheet

First, open up your browser and type www.google.com and sign up in google account if you haven’t signed in, then click on the six dots on the left of your picture.

Step 21: Now Click on “Drive” to Open the Google Drive.

Step 22: Click on New>More>Google Forms>Blank Form

Step 23: Here You’ll See an Untitled Form, Give It Some Title As Shown in the Picture

Step 24: Now Edit Question As Temperature and Click on the “+” Button to Add Another Question for Humidity.

Step 25: Enter Question As Humidity to Take Humidity Values

Step 26: Now Click on the Three Dots Beside Your Picture As Shown in the Picture Below

Step 27: Now Click on the “Get Pre-filled Link”

Step 28: Now Enter Random Values to Temperature and Humidity Fields and Click Get a Link

Step 29: Now Paste That Link in Notepad

Step 30: Edit That Link As Shown in the Picture.

Step 31: Now Go Back to Form and Click on RESPONSES and Then Click on the Google Sheet Icon As Shown in the Picture

Step 32: Create a New Spreadsheet

Step 33: Here You Are Able to See a New Spreadsheet, Then Give It Some Name As Shown in the Pictures

Step 34: Here You Can Visualize the Values of Temperature and Humidity

Step 35: Now Go Back to Node-red and Double Click on Http Request Node to Edit It, Then Copy the URL From the Notepad That You Have Saved and Paste It in the URL Field As Shown in the Figure

Now Go Back to Node-red and Double Click on Http Request Node to Edit It, Then Copy the URL From the Notepad That You Have Saved and Paste It in the URL Field As Shown in the Figure

You can also attach debug node to check the output the http node.

Step 36: Now Connect All the Wires

Step 37: Click on Deploy Button to Get Them Out on the Google Sheet

Step 38: OUTPUT

Now to go google spreadsheet and you’ll see values are coming.

Step 39: Node_red_flow_JSON

node-red_flow.json
Download

Introduction: Sending IoT Long Range Wireless Temperature and Humidity Sensor Data to Google Sheet