PHPackages mechastorm/laravel-lang-google-spreadsheet-importer - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [PDF & Document Generation](/categories/documents) 4. / 5. mechastorm/laravel-lang-google-spreadsheet-importer ActiveLibrary[PDF & Document Generation](/categories/documents) mechastorm/laravel-lang-google-spreadsheet-importer =================================================== Laravel Artisan Command to generate Laravel Languages files from a Google Spreadsheet 1.0.1(11y ago)81221Apache-2.0PHPPHP >=5.4.0 Since Jun 26Pushed 11y ago2 watchersCompare [ Source](https://github.com/mechastorm/laravel-lang-google-spreadsheet-importer)[ Packagist](https://packagist.org/packages/mechastorm/laravel-lang-google-spreadsheet-importer)[ Docs](https://github.com/mechastorm/laravel-lang-google-spreadsheet-importer)[ RSS](/packages/mechastorm-laravel-lang-google-spreadsheet-importer/feed)WikiDiscussions master Synced yesterday READMEChangelogDependencies (2)Versions (4)Used By (0) Introduction ============ [](#introduction) A Laravel (4.1 and above) package in an artisan command, which generates Laravel Languages files from a Google Spreadsheet. It will - read data from a spreadsheet formatted like [this](https://docs.google.com/a/mechaloid.com/spreadsheets/d/1GFQQ0clQRrYEM8_N0vyHeIIWqQdxJlbDe588uf_vlkU/edit#gid=0) - outputs as Laravel Lang files like [these](https://github.com/mechastorm/google-spreadsheet-exporter/tree/master/examples/sample_output) This library serves to simply interface with the Laravel framework. The bulk of the actual work is being done by key dependecies. Requirements ============ [](#requirements) - Laravel >4.1 - PHP >5.4 - Composer Dependencies - [Google Spreadsheet Exporter](https://github.com/mechastorm/google-spreadsheet-exporter) - This is where the bulk of the logic lies. So majority of the documenation on the format of the spreadsheet and how it is being parse can be found there - [Google Spreadsheet API Client](https://github.com/asimlqt/php-google-spreadsheet-client) - [The official Google Api Client](https://github.com/google/google-api-php-client) - A readable Google Spreadsheet - The Spreadsheet MUST be the new format (aka Google Sheets) to be compatible - Must be shared with the client email (further details on how to generate one below) Background ========== [](#background) The aim is to - Avoid hard coding copy text - Reduce the dev cycle required when doing edits to copy text - Nicely handle multiple translations of a copy text Further background can be found under the [Google Spreadsheet Exporter](https://github.com/mechastorm/google-spreadsheet-exporter). Especially read up on setting up your Google API client credentials. Todo ==== [](#todo) - Finalize codebase via usage on a Laravel Application - Documentaion - How to setup Google API credentials - Usage - Contributing - PhpUnit Tests Installation ============ [](#installation) Installation is primary via composer. Create a composer.json file in your project and add the following: ``` { "repositories": [ { "type": "vcs", "url": "https://github.com/asimlqt/php-google-spreadsheet-client" }, { "type": "vcs", "url": "https://github.com/mechastorm/google-spreadsheet-exporter" } ], "require": { "mechastorm/laravel-lang-google-spreadsheet-importer": "1.*" } } ``` 1. Add to service provider -------------------------- [](#1-add-to-service-provider) Once you have the package installed you'll need to add it to your providers in `app/config/app.php` Example ``` 'providers' => array( 'Mechastorm\LaravelLangGoogleSpreadsheetImporter\LaravelLangGoogleSpreadsheetImporterServiceProvider', ), ``` Then confirm the artisan command exist by running `php artisan list` and check if there is a command for `google-spreadsheet:generate-lang` in the output. 2. Publish Configuration and Configure -------------------------------------- [](#2-publish-configuration-and-configure) It's recommended that you publish the packages configuration. ``` php artisan config:publish mechastorm/laravel-lang-google-spreadsheet-importer ``` You should open app/config/packages/mechastorm/laravel-lang-google-spreadsheet-importer/config.php and add in details on your spreadsheet and google api access. For details on what/how to add these configs, go to this main [readme](https://github.com/mechastorm/google-spreadsheet-exporter) for more info especially on getting Google API credentials. It is strong recommended to do separate configurations per environment. Usage ===== [](#usage) Assuming you have already installed and configured it correctly, you can just run the artisan command to generate the language files ``` php artisan google-spreadsheet:generate-lang ``` or with enviroment ``` php artisan google-spreadsheet:generate-lang --env={env_name} ``` Tests ===== [](#tests) Coming Soon! Contributors ============ [](#contributors) - Shih Oon Liong (@mechastorm) License ------- [](#license) Released under the [Apache 2.0 license](http://choosealicense.com/licenses/apache-2.0/). ### Health Score 29 — LowBetter than 60% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity16 Limited adoption so far Community5 Small or concentrated contributor base Maturity60 Established project with proven stability How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~0 days Total 2 Last Release 4338d ago ### Community Maintainers ![](https://avatars.githubusercontent.com/u/1383297?v=4)[Shih Oon Liong](/maintainers/mechastorm)[@mechastorm](https://github.com/mechastorm) --- Tags laravellocalizationgoogleartisanspreadsheet ### Embed Badge ![Health badge](/badges/mechastorm-laravel-lang-google-spreadsheet-importer/health.svg) ``` [![Health](https://phpackages.com/badges/mechastorm-laravel-lang-google-spreadsheet-importer/health.svg)](https://phpackages.com/packages/mechastorm-laravel-lang-google-spreadsheet-importer) ``` ### Alternatives [maatwebsite/excel Supercharged Excel exports and imports in Laravel 12.7k144.3M712](/packages/maatwebsite-excel)[barryvdh/laravel-dompdf A DOMPDF Wrapper for Laravel 7.3k87.6M278](/packages/barryvdh-laravel-dompdf)[barryvdh/laravel-snappy Snappy PDF/Image for Laravel 2.8k24.8M48](/packages/barryvdh-laravel-snappy)[lukasss93/laravel-larex Translate your Laravel application from a single CSV file! 9790.3k2](/packages/lukasss93-laravel-larex)[highsolutions/laravel-lang-import-export A Laravel package providing artisan commands to import and export language files from and to CSV. 25292.3k](/packages/highsolutions-laravel-lang-import-export)[avadim/fast-excel-laravel Lightweight and very fast XLSX Excel Spreadsheet Export/Import for Laravel 4146.7k1](/packages/avadim-fast-excel-laravel) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)