1
To create a certificate of merit for outstanding group performance, choose a fun and creative template on
Canva or
slidesgo.
Use placeholders like "{{ }}" to replace the default information with your own details. After customization, share the certificate to Google Drive by clicking "Share to Google Drive" on Canva or download it on Slidesgo. Happy designing!
2
Paste Spreadsheet URL containing the data
To import data from a Google spreadsheet to a certificate template on Google Slides, launch the add-on in the template and copy the spreadsheet's link. Paste the link to the add-on's spreadsheet URL box to start the data import process. This approach will make information transfer from the spreadsheet to the template more efficient and accurate, leading to professional results.
3
Map Column Names to Variables in Slides™
Your slide's data is on the left side of the screen, and the right side shows a dropdown menu with the names of columns from your spreadsheet. Choose the right column from the dropdown menu that corresponds to the data on your slide to replace it with the data from the spreadsheet.
4
Add or edit the Gmail™ template
Make a Gmail template with a subject line and mail body, and use placeholders like {{column name}} to insert information from your spreadsheet into the template. This will enable you to personalize your message.
5
Click to send emails
After customizing your certificate, preview your design by clicking on 'Test Template'. If everything looks good, create and send all your certificates in seconds by clicking on 'Create Certificate'.