CODEWITHSUNDEEP
google-sheetsgoogle-sheets-api
mahir
mahir

Reputation: 69

Fetch data from Google Spreadsheet

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.

Upvotes: 6

Views: 28581

Answers (3)

LDAdams
LDAdams

Reputation: 682

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

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

Upvotes: 8

mbrenig
mbrenig

Reputation: 577

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/

Upvotes: 1

mflaming
mflaming

Reputation: 1157

Temboo provides an SDK library that makes it pretty easy to interact with Google Spreadsheets in multiple languages, including Java/Android, PHP, Ruby, Python, Node.js, and Objective C. There's also an online tool for experimenting with different Google Spreadsheet API calls. Take a look at https://www.temboo.com/library/Library/Google/Spreadsheets/

(Full disclosure: I work at Temboo)

Upvotes: 0

Related Questions