What is the Google Spreadsheets data API?
The Google Spreadsheets data API is an extension of the Google Data API protocol, which you can use to create programs that interact with Google Spreadsheets. The API allows you to query for a list of spreadsheets owned by the currently authenticated user, query for a list of worksheets visible to the authenticated user in a given spreadsheet, and query, insert, update, and delete data in a spreadsheet by either cell or row. The Google Spreadsheets data API is designed for developers who would like to integrate their applications with Google Spreadsheets.