# How to send data of wireless sensor to google sheets

**URL:** <https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644>\
**Category:** General\
**Created:** [24 July 2019 10:31 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644 "2019-07-24T10:31:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [24 July 2019 10:31 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644/1 "2019-07-24T10:31:25Z")

</div>

Hi, I am working with [wireless temperature and humidity sensor](https://store.ncd.io/product/industrial-long-range-wireless-temperature-humidity-sensor/)  
I want to send its data to google sheets.  
I have searched on google and found this[link](https://groups.google.com/forum/#!topic/node-red/IO3I0PI_u2g).  
From this link I have created the google sheet

 ![googlesheet_step12](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/c/c1e705b9cf1e5e7270c6b9bf8d4bc52037903658.jpeg)  
but I am not getting how to get values in the sheet.  
Please help me out.  
Thanx in advance.

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [24 July 2019 10:35 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644/2 "2019-07-24T10:35:55Z")

</div>

Well the bottom of the link you posted are several people who say that that method no longer works...

But without your flow it is difficult for anyone to see if there is an obvious error, or it os that google have changed their API and the method you are trying is broken

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [24 July 2019 10:43 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644/4 "2019-07-24T10:43:39Z")

</div>

Sorry, I am new to this.  
Here is my flow

```auto
[{"id":"92f30be3.3a0078","type":"tab","label":"Flow 7","disabled":false,"info":""},{"id":"866b699f.a2bd78","type":"ncd-gateway-node","z":"92f30be3.3a0078","name":"","connection":"258e5fea.00897","x":130,"y":60,"wires":[["21995762.9035e8"]]},{"id":"229131a1.83a27e","type":"ncd-wireless-node","z":"92f30be3.3a0078","name":"","connection":"c92dec1c.7fc9","config_comm":"50e22a9e.060f74","addr":"","sensor_type":"1","auto_config":"","node_id":0,"delay":300,"destination":"0000FFFF","power":4,"retries":10,"pan_id":"7FFF","change_enabled":"","change_pr":"0","change_interval":"0","cm_calibration":"60.6","bp_altitude":"0","bp_pressure":"0","bp_temp_prec":"0","bp_press_prec":"0","amgt_accel":"0","amgt_mag":"0","amgt_gyro":"0","impact_accel":"0","impact_data_rate":"4","impact_threshold":25,"impact_duration":1,"activ_interr_x":1,"activ_interr_y":2,"activ_interr_z":4,"activ_interr_op":8,"filtering":0,"data_rate":5,"time_series":0,"reading_type":1,"x":120,"y":200,"wires":[["5f33b485.de23dc"]]},{"id":"21995762.9035e8","type":"debug","z":"92f30be3.3a0078","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":350,"y":60,"wires":[]},{"id":"5f33b485.de23dc","type":"function","z":"92f30be3.3a0078","name":"","func":"msg.payload = {};\nmsg.payload.temperature = parseInt(Math.random() * 100);\nmsg.payload.humidity = parseInt(Math.random() * 100);\nreturn msg;","outputs":1,"noerr":0,"x":370,"y":200,"wires":[["b767a18e.49953"]]},{"id":"b767a18e.49953","type":"http request","z":"92f30be3.3a0078","name":"","method":"GET","ret":"txt","paytoqs":false,"url":"https://docs.google.com/spreadsheets/d/1jUVZEOLTTLfUYiVtkv902BmQIia5dhf9qHEC-405n-M/edit#gid=1974105633","tls":"","proxy":"","authType":"basic","x":570,"y":200,"wires":[["3fd243af.cc72fc"]]},{"id":"3fd243af.cc72fc","type":"debug","z":"92f30be3.3a0078","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":630,"y":320,"wires":[]},{"id":"258e5fea.00897","type":"ncd-gateway-config","z":"","name":"","comm_type":"serial","ip_address":"","tcp_port":"2101","port":"COM6","baudRate":"115200","pan_id":"7fff","rssi":false},{"id":"c92dec1c.7fc9","type":"ncd-gateway-config","z":"","name":"","comm_type":"serial","ip_address":"","tcp_port":"2101","port":"COM6","baudRate":"115200","pan_id":"7fff","rssi":false},{"id":"50e22a9e.060f74","type":"ncd-gateway-config","z":"","name":"","comm_type":"serial","ip_address":"","tcp_port":"2101","port":"COM6","baudRate":"115200","pan_id":"7fff","rssi":false}]

```

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [24 July 2019 11:02 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644/5 "2019-07-24T11:02:19Z")

</div>

You're not following the guide you linked to. Check out the URL from the guide and compare that to yours.  
But given the last posts on the thread I'm not sure if it would work anyway.

---

<div class="post-metadata">

**Author:** ![adamf](https://avatars.discourse-cdn.com/v4/letter/a/cab0a1/32.png) [@adamf](https://discourse.nodered.org/u/adamf)\
**Post date:** [24 July 2019 11:03 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644/6 "2019-07-24T11:03:42Z")

</div>

It is not working,please suggest me some better way

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [24 July 2019 12:07 UTC](https://discourse.nodered.org/t/how-to-send-data-of-wireless-sensor-to-google-sheets/13644/7 "2019-07-24T12:07:44Z")

</div>

Well you could search on [flows.nodered.org](http://flows.nodered.org) for a node that might help you.  
You could find a tutorial online from the past year that documents a newer way of posting data to google sheets.