Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jimpick/69951 to your computer and use it in GitHub Desktop.
Save jimpick/69951 to your computer and use it in GitHub Desktop.
Here's how to extract data out of a Google Doc spreadsheet.
Here's our victim...
http://spreadsheets.google.com/ccc?key=pUetVbUnXgLbDjatWZKjVAw
Note - If you are interested, you can sign up here: http://tr.im/gHHS
Now go to the Google OAuth Playground.
http://www.googlecodesamples.com/oauth_playground/
Select spreadsheets for the scope, then click on all the buttons.
Then enter this query.
http://spreadsheets.google.com/feeds/cells/pUetVbUnXgLbDjatWZKjVAw/1/private/full/R7C3
You should get an XML file back with "Darren Barefoot" in the "content" element as the result.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment