Step 1: Install Gemini AI for Sheets Add-on
Install it from Google Workspace Marketplace.
Step 2: Set Custom Instruction
In this example, we use “Be concise, don’t explain yourself.” as the custom instruction to make sure the AI just do the translation without adding other text.
Step 3: Using TRANSLATE Formula
Using the =TRANSLATE AI Formula and wait for few seconds.
Step 5: TRANSLATED
You now have the tool for bulk translation in just a few clicks.