Login

Omnichannel

Security and Compliance

Using Google Sheets for Multilingual Messaging

Create one message and connect it with the spreadsheet 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 Yespo channels.

Important

To enable this feature, please contact our support team at support@yespo.io

Steps to use Google Sheets for multilingual messaging:

  1. Prepare a spreadsheet with your multilingual content.

  2. Connect it to your Yespo account.

  3. Create a message with variables.

Preparing Spreadsheet

You can place message content on one or several sheets.

1. An example with one sheet:

One sheet example

Values in the first column are language codes, and horizontal values in the first line are keys used in the message. The values of keys for different language versions are placed at the intersection of language codes and keys. The top language is the default, so users without a specified language in their profiles will receive the top language version.

Note

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).

Multilingualism in messages is only supported for some dialects; if you still need to find the one you need, please contact our support at support@yespo.io

2. An example with several sheets:

Several sheets example

The first line contains keys used in the message, and the second line contains values for keys in the corresponding columns. The names of the sheets are language codes according to ISO 639-1 specification.

The first language sheet is the default, so users without a specified language in their profiles will receive the first sheet’s 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:

Multilanguage content table

Connecting Google Sheet to Yespo

See detailed instructions here >

Creating a Message with Variables

Add variables to the message in the following format:

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

where the NAME is your Google Sheets file name, and the subject is a key from the spreadsheet.

Message template with variables

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

How user will see the notification

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

Any Questions?
We’re always happy to help!
Discount services
Schedule a Call
Fill in the form, and our specialists will call you back as soon as possible.
Discount services
Chat Support
We’re waiting for your questions!
Discount services
Email
Contact the support team