Using Google Sheets for Multilanguage Messaging

Suggest Edits

Create one message and connect it with the table with your multilingual content — the system will automatically send a message version depending on the user’s profile language. Suitable for both bulk and triggered campaigns in all Reteno’s channels

📘

Important

To enable this feature, please contact our support team

Steps to use Google Sheets for multilanguage messaging:

  1. Create Google Sheet with your multilingual content.

  2. Connect it to your Reteno account.

  3. Build a message template with variables.

Creating Google Sheet

You can place message content on one or several sheets, each sheet for one language.

  1. An example with one sheet:

where vertical values are language codes, and horizontal values are keys used in the message.
Name the file sheets with the corresponding language codes according to ISO 639-1 (e.g., en) or RFC 5646 for dialects (e.g., es-MX).

📘

Note

Multilingualism in messages is not supported for all dialects, if you did not find the one you need, please contact our support at [email protected]

The value of the given key for the given language version is placed at the intersection of language codes and keys.

The first language is the default, so users without specified language in their system profile will receive this language version.

  1. An example with several sheets:

where horizontal values are keys used in the message, and line 2 is the value of the given key for the given language version. The names of the sheets are language codes according to ISO 639-1 specification.

The first language sheet is the default, so users without specified language in their system profile will receive this language version.

Let’s create a table for the multilingual mobile push campaign with such content:

  • The subject: Just before you go
  • The main text: Try out our new educational games with 25% off for 1 month
    And the same content in Ukrainian and Spanish.
    The table will look like this:

Connecting Google Sheet to Reteno

See detailed instructions here >

Build a Message Template with Variables

To use the Google Sheet data source in a message, you need to add variables in it like this:

$data.get('NAME').get(0).get('subject'),

where the NAME _is your Google Sheet file name, and the _subject is a key from the table.

That's how a user will see this notification in English:

The report on such a message will look like a standard multilanguage report.

Updated 5 months ago