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