Translate JP to EN by using GAS

[T-Shigenori]

I am making automation which automatically translate Japanese to English through call script , GAS.

I want to make system that when puting some Japsense words in one column, English is returned to another column,

So, could you tell me GAS code in this case?

[Aurelien]

Hi @T-Shigenori 

Maybe this ?

Class LanguageApp  |  Apps Script  |  Google Developers

Note this is a Google Apps Script question, not AppSheet 🙂

[T-Shigenori]

// The code below will write "Esta es una prueba" to the log.
var spanish = LanguageApp.translate('This is a test', 'en', 'es');
Logger.log(spanish); 

the above link , how should I pass arguments from appsheet to GAS code function?

the above example, 'This is a test' is fixed word, how should I revise code for passing arguments from Appsheet?

On the other hand,  another web site shows some example,

function translateJPtoEN() {
//簡単な日本語の文章を翻訳する
let text = "トンネルを抜けると、そこは雪国だった。";
//translate関数で日本語→英語に英訳
let transText = LanguageApp.translate(text,'','en');
//翻訳した英文をログ表示する
console.log(transText);
}

the above case, is it possible to revise it to pass the arguments from appsheet to code?

[Aurelien]

OK.

You may want to consider using the "Call a script" and "return value".

Here is the documentation:

Call Apps Script from an automation - AppSheet Help

The section "Add and configure the "Call a script" task in a bot" indicates how to pass parameter to your function translateJPtoEN.

Then, you can use this if you need it:

Use return values from Apps Script tasks - AppSheet Help