Update 6/14/2007: Dion Almaer has published a nice Javascript helper which makes working with spreadsheets much nicer, I’ve moved my stuff to it and it’s a big improvement over using the Google JSON api directly.
Publishing dynamic content on your website in a format that you can style with CSS has gotten a whole lot easier with Google’s simple JSON based Javascript API’s. The two I’ve found myself playing with lately are the Google Ajax Feed API for publishing RSS and Atom feeds and the Google Spreadsheet API
for publishing little snippets of text that should be easily editable.
Say you want a simple headline on your homepage that you can change daily. Here’s how you’d do it with the Google Spreadsheet API:
1. Create a spreadsheet making the first row the column headers (important because you’ll refer to the cell by the column header):

(more…)