use google translate in sheets

How to use Google Translate directly in Google Sheets
do you know there is a formula that makes google translate translate a series of words directly in google sheets? if not, read the following article.