How to Translate Text and Detect Language without using paid tools

Hello makers,
This will help you in Translating Text And Detecting Text Language.
I was once needed to translate text in my scenario. after finding that Make doesn’t have any free to use Tool for Language Detection and Translation like Zapier does. so i tried using Google translator, but this module works only with API integration. After not getting a good solution i tried this Solution that works for me, and i hope it will for you too if you’ve not found one.
A text string of a maximum of 5000 characters can be translated using Google Translate, and I hope, the same limit applies for this translate function on Google Sheets, as well.

Send your Text to Google sheets Add Row function.
Formulas and Usage

To detect Text Language:
=DETECTLANGUAGE(“Sample Text”) When selecting cells =DETECTLANGUAGE(A1:A10)

Output will be like “en” or anything in 2 digits

To Trnslate Text Language
=GOOGLETRANSLATE(“Sample Text”,“en”,“es”)
=GOOGLETRANSLATE(Sample Text,[source_language],[target_language])

Sample Text- The text to translate.
The value for Sample Text must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.

Source_language - The two-letter language code of the source language, e.g. “en” for English or “ko” for Korean, or “auto” to auto-detect the language.
Target_language - Same as above

To get translated text back to scenario, Use Google sheets Get cell or Search row module.

That’s it. Happy Making… Make it #withMake