vladislavbogomolov/transheet

Google Sheets as a translation tool

0.1.0 2022-06-16 22:26 UTC

Requires

• google/apiclient: ^v2.12.5

MIT

• Vladislav Bogomolov

README

Transheet

Free solution to manage your translations

Report Bug · Request Feature

Getting Started

Enable Google Sheets API and create Service account

1. Go to Console Google Cloud Platform
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

1. Start a new spreadsheet
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

1. Add to your .env sheet name.

Example:

   SHEETNAME=Sheet1

1. Set A1 with value "key" without double quotes
2. From B1 to Z1 set ISO 639-1 Code languages of interest

Example:

Installation package

1. Install

composer require vladislavbogomolov/transheet

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

Vladislavbogomolov\Transheet\TransheetServiceProvider::class,

Usage

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

php artisan transheet:download

(back to top)