google-sheets-i18n-generator


Generate i18n JSON/JS files from a Google Sheets spreadsheet

Installation

$3

npm install --save-dev google-sheets-i18n-generator

$3

yarn add --dev google-sheets-i18n-generator

Usage

1. Create a Google Sheets spreadsheet to store the i18n strings

2. If needed, configure Google Sheets (only the first time):

3. Copy the ID of the spreadsheet (can be found in the URL https://docs.google.com/spreadsheets/d//edit#gid=0)

4. Run the command: gs-i18n

5. If needed, follow the instructions to allow gs-i18n to access your Google Sheets and download the credentials.json files (only the first time)

6. The JSON files are generated in the ./locales folder

To customize the options, see the API section.

API

`
Usage: gs-i18n [options]

Options:
-v, --version output the version number
-b, --beautify number of spaces to insert white space in JSON/JS files (min: 0, max: 10) (default: 0)
-c, --client path of client secret file (default: "./client_secret.json")
-f, --format format of generated files (available values: "cjs", "esm", "json") (default: "json")
-k, --key index of key column (default: 0)
-l, --lang index of first language column (default: 1)
-o, --output path of output directory (default: "./locales")
-r, --range range of data to parse (default: "Sheet1")
-t, --token path of credentials file (default: "./credentials.json")
-h, --help output usage information
``