Automatically generate PDFs from spreadsheet data by using a Google Doc as a template with merge fields
This automation will auto-fill a Google Doc template with data from a Google Sheet, then automatically turn it into a PDF.
Triggered when a new row is added to the bottom of a spreadsheet
Create a PDF by merging spreadsheet data into a Google Doc and saved to Google Drive
CREATEPDF(<Google drive credential>,<path to template>,<file name>,<output cell>)