asgoodasnu/google-spreadsheet-bundle

Integrates asimlqt/php-google-spreadsheet-client with Symfony2 and google/apiclient

This package's canonical repository appears to be gone and the package has been frozen as a result.

v1.0.0 2016-02-03 18:16 UTC

Requires

• asimlqt/php-google-spreadsheet-client: 2.3.7
• google/apiclient: 1.1.6
• symfony/framework-bundle: ~2.6
• symfony/yaml: ~2.6

Requires (Dev)

• matthiasnoback/symfony-dependency-injection-test: ~0.7
• phpunit/phpunit: ~4.8

MIT

• Annika Flemming
• Github Community

README

The WkGoogleSpreadsheetBundle provides a Symfony2 service to interact with the Google Spreadsheet API using the asimlqt/php-google-spreadsheet-client library. It incorporates the google/apiclient to connect to Google via OAuth2 as a server to server application.

Installation

Require the bundle and its dependencies with composer:

$ composer require asgoodasnu/google-spreadsheet-bundle

Register the bundle:

// app/AppKernel.php
public function registerBundles()
{
    $bundles = array(
        new Wk\GoogleSpreadsheetBundle\WkGoogleSpreadsheetBundle(),
    );
}

Set the Google OAuth2 credentials in your project's config.yml:

# config.yml
wk_google_spreadsheets:
    credentials:
        client_email: "[e-mail]"
        private_key: "%kernel.root_dir%/config/google.pem"

Providing your Google OAuth2 credentials

To interact with the Google Spreadsheet API you need to provide your Google OAuth2 service account credentials. Please head over to https://developers.google.com/identity/protocols/OAuth2ServiceAccount for more information on how to create a service account and obtain your service account key.

Usage

The service wk_google_spreadsheet provides direct interaction with the Google Spreadsheet PHP Client. You can invoke all methods of the client directly on the service:

$service = $container->get('wk_google_spreadsheet');

$service->getSpreadsheets();
$service->getSpreadsheetById();
$service->getListFeed();
$service->getCellFeed();

See https://github.com/asimlqt/php-google-spreadsheet-client for a full documentation of the client and its methods.

Dependencies

• asimlqt/php-google-spreadsheet-client - Google Spreadsheet PHP Client
• google/apiclient - Client library for Google APIs
• symfony/yaml - Symfony Yaml Component
• symfony/framework-bundle - Symfony FrameworkBundle

PHPUnit Tests

You can run the tests using the following command:

$ vendor/bin/phpunit

Resources

Symfony 2

http://symfony.com

Google Spreadsheet PHP Client

https://github.com/asimlqt/php-google-spreadsheet-client

Google Sheets API (formerly called the Google Spreadsheets API)

https://developers.google.com/google-apps/spreadsheets

Client library for Google APIs

https://github.com/google/google-api-php-client/tree/v1-master

Using OAuth2 service accounts for Server to Server Applications

https://developers.google.com/identity/protocols/OAuth2ServiceAccount