How to read and write data to google spreadsheets via PHP?

Question

API

Hello. There is a google document in public access, and I need, using PHP, to read data from there and write the result to it.
Can I have a simple example? Google documentation read and understood little. Unfortunately, I don't speak English well.

Answer 1

habrahabr.ru/sandbox/46965

Answer 2

I figured out how to read from google spreadsheets. First you need to go to this table and click File -> Publish on the Internet -> start publishing.
Then the link

https://spreadsheets.google.com/feeds/cells/key/worksheetId/public/basic

you can get all the data from the document in XML format, where
key is the key of the document, which can be taken from the link
worksheetId - page number
The list of pages can be pulled from here:

https://spreadsheets.google.com/feeds/worksheets/key/public/basic

As for writing to the document, the question remains open.

Answer 3

Hmm, I have a related question, only here is the problem with updating Cyrillic characters to a PHP + Google api php client + Google spreadsheets API Client cell and writing Cyrillic characters to a sheet cell?