Looking to hire Laravel developers? Try LaraJobs

laravel-google-sheet-i18n maintained by momik

Description
Generate and update Laravel language files using Google Sheets with auto-translation formulas.
Last update
2026/02/14 10:59 (dev-main)
License
Downloads
0

Comments
comments powered by Disqus

Laravel Google Sheets Translator

Manage your Laravel application translations effortlessly using Google Sheets.

Say goodbye to manual JSON editing. Generate and update your language files via Google Sheets, use powerful formulas like =GOOGLETRANSLATE(), and pull them back into your app instantly.

View Documentation

Screenshot Placeholder

Features

  • Smart Generation: Push local keys to Sheets, generate translations, and pull them back.
  • Auto-Translate: Leverage Google Sheets formulas for instant draft translations.
  • Smart Update: Only new keys are added; existing translations are preserved.
  • Formula Support: Preserves your custom formulas and row formatting.
  • Team Collaboration: Share the Sheet link with translators. No Git access needed.
  • Visual Dashboard: Premium UI to generate locales and track progress in real-time.

Requirements

  • PHP: ^8.0
  • Laravel: ^8.0 | ^9.0 | ^10.0 | ^11.0 | ^12.0

Installation

composer require momik/laravel-google-sheet-i18n

Run the interactive installer:

php artisan google-sheet-i18n:install

Google Setup (The "Google Thingy")

To use this package, you need a Google Service Account.

  1. Create Project: Go to Google Cloud Console and create a project.
  2. Enable API: Enable "Google Sheets API".
  3. Service Account: Create a Service Account (APIs & Services > Credentials).
  4. Key: Create a JSON key for the Service Account and download it to your project (e.g., storage/app/google-service-account.json).
  5. Share: Open your Google Sheet and Share it with the client_email from your JSON file (Editor access).

See full guide in docs/google-setup.md.

Configuration (.env)

GOOGLE_SHEET_I18N_ID=your_spreadsheet_id_from_url
GOOGLE_APPLICATION_CREDENTIALS=storage/app/google-service-account.json

Usage

Via CLI

Generate specific locales (e.g., Spanish, French):

php artisan translate:sheet es,fr

Via Browser

Visit /translation-manager to access the visual generation dashboard.

Documentation

Full documentation is available in the docs/ directory.

License

MIT