Sorted
Script to translate a list of words

i have an excel sheet with a few hundred words in English that i would like to translate to Hebrew i couldn’t find a translator that could translate a hole sheet, so i am thinking maybe there is a script that could take each line put it in a translator and paste back the translation,
any help would be gladly appreciated 
I have a different idea,
Google has many unknown features in all of their applications, one of them is translate builtin into Sheets, all you need to do is=GOOGLETRANSLATE(A1, "en", "he")
and you have it translated, then just drag the fill handle at the bottom of the formula cell down to apply this formula to all the cells you want to translate.
simple, uh? 
wow, I was working so hard and the answer was right here.