Getting data from google spreadsheet as json |
Hi,
I needed to get data from google spreadsheet as a json and it came out it's not that simple. I've made an app to do exactly that. Maybe you want to use it as well, if you do I've made a few lines of introduction: In many simple projects you don't need to configure database and setup entire backend. Instead you can use google spreadsheet, your clients already know how to use it. www.sheetdb.io - it's an API for your google spreadsheet documents. I've also made composer library https://github.com/sheetdb/sheetdb-php - setup that environment is 1 line in terminal and 3 lines in code editor. Code: composer require sheetdb/sheetdb-php + PHP Code: use SheetDB\SheetDB; Let me know if php library is ok? I could make one especially for codeigniter but I don't think it's necessary.
(11-02-2017, 11:00 AM)chris44 Wrote: Hi, why should i use a 3rd party site? I can use the google api to read a google spreadsheet. Example: https://developers.google.com/sheets/api/quickstart/php Short: i do not trust you
Just because it's really pain to take care of Goole OAuth API for every single small projects, refresh tokens etc. Try to use it, I can guarantee you that it's not couple of lines of code. In additional Google now verificate your account.. Ofc. it's your call, but I have tool to simplify things
i never had any problems with the google api and creating a wrapper class is easy. i need a google account to use the service from the sheetdb.io...
|
Welcome Guest, Not a member yet? Register Sign In |