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;

$sheetdb = new SheetDB('58f61be4dda40');
$response = $sheetdb->get(); 


Let me know if php library is ok? I could make one especially for codeigniter but I don't think it's necessary.

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;

$sheetdb = new SheetDB('58f61be4dda40');
$response = $sheetdb->get(); 


Let me know if php library is ok? I could make one especially for codeigniter but I don't think it's necessary.

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...