PW is the web's leading resource for everything about open APIs and mashups. Learn more: take a tour »
From their site: The Google Spreadsheets data API allows client applications to view and update Spreadsheets content in the form of a Google data API ("GData") feeds. Your client application can request a list of a user's spreadsheets, edit or delete content in an existing Spreadsheets worksheet, and query the content in an existing Spreadsheets worksheet.
Click the "Track this API" button on any profile page and never miss an API update, new app, or breaking news for that API again.
a very interesting implementation of the spreadsheets API can be found in sisense that created a Provider dedicated to google spreadsheets data and allows you to create amazing dashboards and reports in minutes, it has much more power than the web gadgets.
you can find it in: