Getting json from google spreadsheet

Ask about general coding issues or problems here.

Moderators: egami, macek, gesf

Post Reply
New php-forum User
New php-forum User
Posts: 1
Joined: Thu Nov 02, 2017 8:35 am

Thu Nov 02, 2017 8:44 am


I've came across that problem. I needed to get data from an google spreadsheet as a json data and it came out it's not that simple. I've made an app that do exactly that. Maybe you want to use it, 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. - it's an API for your google spreadsheet documents. I've also made composer library, check it on github - - setup that environment is 1 line in terminal and 3 lines in code editor.

Code: Select all

composer require sheetdb/sheetdb-php


Code: Select all

use SheetDB\SheetDB;

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

Post Reply