Rajbir Singh
Published © GPL3+

Wireless Vibration and Temperature to Google Sheets

Sending NCD IoT Long Range Wireless Vibration and Temperature data to google sheets using Node-RED

IntermediateProtip2 hours179
Wireless Vibration and Temperature to Google Sheets

Things used in this project

Hardware components

National Control Devices Wireless Vibration and Temperature Sensor
×1
National Control Devices 900HP-S3B Long Range Wireless Mesh Modem with USB Interface
×1

Software apps and online services

Node-Red

Story

Read more

Code

Node-RED Flow

JSON
[{"id":"26528dd5.530ce2","type":"http request","z":"26ba5b1.94603a4","name":"","method":"GET","ret":"txt","paytoqs":true,"url":"https://docs.google.com/forms/d/e/1FAIpQLSdfkCqLC6np2fFv63IzyqjXHquRRXjr9QWJ0YZlLvrHltTd6A/formResponse?usp=pp_url&entry.1240716111={{payload.rms_x}}&entry.1866318371={{payload.rms_y}}&entry.1440491655={{payload.rms_z}}&entry.923295380={{payload.max_x}}&entry.1721993037={{payload.max_y}}&entry.806918279={{payload.max_z}}&entry.1080142950={{payload.min_x}}&entry.2110504556={{payload.min_y}}&entry.363122801={{payload.min_z}}&entry.1161590279={{payload.temperature}}","tls":"","proxy":"","authType":"basic","x":510,"y":180,"wires":[["fb0786b2.638838"]]}]

Credits

Rajbir Singh

Rajbir Singh

19 projects • 4 followers
A skilled developer with experience of extensive development in the Internet of Things (IoT).

Comments