GOOGLETRANSLATE function

Ask for Help
1

Doesn’t GOOGLETRANSLATE function work with ARRAYFORMULA?

1 Like
2

Doesn’t looks like it, but this post might have a possible solution.

1 Like
3

Unfortunately the informed solution was not helpful

4

Hi @Alex_Calandrino, that’s strange that you are saying the solution from the article @Jeff_Hager suggested didn’t work.
I’ve tried the formula below for my file - it translates complete column A from russian to german and it works perfectly.

ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(
GOOGLETRANSLATE(TEXTJOIN(". ", 1, A1:A), “RU”, “de”), “.”))))

8 Likes
5

This is amazing! Thanks @NataliaGo @Jeff_Hager for sharing

3 Likes
6

This is not work for
ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(
GOOGLETRANSLATE(TEXTJOIN(". ", 1, A:Z), “RU”, “de”), “.”))))

any one can help ??

7

I made a sample for you, so you could copy paste it. you have at least one mistake, it’s not A:Z, it should be one column. https://docs.google.com/spreadsheets/d/1j7UL3vS1GiBVUCwkP-89ZXegetjnvPjoIVZXkfvCfNU/edit?usp=sharing

3 Likes
8

Depending on your country, you may also need to use semicolons (;) instead of commas (,) in your formulas.

9

Thanks !
But When I select range A2:A Error come … "Text result of TEXTJOIN is longer then the limit of 50000 characters.

10

That means you exceeded the limits of Google sheets. The formula creates one long string of characters before splitting it up into separate rows. That string is more than 50000 characters. You may have to restructure your sheet or find a script that will perform the translations.