Testing two different methods for pulling data from a google spreadsheet for display on a web page:
-
using a direct link to the automatically generated csv as described by Kristin Henry.
-
using Tabletop.js to parse the spreadsheet automatically generated in 'Web page' format.
It appears that the csv version of the data generated by Google updates less frequently than the 'Web page' version, so using Tabletop.js is more reliable if you need immediate updates on data without manual refresh.