Languages Supported in Google Translate

The multilingual chat program in Google Sheets internally uses the Language App service to perform the translation. When a user enters any text, the onEdit() method is triggered which performs the translation and updates the sheet.

You can also use the GoogleTranslate() formula to perform inline language translations without using Google Apps Script. And you can perform translation in all languages that are supported by Google Translate.


function onEdit(e) {
  
  try {
    
    var cell = e.range.getA1Notation();
    
    if ( e.value && (cell === "A6" || cell === "E6") ) {
      
      var sheet = e.source.getActiveSheet();
      var data = sheet.getRange("C4:G5").getValues();
      
      var langA  = getLanguage(data[1][0]);
      var langB  = getLanguage(data[1][4]);
      
      if (langA === "" || langB === "") {
        Browser.msgBox("Please select the languages of participants from the dropdowns in cell C5 and G5");
        return;
      }
      
      if (langA === langB) {
        Browser.msgBox("Please select a different language for each chat participant");
        return;
      }
      
      var userA = data[0][0];
      var userB = data[0][4];
      
      var colA, colB;
      
      if (cell === "A6") {
        colA = userA + ": " + e.value;
        colB = userA + ": " + LanguageApp.translate(e.value, langA, langB);
      } else {
        colA = userB + ": " + LanguageApp.translate(e.value, langB, langA);
        colB = userB + ": " + e.value;
      }
      
      sheet.appendRow([colA, "", "", "", colB]);
      
      e.range.clearContent();
      
    }
  } catch (error) {
    Browser.msg(error.toString());
  }
}

Google Translate Languages

This is a list of languages and their ISO languages Codes that are currently supported by Google Translate. When sending the translation request to the Language Translation API, as in the case of translating RSS Feeds, always make sure that the two language codes are different.

Language NameCodeLanguage NameLanguage Code
AfrikaansafIrishga
AlbaniansqItalianit
ArabicarJapaneseja
AzerbaijaniazKannadakn
BasqueeuKoreanko
BengalibnLatinla
BelarusianbeLatvianlv
BulgarianbgLithuanianlt
CatalancaMacedonianmk
Chinese Simplifiedzh-CNMalayms
Chinese Traditionalzh-TWMaltesemt
CroatianhrNorwegianno
CzechcsPersianfa
DanishdaPolishpl
DutchnlPortuguesept
EnglishenRomanianro
EsperantoeoRussianru
EstonianetSerbiansr
FilipinotlSlovaksk
FinnishfiSloveniansl
FrenchfrSpanishes
GalicianglSwahilisw
GeorgiankaSwedishsv
GermandeTamilta
GreekelTelugute
GujaratiguThaith
Haitian CreolehtTurkishtr
HebrewiwUkrainianuk
HindihiUrduur
HungarianhuVietnamesevi
IcelandicisWelshcy
IndonesianidYiddishyi