Events and Behaviour Tracking
- How to Create a Synchronized Module
- How to Create a Gmail Promotions Annotation for Emails
- All for adaptivity in email builder
- Editing HTML and CSS
- How to Add Anchor Links to an Email
- Product Blocks Generator
- Adaptive email builder review
- How to Add a Rollover Effect to an Email
- Adding a Video to an Email
- Working with “Images” block
- How to Add Social Media Buttons to an Email
- How to Add a Table to an Email
- How to Add a Background to an Email
- How to Add a Custom Font
- Designing your email
- Scheduled Mobile Push Message
- How to Create Deep Links and Universal Links
- Connecting Mobile Apps with Yespo
- Mobile Push Campaign Report
- How to Create a Mobile App Push Notification
- How to Create a Google Project for Mobile Push Notifications
- Setting Up Delivery and Clicks Analytics
- Managing mobile SDK access keys
- Service Worker. Troubleshooting
- How to Send Web Push Notifications from a Website
- How to Create a Web Push Notification
- How to Set Up Web Pushes for Safari
- How to Create a Google Project to Collect Tokens for Web Push Notifications
- Sending user a personalized Push notification depending on his activity on the website
- How to Set Up Subscription Form for Your Website
- How to Set Up a Pop Up for Your Website
- Integrating widgets with GA
- How to Set up Informers for Your Site
- Creating Pop-ups via Google Tag Manager or WordPress
- How to Set Up Floating Box Widget for Your Website
- Creating a Widget Launcher
- How to Set Up Age Gate Widget for Your Website
- How to Set Up Double Opt-In
- How to Set Up an Automated Birthday Campaign
- Launching a Workflow After a Contact Import
- How to Create a Welcome Email Series
- How to Set Up Notifications for Trigger Control
- How to add scenario to the button
- Workflow Troubleshooting
- How to Automate Customer Reactivation
- How to Launch a Regular Workflow for a Segment
How to Import External Data from Google Sheets
External data sources are used for recommendations in emails and for contact base segmentation.
1. Go to your personal profile > Settings > Data Sources, click New data source and select External data sources.
2. Select Google Sheets.
3. Enter a name and description and insert the link to the corresponding Google Spreadsheet.
Make sure that:
- The file is accessed by anyone with the link, without Google authorization required.
- The first line of the sheet contains headers in Latin.
- The data you will use is contained in the first sheet.
- For multilingual messages, name the file sheets with the corresponding language codes according to ISO 639-1. For example “en” for the content in English.
Specify the default language for the message this data source will be used in. If the default language is not specified, the content in the language of the first sheet will be used in the message.
4. Click Refresh data. Data from the spreadsheet will be available for preview. By default, only the first 10 lines are previewed.
5. Click Advanced settings to specify the number of recommended items that will be displayed in the email. The message will not be sent if the quantity of products in the feed doesn’t match the specified range.
6. Click Save. The created data source will be available in the general list. To remove it, click three dots on the right > Delete.
If you need to edit the data (for example, in case of a typo or no longer valid prices), make necessary edits to the Google Spreadsheet, and click Refresh data in the corresponding data source. Changes will be applied immediately.
How to Add Data from Google Spreadsheet to an Email
The data is added to the email via Velocity.
1. In Messages > Messages, select an email with configured dynamic modules or create a new one.
2. Click the stripe with product cards, click Code editor and insert the code with the corresponding data source as shown below.
3. Make sure the stripe with dynamic content ends with the code <!--#end-->.
4. Specify product parameters from the spreadsheet (name, link, image and prices here) and add their variables to each product card:
- $!item.get('Old Price')
- $!item.get('New Price')
5. To test whether the product data is inserted correctly, send a test email.
If you’ve set everything right, the data from the website will be added at the moment of the launch, and the email would look as follows:
You can change the data in the spreadsheet and refresh the data source, and the updates will be applied immediately. They will be available for new campaigns; products in already sent campaigns will not change.