Translate content using Gemini from Google Sheets in 2024

Use GEMINI(prompt) function to translate your text any language

  1. Get content of the site using web functions


  2. After that let’s use AI for translation the content

=GEMINI(“Translate content into French” & A35)

where A35 is content of your scrapped site


  1. Go to the GPT for Sheets.

  2. Click Install. Install-GPT-Mistral-Gemini-Claude-for-Sheets