sergmoro1/yii2-google-spreadsheet

Access to Google SpreadSheet from Yii2 by Google REST API.

dev-master 2024-05-17 15:15 UTC

Requires

• php: >=5.4.0
• yiisoft/yii2: *

MIT

• Sergey Morozov

• spreadsheet
• google
• REST API
• yii2

README

Simple extension for getting list of user's spreadsheets and open selected spreadsheet in IFRAME.

Example of using Google REST API and OAuth2 authorization.

Installation

Register Google-project first

Follow the instructions - Setting up OAuth 2.0 .

Set up extension

$ composer require sergmoro1/yii2-google-spreadsheet "dev-master"

Usage

1.Copy model, controller and views from ./example to corresponding directories of your app. Change methords and actions or leave them as is.

2.Define constants in params file (for ex. in frontend/config/params.php).

<?php
return [
    'clientId' => '***',
    'clientSecret' => '***',
    // dev (for ex.)
    'redirectUri' => 'http://localhost/yoursite/frontend/web/google/oauth',
    // production
    //'redirectUri' => 'http://yoursite/google/oauth',
];

3.Declare Redirect Uri in your Google Project. For ex.

// dev
http://localhost/yousite/frontend/web/google/oauth2

// production
http://yoursiteDOTcom/google/oauth2

Result

Now you can view list of your spreadsheets, if you have them, by active Uri at the moment:

http://yoursite_or_localhost_path/google