In the Part 1 of this series we showed you how you can dynamically generate documents based on a Google Docs template using the data read from a Google Sheets spreadsheet.
In this part, we show you how you can perform a Mail Merge using zenphi.
We will generate a customized email for each employee from an email template. For this scenario we have designed our email template in Google Docs.
We will then attach the Work From Home Policy document, which we generated for the employee, to the email and send it to the employee.
In this tutorial we demonstrate how to:
- Generate a dynamic email content from the Google Sheet data (mail merge)
- Send email using zenphi
- Share a dynamically generated file in Google Drive with one or more people