1
Download a christmas invitation template from
slidesgo OR
canva into google slides
In canva, once you select christmas invitation card template, connect your google drive with canva & click share to google drive. If you are using slidesgo, just download the card template slide and open it in google slides. You can create your own template as well. Put data that you want to replace in '{{ }}'.
2
Paste Spreadsheet URL containing the data
Open the add-on in the google slide that has the template. Copy the link of the spreadsheet containing data you want to put on the card or certificate template. Paste this link in the spreadsheet url box in the add-on.
3
Map Column Names to Variables in Slides™
You will see slide data on left. And a dropdown containing spreadsheet column names on right. Map slide data to the column name you want to replace with.
4
Add or edit the Gmail™ template
Add a gmail template containing subject and the mail body. You can personalize it by using {{column name}}
5
Click to send emails
Once done, click on 'Test Template' to first check and confirm how your email will look. If satisfied, click on 'Create Certificate' to create and send all the cards, invitations, certificates in seconds.