rhincodon/laravel-eloquent-spreadsheets

Sync Eloquent models with google spreadsheets

Laravel Eloquent sync with Google Spreadsheets

, _(*1)

Fast Preview:, _(*2)

, _(*3)

Installation

Via Composer:, _(*4)

``` bash $ composer require rhincodon/laravel-eloquent-spreadsheets, <sub>(*5)</sub>

Register Service Provider in `config/app.php`:

```php
Rhinodontypicus\EloquentSpreadsheets\EloquentSpreadsheetsServiceProvider::class,

Publish config:, <sub>(*6)</sub>

php artisan vendor:publish --provider="Rhinodontypicus\EloquentSpreadsheets\EloquentSpreadsheetsServiceProvider" --tag="config"

Fetch Google Credentials

In Google Console create Service Account:, <sub>(*7)</sub>

Step 1:, <sub>(*8)</sub>

, <sub>(*9)</sub>

Step 2:, <sub>(*10)</sub>

, <sub>(*11)</sub>

After pressing Create it will give you credentials file, which you can use in your project. Just save it somewhere in storage., <sub>(*12)</sub>

You also need to give access to spreadsheets that will be used to that service Account. Just copy client_email from credentials file, and use it to give access., <sub>(*13)</sub>

Usage

To start use package you need to specify array of models that will be synced in config file. It is a self-explainable config., <sub>(*14)</sub>

For now is working add, update, delete actions from app to spreadsheet. And update action from spreadsheet to app. All actions processed in queue., <sub>(*15)</sub>

If you want sync(only update action work) data back to app from spreadsheet, schedule following command:, <sub>(*16)</sub>

$schedule->command('eloquent-spreadsheets:sync')->hourly();

Roadmap

• [ ] Tests

Credits

• rhinodontypicus

License

The MIT License (MIT). Please see License File for more information., <sub>(*17)</sub>