Export JSON Translations

Code.gs

function onInstall(e) {
  onOpen(e);
}

function onOpen(e) {
  var jsonExport = [{name: "Export as JSON translation files", functionName: "runJSONExport"}];
  SpreadsheetApp.getActiveSpreadsheet().addMenu("json", jsonExport);
}

function runJSONExport() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var format = ".json";
  var data = sheet.getDataRange().getValues();

  var keys = [];
  for (var i = 1; i < data.length; i++) {
    keys.push(data[i][0]);
  }
  
  var languages = data[0].slice(1);

  
  var folder = DriveApp.createFolder(sheet.getName());
  
  for (var i = 0; i < languages.length; i++) {
    var jsonContent = {}; 
    for (var k = 0; k < keys.length; k++) {
      var key = new String(keys[k]);
      if(key.trim().length != 0 && key.indexOf("#") !== 0) {
        jsonContent[key] = data[k + 1][i + 1];
      }
    }
    
    var fileName = sheet.getName() + "_" + languages[i] + format;

    folder.createFile(fileName, JSON.stringify(jsonContent));
  }

  Browser.msgBox("Translation exported. Check your drive folder.");
}