Automated PDF Contract Generation and Distribution

This n8n workflow automates the process of creating personalized business documents in PDF format, such as contracts or job proposals, starting from data stored in a Google Sheets spreadsheet. The workflow begins with a manual trigger, allowing users to initiate the process on demand. It then iterates over each row of the Google Sheet, retrieving employee data and using a pre-designed PDF template from CraftMyPDF to generate individualized documents. Once the PDFs are generated, the workflow uploads each document to Google Drive for easy access and archive management. Additionally, it sends personalized emails to each employee, attaching their respective PDF contracts or proposals. Finally, it updates the Google Sheet to mark each row as completed. This comprehensive automation streamlines bulk document creation, distribution, and record-keeping, making it ideal for HR, legal, or administrative workflows dealing with large volumes of personalized documents.