During the build process for the website, we run this script: https://github.com/w3champions/website/blob/master/scripts/generate-locales.ts
This does:
Connects to this google sheet: https://docs.google.com/spreadsheets/d/1V5f4zguWDmk9nbnoXSJm9g-ZxImo83NJpSY17EUkzOc/edit#gid=0
Reads all the data from the first sheet
Deepmerges it with the JSON in this file: https://github.com/w3champions/website/blob/master/src/locales/data.ts
Saves to disk
...
Once the translator has completed all the cells on the translation tables: https://docs.google.com/spreadsheets/d/1V5f4zguWDmk9nbnoXSJm9g-ZxImo83NJpSY17EUkzOc/edit#gid=0
Add the language to the active languages array in the constants file: https://github.com/w3champions/website/blob/master/src/constants.ts#L4
Add the flag for the localization in the
localeFlagsfolder: https://github.com/w3champions/website/tree/master/src/assets/localeFlagsWe use the flags from this resource: https://github.com/HatScripts/circle-flags
Rebuild & Deploy!