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.