Edit

Translation workflow

Script groups

On the high level the script consists of the following actions.

1. Open the spreadsheet and grab data to be translated and languages to translate.
2. Open Google Translate and translate the phrases online.
3. Save the translated phrases back to the spreadsheet.

Let's explore these steps in detail.

Script workflow

In this example, phrases from the .xlsx file are translated into Google Translate and the results are saved in the same file.

note

Input file requirements are as follows:

• The file should contain short abbreviations for input and output languages in cells A1 and B1, for example: en, es, de, etc.
• Input phrases should be in column 'A', beginning with the second row.

1. The Open Spreadsheet action opens the .xlsx file in the background to read phrases and gets the languages to translate.

2. The Get Column action saves the first column from a file into a List variable.

3. The Get Cell Value action obtains the language in which the first column will be translated. We get the value from the first cell of column 'B' and store it in the str_translate_tovariable.

4. The Constant Value action gets the value from the first cell in the first column and stores this value in the str_translate_fromvariable.

5. The For Each loop performs actions for all values from list_input_phrases, starting with the second element.

6. The Open Website action opens translate.google.com with certain parameters. In the Site URL field, we use variables that contain the languages required for translation.

7. Web Element - Set value - sets the current input phrase from the list_input_phrases variable.

8. Web Element - Get value - gets the output phrase and stores it in the translated variable.

9. Expression value adds the output variable to the list_output_phrases variable.

10. The Open Spreadsheet action opens the .xlsx file to add translated phrases.

11. The Set Active Cell action sets the active cell to add translated phrases to the second column of the table.

12. The For Each loop performs actions for all values fromlist_output_phrases.

13. The Set Сell Value action sets the list_output_phrasesvalue in the cell under the active one.