jpick (owner)

Revisions

gist: 69951 Download_button fork
public
Public Clone URL: git://gist.github.com/69951.git
Embed All Files: show embed
HOWTO extra data out of a Google Doc using GData and REST #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

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.