You have just conducted a training for hundreds of attendees and you want to email every attendee with a certificate of participation. This would normally be a very tedious task as standard mail-merge functionality does not allow you to create a customized attachment.
The solution I found is by using a number of Google products and an interesting add-on in the Google store called ‘Document Studio’.
This video goes through the step-by-step process:
- Capturing attendee data using Google Form
- Creating certificate using Google Slides
- Uploading Google Forms into Google Sheets
- Using Document Studio to link everything together
- Finally, use GMAIL to mail out customized certificates.
I hope you find this resource useful.