ttskch/pheetsu

PHP library to CRUDify Google Spreadsheets like sheetsu.com

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

Requires

• php: >=5.6.0
• symfony/http-foundation: ^3.4|^4.1
• ttskch/google-sheets-api-php-client: @dev

Requires (Dev)

• friendsofphp/php-cs-fixer: ^2.3
• phpmd/phpmd: ^2.6
• phpunit/phpunit: ^5.7 || ^6.0
• squizlabs/php_codesniffer: ^2.8

MIT

• Takashi Kanemoto

• api
• crud
• spreadsheets
• sheetsu

README

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,

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.