How to use Lara Translate App in Google Sheets

Once you’ve installed the Lara Translate App in Google Sheets, you can start translating and evaluating text directly inside your spreadsheets using two powerful functions: LARATRANSLATE and LARAEVAL.

Getting Started

Before using the functions, open the Lara sidebar to configure your default settings.

1. In your Google Sheet, click Extensions > Lara Translate > Open to open the Lara sidebar
2. Sign in to your Lara account if prompted
3. In the Translation Memories section, select the memories you want to apply to this sheet. Click the Refresh icon to sync the latest assets from your Lara account
4. In the Glossaries section, select the glossaries you want to apply
5. In the Style section, select your default translation style (Faithful, Fluid, or Creative)

The selected Translation Memories, Glossaries, and Style are applied as defaults to all LARATRANSLATE functions in the sheet. You can override them for individual cells directly in the formula.

Incognito mode: enable this option from the sidebar to prevent translations from being stored in our logs.

 

Note: If you share the sheet with someone who has editing access, they can trigger LARATRANSLATE and LARAEVAL functions and consume characters from their Lara account.

Team preferences: Team plan users can configure default settings at team level. Team-level defaults apply to all members and can be managed by the team owner from the sidebar.

Translate Text with LARATRANSLATE

Syntax

=LARATRANSLATE(sourceText, [sourceLanguage], targetLanguage, [context], [memories], [glossaries], [style])

 

Parameters

• sourceText — the text to translate, or a cell reference (e.g. A2)
• [sourceLanguage] (optional) — source language code (e.g. "en-US"). If omitted, Lara detects the language automatically
• targetLanguage — target language code (e.g. "fr-FR" for French)
• [context] (optional) — a range of cells with related text to improve translation accuracy
• [memories] (optional) — one or more Translation Memory IDs
• [glossaries] (optional) — one or more Glossary IDs
• [style] (optional) — translation style: "faithful", "fluid", or "creative"

Memories, glossaries, and style can be set directly in the formula instead of configuring them in the sidebar, which allows you to use different assets for each individual cell.

 

Evaluate translation quality with LARAEVAL

Syntax =LARAEVAL(text, translation)

Parameters

• text — the original content (cell reference or string)
• translation — the translated version to evaluate

Walkthrough

1. Enter the source text in a cell (e.g. A2) and the translated text in another (e.g. B2)
2. In a third cell, enter: =LARAEVAL(A2, B2)
3. Lara returns a score from 1 to 3:
   • 1 — major errors (missing text, incorrect meaning, tone issues)
   • 2 — minor or stylistic issues
   • 3 — perfect translation

Note: LARAEVAL evaluates based on the source and target text only. Translation Memories, Glossaries, context, and style are not taken into account.

 

Pricing

To use Lara's functions in Sheets, you need an active Personal or Team plan on laratranslate.com. Pricing is based on input characters processed:

You can monitor your usage and upgrade or top up directly from your Lara account.

 

---

 

This article is about:

• Using the LARATRANSLATE function to translate text in Google Sheets
• Using the LARAEVAL function to evaluate translation quality
• Understanding how evaluation works differently in Sheets vs. on the website
• Knowing the pricing for translations and evaluations in Google Sheets
• Configuring default Translation Memories, Glossaries, and Style from the sidebar
• Using Incognito mode in Google Sheets