Accessing Google Spreadsheets with RunRev

Jim Schaubeck jimschaubeck at yahoo.com
Fri Jun 19 01:38:43 EDT 2009


Folks,
Has anyone had success in accessing cell data with google docs from within your scripts?  I've researched Googles API reference URL (fairly straightforward) and here is their reference format for 'Cell-based feed':
http://spreadsheets.google.com/feeds/cells/key/worksheetId/visibility/projection/cellId

Here's my simple script:
on mouseup
  put URL "http://spreadsheets.google.com/feeds/cells/rXtefVGMQhHdB4U2saE2Qxw/1/public/basic/R1C1" into cd fld "data"
end mouseup

I wish to get the test data in cell A1 (which is "120") into cd fld "data" but I get a long response.  If I get this right I plan to extract other data from spreadsheets I use for my company.  I think I have the formatting close to correct because if I change any of it, I get an error msg instead of the loang response (which I intentioally left out of this email).

Has anyone tried to access google spreadsheets using their API's?

As always folks, thankyou for any feedback
Jim Schaubeck


More information about the use-livecode mailing list