Skip to content

Instantly share code, notes, and snippets.

@ballgoesvroomvroom
Last active May 23, 2022 11:17
Show Gist options
  • Save ballgoesvroomvroom/d744324419e6ff2d569695ab384cf15f to your computer and use it in GitHub Desktop.
Save ballgoesvroomvroom/d744324419e6ff2d569695ab384cf15f to your computer and use it in GitHub Desktop.
maps exported save translations from translate.google.com (exported to google sheets) to a text file for custom parser of my own project
// uses cell range C1:D1 to the last row
// saves as "englishWord : chineseWord : source (translate.google.com)" for parser to interpret
function saveToTextfile() {
var ss = SpreadsheetApp.getActive();
var sh = ss.getActiveSheet();
var rg = sh.getRange(1, 3, sh.getLastRow(), 2);
var vs = rg.getValues();
console.log(vs)
// format data
vs = vs.map(x => `${x[1].toLowerCase()} : ${x[0]} : translate.google.com`);
var folder = DriveApp.getFolderById('1gKOoLeqj8EkJumTsRCQKYxsapK7hxAid')
console.log("folder:", folder)
var files = folder.getFiles();
folder.createFile("savedTranslations.txt", vs.join("\n"));
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment