Push data to Google Spreadsheet

Pushes data from any data source to goolge spreadsheet using forms.
How to https://groups.google.com/forum/#!topic/node-red/ThwhcHKqe-M

[{"id":"d1b3decf.05bd18","type":"inject","name":"CSV data in","topic":"","payload":"nid=2,count=10,speed=20,rssi=-10","payloadType":"string","repeat":"","crontab":"","once":false,"x":199.00001525878906,"y":239,"z":"818edd79.97e3d8","wires":[["21346762.6eb0d"]]},{"id":"21346762.6eb0d","type":"function","name":"Parser","func":"//splits the data\n//Code snippet from\n//http://flows.nodered.org/flow/6572686\n\nvar data = msg.payload.split(\",\");\n\nmsg.payload = {}; //null msg obj and create new properties\n//may need to remove the parseint function \nmsg.payload.nodeid = parseInt(data[0].split(\"=\")[1]);\nmsg.payload.counter = parseInt(data[1].split(\"=\")[1]);\nmsg.payload.speed = parseFloat(data[2].split(\"=\")[1]);\nmsg.payload.rx_rssi = parseInt(data[3].split(\"=\")[1]);\n\nreturn msg;","outputs":1,"x":362,"y":239,"z":"818edd79.97e3d8","wires":[["1dc343e8.8950e4"]]},{"id":"4e61a55b.b13824","type":"comment","name":"POST URL","info":"https://docs.google.com/forms/d/YourformID/formResponse?entry.1077669989=NODEID&entry_10292411=COUNTER&entry_1862110215=SPEED&entry_1744026500=RXRSSI\n\nReplace YourformID in the URL","x":549,"y":196.00000762939453,"z":"818edd79.97e3d8","wires":[]},{"id":"1092fe22.4414f2","type":"debug","name":"","active":true,"console":false,"complete":false,"x":732.0833129882812,"y":239.08331298828125,"z":"818edd79.97e3d8","wires":[]},{"id":"1dc343e8.8950e4","type":"http request","name":"","method":"GET","url":"https://docs.google.com/forms/d/YouFormID/formResponse?entry.1077669989={{payload.nodeid}}&entry_10292411={{payload.counter}}&entry_1862110215={{payload.speed}}&entry_1744026500={{payload.rx_rssi}}","x":550.0833129882812,"y":239.08331298828125,"z":"818edd79.97e3d8","wires":[["1092fe22.4414f2"]]},{"id":"539b3cdf.bf55ac","type":"comment","name":"Source","info":"Be it serial or any other data source. ","x":167.0833282470703,"y":187.0833282470703,"z":"818edd79.97e3d8","wires":[]}]

Flow Info

Created 10 years, 5 months ago
Updated 8 years, 9 months ago
Rating: 5 1

Owner

Actions

Rate:

Node Types

Core
  • comment (x2)
  • debug (x1)
  • function (x1)
  • http request (x1)
  • inject (x1)

Tags

  • raspberry
  • pi
  • http
  • google
  • spreadsheet
Copy this flow JSON to your clipboard and then import into Node-RED using the Import From > Clipboard (Ctrl-I) menu option