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

    =WEB_URL(“https://docgpt.ai”)

  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

Prerequisites

  1. Go to the GPT for Sheets.

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