google spreadsheet in

This flow:

  • connects to a google spreadsheet url (by pressing the trigger)
  • parses the json
  • outputs the cells

You can change the googlespreadsheet url to your google spreadsheet accordingly.

Notes:

  • demo is focused on the old google spreadsheet url format, so you might run into problems when copy/pasting an google spreadsheet url-format into this flow. If so, try to save an old google spreadsheet to another documentname. That will create an spreadsheet with the old url format (containing 'odf' in the url).
[{"id":"3b3bbb0d.c4c444","type":"function","name":"get cells","func":"\nreturn msg.payload.feed.entry;","outputs":1,"x":353,"y":213,"z":"8d8efc1a.7271","wires":[["e0a820ba.1f57e"]]},{"id":"e0a820ba.1f57e","type":"debug","name":"","active":true,"console":"false","complete":"true","x":579,"y":210,"z":"8d8efc1a.7271","wires":[]},{"id":"c82b75ce.37d488","type":"http request","name":"[GET] google spreadsheet","method":"GET","url":"https://spreadsheets.google.com/feeds/list/0Aqglj65pqAwmdEh4a1otT3lmYnN0TGV1Q2JkdndVUnc/od6/public/basic?hl=en_US&alt=json","x":369,"y":67,"z":"8d8efc1a.7271","wires":[["b6fe6188.4901a"]]},{"id":"3ee43f4.fc11bc","type":"inject","name":"trigger","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"x":111,"y":67,"z":"8d8efc1a.7271","wires":[["c82b75ce.37d488"]]},{"id":"b6fe6188.4901a","type":"json","name":"","x":354,"y":146,"z":"8d8efc1a.7271","wires":[["3b3bbb0d.c4c444"]]}]
coderofsalvation

Flow Info

created 3 years, 4 months ago

Node Types

Core
  • debug (x1)
  • function (x1)
  • http request (x1)
  • inject (x1)
  • json (x1)

Tags

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