Quickest way to poll a changing json and update a row in a Google spreadsheet

Published november 29th, 2017 by

Aka "a poor mans database".

A user asked for a playlist for one of our streaming radiochannels. We have no official playlist for that channel, and being pressed for time I hastily created a Google Spreadsheet and added a simple script for polling a json-script. It uses Google's inbuilt trigger solution for running the script every five minute. The script lacks any checks and failsafes and is meant for demo purposes.

Tip: Use http://www.jsonquerytool.com/ to figure out how to query your json.

Todo: Parse unix timestamp to make it human readable

Does it grow with a new line every five minutes? Yes it does!

(External link)

Posted in Code