First steps
User Data
- Responsive Email Editor Review
- Designing your email
- Creating Synchronized Modules
- Setting Up Responsive Email Design
- Setting Up Smart Containers
- Creating a Gmail Promotions Annotation
- Adding The Rollover Effect
- Adding Anchor Links
- Module Library
- Adding a Table to an Email
- Adding Custom Fonts
- Creating CTA Button
- Working with Images
- Creating Timer
- Using AI in the Email Editor
- Messenger Protocol Support in Email Clients and Platforms
Omnichannel
- Setting Up Widgets for Your Site
- Widgets Gamification
- Widget Calling
- Setting Up Locations for the Widget Calling Rules
- Storing data from widgets to contact fields
- Using Annoyance Safeguard
- Actions After Form Submission
- Replacing Double Opt-In System Workflow
- Creating Pop-ups via Google Tag Manager or WordPress
- Sending Yespo Widget Events to Google Analytics
- Using A/B Tests for Widgets
- Collecting Contact Information Using Request Forms
Automation
- Building and Editing Workflows
- Configuring Workflow Start/Stop Conditions
- Start Block
- Popular Blocks
- Message Blocks
- Using One from Many Message Block
- Contact Blocks
- Conditions Blocks
- Other Blocks
- Message to Segment Blocks
- Time Blocks
- Advanced Workflow Block Parameters
- Setting Up Allowed Send Time
- Using Workflow Launch History
- Webhook Workflows
- Workflow Troubleshooting
- Double Opt-In
- Welcome Сampaign
- Welcome Series Segmented by Category
- Launching a Workflow After a Contact Import
- Regular Workflow for a Segment
- Birthday Campaign
- Linking Workflow to the Button
- Using Variables from Order in Workflow
- Collecting Order Feedback
- Customer Reactivation
- Sending Extra Campaigns
- Sending Reminders at the Time Specified by the User
- Sending Campaign to Those Who Did Not Open the Previous One
- Using A/B Tests In Workflows
Personalization
Analytics
- Email Campaign Report
- Web Push Campaign Report
- Viber Campaign Report
- Mobile Push Campaign Report
- App Inbox Campaign Report
- Telegram Campaign Report
- In-App Report
- Widget Report
- Triggered Campaign Report
- AMP Campaign Report
- SMS Campaign Report
- Multilingual Campaign Report
- Setting up UTM Tags
- Revenue from Campaigns
- Tracking Campaign Performance in Google Analytics 4
- Message Analytics
Multilanguage Campaigns
Events and Behaviour Tracking
Recommendations
API
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:
-
Prepare a spreadsheet with your multilingual content.
-
Connect it to your Yespo account.
-
Create a message with variables.
Preparing Spreadsheet
You can place message content on one or several sheets.
1. An example with one sheet:
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:
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:
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.
That's how a user will see this notification in English:
The report on such a message will look like a standard multilanguage report.
