node package manager
Share your code. npm Orgs help your team discover, share, and reuse code. Create a free org »


THIS PROJECT IS A FORK OF theoephraim/grunt-i18n-gspreadsheet UPDATED FOR GULP


Gulp plugin to generate i18n locale files from a google spreadsheet

Getting Started

This plugin requires Gulp

You may install this plugin with this command:

npm install gulp-i18n-gspreadsheet --save-dev

Once the plugin has been installed, it may be enabled inside your Gruntfile with this line of JavaScript:

var i18n = require('gulp-i18n-gspreadsheet');

The "i18n_gspreadsheet" task


In your project's gulpfile, use the function i18n_gspreadsheet.

        // options go here. 


NOTE: Auth is required. You can either set up auth in your gulpfile.


Type: String

The Google API private key id to use for authentication.


Type: String

The Google API private key to use for authentication.

NOTE: You should never commit your private_key into your git repo. Rather you should use an ENV variable.


Type: String

The Google API email to use for authentication. This account must have read access to the spreadsheet you want to pull the translations from.


Type: String

The Google API client id to use for authentication.


Type: String (required)

The spreadsheet key. You can get this from the URL while viewing your spreadsheet


Type: String

The column header for special translation keys. Some explanation:

When using i18n plugins, usually one writes __('Thing to translate'). The key in this case is the thing to be translated in the default language. But sometimes for longer items of text, you may want to use a special string. For example, __('!ABOUT.BIO'). In your spreadsheet, you can have one column that is used to hold these special keys. This option allows you to enable this feature and set the name the column to use.

NOTE Google spreadsheets API alters column headers slightly. It will force all lower case and remove all spaces/special characters. For example "My Column Header!" would become "mycolumnheader". It is recommended to just use a column name in this format already, but if you cannot, you may need to debug a little to figure out the column name that the api is using.


Type: String -- Default: 'en'

A string value to signify which locale is the default - useful in conjunction with the write_default_translations option (below).


Type: Boolean -- Default: false

Whether to include default translations or not. Normally the default language translations are used as the translation keys, and most i18n plugins will display this translation key if no translation is found - making it unnecessary to have a file full of redundant pairs like "About us": "About us". This option tells the plugin to write these redundant pairs to the default language file anyway. Might be useful for someone.


Type: Boolean -- Default: true

Enable/disable sorting of the translation keys before writing to the file. If false, translations will appear in the same order as they do in the spreadsheet.


You can set a regex filter if you want to update just a subset of your translation keys. For example: Type: String -- Default: undefined

Usage Examples

Most likely, you will just be writing a single set of locale files from a single google spreadsheet, and don't need to set the defaults. For example:

        private_key_id: 'xxx',
        private_key: '-----BEGIN PRIVATE KEY-----\xxx\n-----END PRIVATE KEY-----\n',
        client_email: '',
        client_id: '',
        type: 'service_account',
        document_key: '0Araic6gTol6SdEtwb1Badl92c2tlek45OUxJZDlyN2c'

Spreadsheet Format

Each locale must have a column name that is 2 letters long (for example: 'en', 'es', 'fr'). The main key column should by default have a title of key, but this can be overridden using the key_column option. You may include other columns in your spreadsheet if you wish -- they will be ignored. This can be useful for notes and grouping things together by where they are being used in your site.

See the testing example for a clear example.

NOTE This plugin will have problems if you need to use indonesian translations because its locale code is id and google spreadsheets API returns a column called id by default. This has not been tested or verified...

Release History

0.0.1 -- Initial release