Once you are referencing lists as custom functions or with the blister API, you can forget about how the data got there. I've already covered Fusion and blister lists , Setting up blister lists from a Spreadsheet and Using the API to manage lists. Here's another variation. In this case we'll take the billboard top 100, and we'll set up a trigger to refresh it every day.
It ends up looking like this (I get the list by using these custom functions)
to get something that starts like this.
Just like in Fusion and blister lists this is a one liner. Of course you don't have to do anything, since it's done automatically, but here's the code behind if you are interested.
Here's the code creating a blister from an xml feed. It might need some tweaks but this should be a good basis
Just set up a daily trigger as below, and anyone using the blister for billboard will get an new list each day
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Things that have been deprecated > GAS lists and validation >