Google spreadsheet to generate list of styled links in html document

June 9, 2014 2:10 PM

I'd like to have a simple html page of styled links that can be updated using a Google spreadsheet.

I'd like to keep this as simple as possible. The html page has css styles associated with it, so the links would be styled, and ideally I could just update a spreadsheet to add another link to the list on the html page.

I'd like to avoid inserting an actual spreadsheet in the page, I would just like the content to populate a styled page. Handy with html and css, but it's not my main skillset. Wondering if there's a simple solution to this.

posted by Sreiny to Computers & Internet (1 answer total)

There are a couple projects that get the Google Sheet data into a form you can easily use to generate the list items:

http://misoproject.com/dataset/tutorials/googlespreadsheets

http://www.ideawide.com/Gsheet2json/
posted by michaelh at 2:26 PM on June 9, 2014 [2 favorites]