rhincodon / laravel-eloquent-spreadsheets
Sync Eloquent models with google spreadsheets
Requires
- php: ^7.0
- google/apiclient: ^2.1
- google/apiclient-services: ^0.11.0
- illuminate/bus: ~5.3.0|~5.4.0
- illuminate/console: ~5.3.0|~5.4.0
- illuminate/contracts: ~5.3.0|~5.4.0
- illuminate/queue: ~5.3.0|~5.4.0
- illuminate/support: ~5.3.0|~5.4.0
This package is not auto-updated.
Last update: 2024-10-26 20:32:21 UTC
README
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
License
The MIT License (MIT). Please see License File for more information.