Manage Translations

The Manage translations feature lets you work with language versions of email messages outside the editor.

You can work with translations using:

  • local xlsx and csv files;
  • Google Sheets.
šŸ“˜

Note

The Manage translations feature is available only if the message contains at least two language versions.

Export Texts for Translation

  1. Open the email message in the editor.
  2. On the Message management panel, click the language switcher.
  3. Select Manage translations.
Email editor language dropdown open with the Manage translations button highlighted.
  1. Choose the export option.

Export to Google Sheets

  1. Click Export to Google Drive.
Manage translations dialog with the Export to Google Drive button highlighted under step 1, Export your email content.
  1. Choose the export option:
  • To an existing spreadsheet — updates translations in an existing Google Spreadsheet.
  • To a new spreadsheet — creates a new Google Spreadsheet in Google Drive.
Export to Google Drive dialog with the Export to existing spreadsheet and Create a new spreadsheet options highlighted.
šŸ“˜

Note

When working with Google Drive for the first time, add a Google account and grant the required permissions.

  1. Select the account to connect to Google Drive.
Export to Google Drive dialog with the marketing.docs@gmail.com account selected and highlighted.
  1. Select a Google Spreadsheet.
Select a file dialog showing the Translations_example spreadsheet highlighted in Google Drive with the Select button highlighted.
  1. If you export translations to an existing Google Spreadsheet, select the required sheet or create a new one..
Export to Google Drive dialog showing the Translations_example file with the Worksheet dropdown set to Export to new worksheet, and Continue highlighted.

Export to Computer

  1. Download the file in .xlsx or .csv format.
Manage translations dialog with the Download .xlsx button and a Download .csv dropdown option both highlighted.

Edit Translations

  1. Open translations file.
Export to Google Drive success dialog confirming translations exported, with the Open translations file button highlighted.

The translation file contains a sheet with the following columns:

  • message_id – the message identifier in the system;
  • key – a unique key of the text element;
  • language — a separate column for each language version with translated texts.
šŸ“˜

Note

If a translation is missing, the language column remains empty.

Translations spreadsheet showing message, key, en, and es columns with sample rows of translation keys and English text.
  1. Enter translations in the corresponding language columns.
ā—ļø

Important

To ensure correct import, do not:

  • change column names;
  • delete or edit values in the message_id and key columns;
  • modify service rows: previewLink, messageName, workflowId, workflowName;
  • change the order of rows.

Import Translations

In the Manage translations window, choose the import option — from Google Sheets or from your computer.

Manage translations dialog with the Import from Google Drive and Upload file buttons highlighted under step 3, Import translations.

Import from Google Sheets

  1. Select an account.
Select an account to connect to Google Drive dialog with marketing.docs@gmail.com selected and Continue highlighted.
  1. Select a Google Spreadsheet.
Select a file dialog showing the Translations_example spreadsheet highlighted in Google Drive with the Select button highlighted.
šŸ“˜

Note

For files with multiple sheets, you can select the required sheet with translations.

  1. Select the sheet with translations and click Review.
Import from Google Drive dialog with a worksheet selected in the dropdown and the Review button highlighted.

Import from Computer

  1. Drag and drop the file into the upload area or click to select it from your computer.
Upload file dialog with the drag-and-drop upload area and Review button highlighted.
  1. Select the sheet with translations and click Review.
Upload file dialog showing the uploaded translations spreadsheet with the translations worksheet selected and the Review button highlighted.

Complete Import

The system will validate the file and prepare the content for import.

  1. Click Import.
Upload file dialog showing translations loaded successfully with English and Spanish language tags found, and the Import button highlighted.
  1. Click Review applied translations and return to message editing.
Import complete confirmation screen with the Review applied translations button highlighted.

View a Language Version

  1. In the message editor, click the language switcher.
  2. Select the required language version.
Email editor language dropdown open with the Spanish language version highlighted for selection.

Imported translations will appear in the message.

Email editor showing the Spanish language version with translated subject and body text, including a Confirmar mi correo electrónico button.

Did this page help you?