Google Spreadsheets Data API

Preliminary research

The Google Spreadsheets data API allows client applications to view and update Spreadsheets content in the form of 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.


Pre requirements for developers:

Understanding of the general ideas behind the Google data APIs protocol, knowledge how to program in Java.

Based on Technologies:

Google data API ("GData") feeds

API Functionality:

Here are some of the things you can do with the Speadsheets data API:
  • Use a spreadsheet as a database and access data for another application via the Spreadsheets data API.
  • Use an external graphing library with the Spreadsheets data API to add nice looking graphs to your site.
  • Implement auto-filtering and other spreadsheet functionality in an application you build for your users
  • Interacting with Spreadsheets:
    • Create a spreadsheet
    • Get an authentication token
      • Single-user "installed" client authentication (via HTTP)
      • Single-user "installed" client authentication (via the client library)
      • Multiple-user web application client authentication (via HTTP)
      • Multiple-user web application client authentication (via the client library)
    • Get a list of spreadsheets
    • Get a list of worksheets
    • Interacting with list-based feeds
      • Get a list-based feed
      • Reverse-sort rows
      • Add a row
      • Send a structured query
    • Interacting with cell-based feeds
      • Get a cell-based feed
      • Send a cell range query
      • Add data to an empty cell

User’s Functionality:

  • Online document creation -- Create new documents from scratch, or upload saved documents from your computer. Edit your documents from any internet-connected computer.
  • Real-time collaboration -- Simultaneously work on documents together with others that you invite, even if you're not in the same place.
  • Revision history -- Individual edits are kept so you can see who added and deleted what, when.
  • Search tools -- Just like Gmail, with Docs & Spreadsheets, you can harness the power of Google search to look for a document you haven't edited in months.
  • Security and privacy -- You choose who sees your document, when. Other users can only access your document or spreadsheet if you add them to the list of collaborators or viewers, or if you decide to publish the document. And administrators have the ability to set restrictions on internal and external document sharing.
  • Integration -- Users can access their Docs & Spreadsheets documents right from your organization's Start Page. And the Google Spreadsheets data API allows other applications to display and update spreadsheets content.
  • Supported browsers -- Microsoft Internet Explorer, Mozilla Firefox, Mozilla and Netscape
  • Supported languages -- US English, UK English, Dutch, French, German, Italian, Japanese, Korean, Brazilian Portuguese, Russian, Spanish, Turkish, Simplified Chinese and Traditional Chinese.

Browser Compatibility:

Is it open source?

You need to have a Spreadsheets account. Google data APIs protocol
Using the Java Client Library
Google APIs
  Page Info My Prefs Log in
This page (revision-1) last changed on 18:24 25-Mar-2017 by Maryna Astrouskaja.

Referenced by
Google AP Is

JSPWiki v2.4.102