With my copy in column B, starting in cell B2, and with the language short codes “en” for the original language and “no” for Norwegian – what I want to translate the English into, in cells E1 and F1 respectively, the code I place in cell D2 is:
=GOOGLETRANSLATE(B2,$E$1,$F$1)
I can drag the formula down to translate all the English in column B.
That’s it really
By the way – if you have a site that’s randomly in 2 languages, or more – you can use detect language Google Sheets function
=DETECTLANGUAGE(“cellnumber”)