ttskch/pheetsu

PHP library to CRUDify Google Spreadsheets like sheetsu.com

dev-master / 1.0.x-dev 2018-11-16 00:47 UTC

This package is not auto-updated.

Last update: 2022-01-08 13:01:45 UTC


README

Latest Stable Version Total Downloads

PHP library to CRUDify Google Spreadsheets like sheetsu.com.

Requirements

  • PHP 5.6+

Installations

$ composer require ttskch/pheetsu:@dev

Usage

If you have a Google Spreadsheet like this,

image

You can CRUD the spreadsheet via pheetsu so easily like below.

Initializing with OAuth2

$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::createOAuth(
    'google_oauth2_client_id',
    'google_oauth2_client_secret',
    'google_oauth2_redirect_uri',
    'google_oauth2_javascript_origin',
    '1JQkfd3dlyxFRuxIwGPnBnrxS-l-bLVw_BbHskxT9Nj4', // spreadsheet id
    'demo' // sheet name
);

// authenticate and be authorized with Google OAuth2.
$pheetsu->authenticate();

Initializing with Service Account

$pheetsu = \Ttskch\Pheetsu\Factory\PheetsuFactory::createServiceAccount(
    '/path/to/your/service-account-credentials.json',
    '1JQkfd3dlyxFRuxIwGPnBnrxS-l-bLVw_BbHskxT9Nj4', // spreadsheet id
    'demo' // sheet name
);

Using

$rows = $pheetsu->read();
var_dump($rows);

// array (size=3)
//   0 => 
//     array (size=3)
//       'id' => string '1' (length=1)
//       'name' => string 'Alice' (length=5)
//       'age' => string '20' (length=2)
//   1 => 
//     array (size=3)
//       'id' => string '2' (length=1)
//       'name' => string 'Bob' (length=3)
//       'age' => string '25' (length=2)
//   2 => 
//     array (size=3)
//       'id' => string '3' (length=1)
//       'name' => string 'Charlie' (length=7)
//       'age' => string '18' (length=2)

See also demo.