PHPackages                             vladislavbogomolov/transheet - 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. [Localization & i18n](/categories/localization)
4. /
5. vladislavbogomolov/transheet

ActiveLibrary[Localization & i18n](/categories/localization)

vladislavbogomolov/transheet
============================

Google Sheets as a translation tool

0.1.0(3y ago)117MITPHP

Since Jun 16Pushed 3y ago1 watchersCompare

[ Source](https://github.com/vladislavbogomolov/transheet)[ Packagist](https://packagist.org/packages/vladislavbogomolov/transheet)[ RSS](/packages/vladislavbogomolov-transheet/feed)WikiDiscussions main Synced 2d ago

READMEChangelog (1)Dependencies (1)Versions (2)Used By (0)

[![Contributors](https://camo.githubusercontent.com/19a5e3b0d098027bcec807814498ba8f8395b994ec5a0ecf69ecd08dd573d929/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f636f6e7472696275746f72732f766c616469736c6176626f676f6d6f6c6f762f7472616e73686565742e7376673f7374796c653d666f722d7468652d6261646765)](https://github.com/vladislavbogomolov/transheet/graphs/contributors)[![Forks](https://camo.githubusercontent.com/735751586ebf908c7cc24edac3b48dd47cf4265e8b4532362c2d11208d4ee451/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f666f726b732f766c616469736c6176626f676f6d6f6c6f762f7472616e73686565742e7376673f7374796c653d666f722d7468652d6261646765)](https://github.com/vladislavbogomolov/transheet/network/members)[![Stargazers](https://camo.githubusercontent.com/b97ff5a7765da001cf127d1696de4692542d95fbaaedda4918cef7b7eb513e68/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f73746172732f766c616469736c6176626f676f6d6f6c6f762f7472616e73686565742e7376673f7374796c653d666f722d7468652d6261646765)](https://github.com/vladislavbogomolov/transheet/stargazers)[![Issues](https://camo.githubusercontent.com/7c31f4cb602fb10243788764f35337cfe1ea851c978c6faadeb7b8dfa2597060/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6973737565732f766c616469736c6176626f676f6d6f6c6f762f7472616e73686565742e7376673f7374796c653d666f722d7468652d6261646765)](https://github.com/vladislavbogomolov/transheet/issues)[![MIT License](https://camo.githubusercontent.com/13e7dae724019e6a32ea3c420e2040980d22e221991a8bf8864c597f9a407e01/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f6c6963656e73652f766c616469736c6176626f676f6d6f6c6f762f7472616e73686565742e7376673f7374796c653d666f722d7468652d6261646765)](https://github.com/vladislavbogomolov/transheet/blob/master/LICENSE.txt)[![LinkedIn](https://camo.githubusercontent.com/d52963778220cbec61d6ed72270f9735024ffceeb551e5c3933d4e03b4694cf1/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f2d4c696e6b6564496e2d626c61636b2e7376673f7374796c653d666f722d7468652d6261646765266c6f676f3d6c696e6b6564696e26636f6c6f72423d353535)](https://www.linkedin.com/in/vladbogomolov/)

 [ ![Logo](images/logo.png) ](https://github.com/vladislavbogomolov/transheet)### Transheet

[](#transheet)

 Free solution to manage your translations

 [Report Bug](https://github.com/vladislavbogomolov/transheet/issues) · [Request Feature](https://github.com/vladislavbogomolov/transheet/issues)

Getting Started
---------------

[](#getting-started)

### Enable Google Sheets API and create Service account

[](#enable-google-sheets-api-and-create-service-account)

1. [Go to Console Google Cloud Platform ](https://console.cloud.google.com/apis/library)
2. Enable "Google Sheets API"
3. Click "Manage"
4. Click "Credentials"
5. Click "Create credentials"
6. Click "OAuth client ID"
7. Click "Configure consent screen"
8. Choose "External" > Create
9. Add scopes for "Google Sheets API" `.../auth/drive.file`
10. Save and continue
11. Publish app
12. Click on “Credentials” and choose "OAuth Client ID" from the “Create credentials”
13. Choose "Web application" and click "Create"
14. Click on "Download json", put file in root of your project and rename it in `client_secret.json`
15. Click "Service account"
16. Type "ServiceAccount" in "Service account name" text field
17. Click "Create and continue"
18. Click "Done"
19. Copy EMAIL address of service account created

### Create Spreadsheet

[](#create-spreadsheet)

1. [Start a new spreadsheet](https://docs.google.com/spreadsheets/u/0/create?usp=sheets_home&ths=true)
2. Click "Share" the button into the top right corner
3. Past copied service account email and click "Done"
4. Add to your .env ID of spreadsheet created.

Example:

```
   SPREADSHEETID=1Tu3EvufoNVnnUvRnc-3d-3raww6Z7ti951xegnqlsDM
```

5. Add to your .env sheet name.

Example:

```
   SHEETNAME=Sheet1
```

6. Set A1 with value "key" without double quotes
7. From B1 to Z1 set [ISO 639-1 Code](https://www.loc.gov/standards/iso639-2/php/code_list.php) languages of interest

Example:

[![Product Name Screen Shot](images/screenshot.png)](https://example.com)

### Installation package

[](#installation-package)

1. Install

```
composer require vladislavbogomolov/transheet
```

2. Add into `./config/app.php` file, after `Package Service Providers...` comment

```
Vladislavbogomolov\Transheet\TransheetServiceProvider::class,
```

Usage
-----

[](#usage)

This command will create `transheet.php` in each language folder that will contain translation lists.

```
php artisan transheet:download
```

([back to top](#top))

###  Health Score

19

—

LowBetter than 10% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity37

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

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

Unknown

Total

1

Last Release

1425d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/fd47096af2c39c8f70b3ada74053909a73f4cbb3401e774b84508f9225969df9?d=identicon)[VladislavBogomolov](/maintainers/VladislavBogomolov)

---

Top Contributors

[![vladislavbogomolov](https://avatars.githubusercontent.com/u/11717391?v=4)](https://github.com/vladislavbogomolov "vladislavbogomolov (9 commits)")

### Embed Badge

![Health badge](/badges/vladislavbogomolov-transheet/health.svg)

```
[![Health](https://phpackages.com/badges/vladislavbogomolov-transheet/health.svg)](https://phpackages.com/packages/vladislavbogomolov-transheet)
```

###  Alternatives

[symfony/translation

Provides tools to internationalize your application

6.6k836.5M2.1k](/packages/symfony-translation)[nesbot/carbon

An API extension for DateTime that supports 281 different languages.

169661.4M4.8k](/packages/nesbot-carbon)[joedixon/laravel-translation

A tool for managing all of your Laravel translations

717911.4k11](/packages/joedixon-laravel-translation)[nikaia/translation-sheet

Laravel Translation via Google Spreadsheet

294606.4k1](/packages/nikaia-translation-sheet)[illuminate/translation

The Illuminate Translation package.

6936.4M495](/packages/illuminate-translation)[larswiegers/laravel-translations-checker

Make sure your laravel translations are checked and are included in all languages.

256423.2k2](/packages/larswiegers-laravel-translations-checker)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)