Fetch data from Google Spreadsheet

Question

how can I fetch data from a google spreadsheet? It's not something like embedding a google doc on a webpage. Suppose, you have a table consisting of 10 rows and 10 columns at google doc. Now, you created a 10x10 table on a PHP webpage. Now you will show the respective values of the cells from that google doc to your php page. It's just like fetching data from a MySQL database and showing them on your web page. But here instead of using a MySQL database, I want to use Google Doc and do the rest. But how can I do it?

Thank you.

Answer 1

Google has a REST api for spreadsheets and native apis for many languages.

https://developers.google.com/sheets/api

Answer 2

If your data is the typical table layout (rows of data with a header row) - then you might find this python library helpful:

http://sheetsync.readthedocs.org/en/latest/