GOOGLETRANSLATE function

Doesn’t GOOGLETRANSLATE function work with ARRAYFORMULA?

1 Like

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

1 Like

Unfortunately the informed solution was not helpful

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”), “.”))))

5 Likes

This is amazing! Thanks @NataliaGo @Jeff_Hager for sharing

2 Likes