Google Gadget / Spreadsheet: Capture a Gadget Spreadsheet

Question

So, I'm working on a Google gadget (really only a gadget so I can get the data store for this ) that I want to embed in the google spreadsheet (after that I'm going to skip the word google - you can just submit it there).

I want to use a spreadsheet so that I insert the gadget as a key / value store for the data that I entered into the gadget (I think the 2K limit for the gadget data will not be enough). It looks like what I want to do is use the gadget feed api to manage the feed list of spreadsheets . However, in order to find out what a list of spreadsheet lists is, I need to know the key for the spreadsheet (which is in the URL). I don’t think I can clear the key directly from the URL, as the gadget seems to be inserted through an iframe.

Therefore, I need to know how I can specify the gadget that I embed in the spreadsheet, the key for this table. I suppose I could enter it manually, but I would prefer my gadget know the key programmatically.

Answer 1

You might want to use Google Apps Script instead of a gadget. He knows the table in which it is embedded.

http://code.google.com/googleapps/appsscript/

Answer 2

You should be able to get a list of spreadsheets by making a GET request to this URL:

https://spreadsheets.google.com/feeds/spreadsheets/private/full

. API Google Spreadsheets: http://code.google.com/apis/spreadsheets/data/3.0/developers_guide_protocol.html#ListingSpreadsheets