Header image

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

July 24, 20201 CommentHR Use Cases , Legal Use Cases , zenphi Use Cases

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.


Comment (1)

Generate and Email Personalized Work From Home Agreement Document to Employees – Part 2 – zenphi
July 27, 2020

[…] the Part 1 of this series we showed you how you can dynamically generate documents based on a Google Docs […]


Leave A Comment

Your email is safe with us.