Laravel Eloquent sync with Google Spreadsheets

Fast Preview:

Installation

Via Composer:

$ composer require rhincodon/laravel-eloquent-spreadsheets

Register Service Provider in config/app.php:

Rhinodontypicus\EloquentSpreadsheets\EloquentSpreadsheetsServiceProvider::class,

Publish config:

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

Fetch Google Credentials

In Google Console create Service Account:

Step 1:

Step 2:

After pressing Create it will give you credentials file, which you can use in your project. Just save it somewhere in storage.

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.

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.

For now is working add, update, delete actions from app to spreadsheet. And update action from spreadsheet to app. All actions processed in queue.

If you want sync(only update action work) data back to app from spreadsheet, schedule following command:

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

Roadmap

• [ ] Tests

Credits

• rhinodontypicus

License

The MIT License (MIT). Please see License File for more information.