Google Spreadsheets API (Labs)

What is the Google Spreadsheets API?

The Google Spreadsheets API allows client applications to programmatically access and manipulate user data stored in Google Spreadsheets. Here are some of the things you can do with the API:

Spreadsheets Retrieve spreadsheets that match a specific ID or title.	Worksheets Manage worksheets in a spreadsheet, or search for worksheets by ID or title.
Tables & Records Interact with spreadsheets as if they're a database using Tables and Records.	Lists & Cells Manage data in a spreadsheet directly using Lists and Cells of data.
Documents: While the Spreadsheets API can be used to create and retrieve data in Google Spreadsheets, it cannot be used to create spreadsheets or manage their permissions. For that, you can use the Google Documents List API.