Generate and Email Personalized Work From Home Agreement Document to Employees – Part 1

In this tutorial, I will explain how you can generate a personalized document where we get the values from a Google Sheets file using zenphi.

For this scenario, we will dynamically generate a personalized Work From Home Agreement document based on a Google Docs template document. We will then store the generated file on Google Drive, and export it to a PDF document. 

We maintain and read list of employees from a Google Sheets spreadsheet.

This tutorial demonstrates how to:

• Read values from Google Sheets
• Generate a dynamic Google Docs document from a template document
• Export a Google Docs document to PDF 

in the next part, we will show you how to do Mail Merge using this information, and email the generated document to each employee.