Translate cells in a google sheet
Budget: €8 – €30 EUR
Create a Google App script to translate all cells in a sheet (an example sheet will be provided upon assignment).
The script needs to detect the actieve sheet. Only the columns with yellow headers need to be translated.
Use deepl.com to translate (not the API). This is an example url, to translate a text from English to Spanish: https://www.deepl.com/translator#en/es/this%20is%20a%20test%20%0A. Scrape the translation from the html page and insert in the corresponding cell of the sheet.
If the text in a cell is longer than 5000 characters: trim the text to 5000, translate the shortened text and mark the cell background red.
The script needs to detect the actieve sheet. Only the columns with yellow headers need to be translated.
Use deepl.com to translate (not the API). This is an example url, to translate a text from English to Spanish: https://www.deepl.com/translator#en/es/this%20is%20a%20test%20%0A. Scrape the translation from the html page and insert in the corresponding cell of the sheet.
If the text in a cell is longer than 5000 characters: trim the text to 5000, translate the shortened text and mark the cell background red.