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(4y ago)117MITPHP

Since Jun 16Pushed 4y ago1 watchersCompare

[ Source](https://github.com/vladislavbogomolov/transheet)[ Packagist](https://packagist.org/packages/vladislavbogomolov/transheet)[ RSS](/packages/vladislavbogomolov-transheet/feed)WikiDiscussions main Synced 3w 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

20

—

LowBetter than 13% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity7

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity38

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

1479d 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

[flow-php/flow

PHP ETL - Extract Transform Load - Data processing framework

85036.3k](/packages/flow-php-flow)[fleetbase/core-api

Core Framework and Resources for Fleetbase API

1235.9k20](/packages/fleetbase-core-api)[chameleon-system/chameleon-base

The Chameleon System core.

1028.6k5](/packages/chameleon-system-chameleon-base)

PHPackages © 2026

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