CODEWITHSUNDEEP
phpcurlgoogle-sheets
edt
edt

Reputation: 22410

How to use the Google SpreadSheets API to feed data to an application?

I've read through the Google Spreadsheets API PHP documentation. All examples are using Zend, which I cannot use. See this page: http://code.google.com/apis/spreadsheets/docs/1.0/developers_guide_php.html

Does anybody know a simple example of the following:

How can I use PHP w/ curl (or whatever) and the Google Spreadsheets API to get the data from a Google Spreadsheets Doc?

It's my understanding that the data will be delivered in XML format. From there, I'll use PHP to manipulate it.

Upvotes: 13

Views: 35058

Answers (4)

Carlton Gibson
Carlton Gibson

Reputation: 7386

The Zend Gdata implementation is the official PHP library for Google APIs. Not much of an answer I guess but I have to ask, why wouldn't you just use it? (It seems like you're reinventing the wheel... :-)

Upvotes: 0

Alix Axel
Alix Axel

Reputation: 154513

Google is your friend! ;)

Upvotes: 10

Phil Bogle
Phil Bogle

Reputation: 109

The Google Spreadsheets Data API is documented here.

http://code.google.com/apis/spreadsheets/docs/1.0/developers_guide_protocol.html

It's a REST API so you just need appropriately formatted GETS and POSTS as described in the docs.

Upvotes: 0

Robert DeBoer
Robert DeBoer

Reputation: 1695

From what I can see and how most of the other Google API work, the Spreadsheet API is centered around URLs. You formulate a URL and an xml response is returned. It seams that for this particular product however, most the support is for the Zend framewok implementation. You could always download the Zend component and reverse engineer it to work.

Upvotes: 0

Related Questions