google spreadsheet in

README.md

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).

flow.json

[{"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"]]}]

Does this flow still work as of 2016? I assume not, as I see no way to save a sheet in and ".odf" friendly format.