ttskch / google-sheets-api-php-client
PHP client library for Google Sheets API.
Installs: 1 597
Dependents: 1
Suggesters: 0
Security: 0
Stars: 7
Watchers: 3
Forks: 3
Open Issues: 0
Requires
- php: >=5.6.0
- google/apiclient: ^2.2
Requires (Dev)
- friendsofphp/php-cs-fixer: ^2.3
- phpmd/phpmd: ^2.6
- phpunit/phpunit: ^5.7 || ^6.0
- squizlabs/php_codesniffer: ^2.8
This package is not auto-updated.
Last update: 2024-11-01 07:29:22 UTC
README
PHP client library for Google Sheets API.
Requirements
- PHP 5.6+
Installations
$ composer require ttskch/google-sheets-api-php-client:@dev
Usage
Initializing API client
With OAuth2
// create \Google_Client instance with your OAuth2 client ID. $googleClient = \Ttskch\GoogleSheetsApi\Factory\GoogleClientFactory::createOAuthClient( 'client_id', 'client_secret', 'redirect_uri', 'javascript_origin' ); // authenticate and be athorized. $authenticator = new \Ttskch\GoogleSheetsApi\Authenticator($googleClient); if (isset($_GET['code'])) { $authenticator->authenticate($_GET['code']); } else { $authenticator->authorize(); }
With Service Account
// create \Google_Client instance with your Service Account credentials json file. $googleClient = \Ttskch\GoogleSheetsApi\Factory\GoogleClientFactory::createServiceAccountClient('/path/to/service-account-credentials.json');
Using API
// create API client with authorized \Google_Client. $api = \Ttskch\GoogleSheetsApi\Factory\ApiClientFactory::create($googleClient); $service = $api->getGoogleService(); // now you can call all apis via $service. // see \Google_Service_Sheets class to learn more about details. $service->spreadsheets->...; $service->spreadsheets_sheets->...; $service->spreadsheets_values->...;
See also demo.