TRANSLATE

Translate a spreadsheet range to another language using ChatGPT

Utilize ChatGPT's capabilities to quickly translate values in a Google Sheets range into any language, regardless of the original source language, while ensuring high-quality results. This allows for the provision of additional context or instructions to ensure accurate translation.

Examples

Arguments List

=TRANSLATE_X(range, output_language, [options])
=TRANSLATE_Y(range, output_language, [options])

Options List

Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"extra_instructions","Remember this info: " & A1; "temperature",0.4}

mode

The mode determines the outcome, efficiency, and expense of executing Smart Functions by tailoring ChatGPT's instructions and predefining additional parameter settings.

Fast (default): Focus on the speed.

Professional: Focus on the quality of the translation.

Options: "fast" or "professional"

temperature

Adjust the translation style from 0 (literal word-for-word translation) to 1 (creative translation) to control the balance between precision and creativity in the output.

For Example: 0, 0.4, or 1

extra_instructions

Additional context or instructions for ChatGPT to achieve a more accurate translation.
For example: "Remember about using the metric system", "Use English design terms", or "Remember this: " & B2

model

Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default, and here it's gpt-4. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"

in_parallel

For each cell: Enhances translation efficiency in Google Sheets by processing each cell with separate ChatGPT requests, though this might cause a loss of overall context.

None: Aggregates all cells in the spreadsheet range into one request for translation, possibly leading to larger requests but ensuring context consistency for more coherent translations.

Options: "default", "max", or "none"

max_tokens

Limit the maximum number of tokens that can be utilized in the ChatGPT function execution. By default, this limit is set based on the type of call, helping to safeguard your account against unnecessary expenses.

1 token ≈ 4 chars in English
1 token ≈ 3/4 words
100 tokens ≈ 75 words
1-2 sentences ≈ 30 tokens
1 paragraph ≈ 100 tokens
1,500 words ≈ 2048 tokens
For Example: 100, 350, or 2048

generate

If set to TRUE, the formula will execute the calculation. If set to FALSE, a warning message will appear instead of the translation. To prevent unintended expenses, link this parameter to a Google Sheet cell with a checkbox or an input-verifying formula.

For Example: TRUE, FALSE, or $H$1

generate_warning

This text will appear when 'generate' is set to FALSE. As a best practice, include instructions on what actions are required to proceed with translation. Use the codeword [STOP] to halt the calculation of related formulas; this will not be visible to the user. Use the word "default" to display a standard warning message.

For Example: "default", "Fill out Output Language", or $A1

Sidebar Options

Due to Google Sheets' constraints, certain features are unavailable for Smart Formulas. Nonetheless, these features are accessible through Smart Functions found in the Websheet AI sidebar.