Laravel Eloquent sync with Google Spreadsheets
$ composer require rhincodon/laravel-eloquent-spreadsheets
Register Service Provider in
php artisan vendor:publish --provider="Rhinodontypicus\EloquentSpreadsheets\EloquentSpreadsheetsServiceProvider" --tag="config"
Fetch Google Credentials
In Google Console create Service Account:
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.
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:
The MIT License (MIT). Please see License File for more information.