The important step before we launch a personalized video email campaign is preparing the spreadsheet.
Open a new spreadsheet.
Fill the customer data into various columns with column titles.
For instance, the data can first name, last name, image, role, city, zip, and any other attributes you want to include in your video.
Make sure you have named all the columns for the merge fields to work accordingly.
A sample spreadsheet
Once you have your spreadsheet ready, allow Hippo Video to access your Drive and import the file from ‘VIDEO CAMPAIGNS.’ We support csv, xls, and xlsx file formats.