Download the PHP package enflow/laravel-excel-to-google-sheet without Composer

On this page you can find all versions of the php package enflow/laravel-excel-to-google-sheet. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of enflow/laravel-excel-to-google-sheet

Informations about the package laravel-excel-to-google-sheet

Push Laravel Excel exporters to Google Sheets

Latest Version on Packagist Total Downloads

The enflow/laravel-excel-to-google-sheet package provides an easy way to push Laravel Excel exporters to Google Sheet. Use-cases include creating a Laravel Export to be exported in your application layer, which also needs to be periodically synced to a remote Google Sheet.

Installation

You can install the package via composer:

Authentication

The package uses the Google Client PHP library in the background. Authenticating with Google requires a Google Cloud Console account. Via the Google Cloud Console account, you must have a valid project, where the Google Spreadsheet API is enabled. To export the required JSON credentials, you can follow the steps below: 1) Go to the Google Cloud Console 2) Create a new project or select an existing project 3) Go to APIs & Services > Credentials 4) Click Create Credentials > Service account 5) Choose Spreadsheet API for the scope. 6) Fill in the required fields and click Create 7) Select the created service account and click Add key > Create new key 8) Select JSON and click Create 9) The JSON file will be downloaded to your computer 10) Copy the contents of the JSON file and place it in a secure place. We recommend storage/secrets/google-service-account.json

Implementation

To start, publish the config file:

After, you can add your existing Laravel Excel export classes to the exports array:

After setting up the exports, we recommend running php artisan push-export-to-google-sheets to validate the exports are pushed correctly.

To periodically schedule a push from your Laravel Excel export to a Google Sheet, you can schedule the Enflow\LaravelExcelToGoogleSheet\PushAllExportsToGoogleSheets command. This will send all defined exports to their Google Sheets. For instance:

Testing

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

Credits

About Enflow

Enflow is a digital creative agency based in Alphen aan den Rijn, Netherlands. We specialize in developing web applications, mobile applications and websites. You can find more info on our website.

License

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

All versions of laravel-excel-to-google-sheet with dependencies

PHP Build Version
Package Version
Requires php Version ^8.2
google/apiclient Version ^2.13
laravel/framework Version ^10.0|^11.0
maatwebsite/excel Version ^3.1
spatie/laravel-package-tools Version ^1.15
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package enflow/laravel-excel-to-google-sheet contains the following files

Loading the files please wait ....