With Form Publisher, you can generate customized documents with predesigned templates by filling them out with data submitted to a Google form or with data available in a Google spreadsheet.
An example of mass generating documents from spreadsheet data is generating personalized invoices with existing data using a predesign Google Docs template.
Procedure
- Open the Form Publisher add-on.
The Form Publisher sidebar opens. - Click START.
- Select a sample Google Docs template.
Note: You can design your own template and add markers for every column header you want to display data for. - Click GENERATE FILES.
By default, for each row of data, Form Publisher generates a document (based on the selected template) and a PDF file. - Because Form Publisher does not automatically update the progress of the generated files in the add-on, keep clicking Refresh until it reports that all files are generated.
Form Publisher adds data for each generated document in the columns [Form Publisher] Generation Status, [Form Publisher] Generation Timestamp, [Form Publisher] Doc URL, [Form Publisher] PDF URL. - Click Open Google Drive folder after all documents have been generated.
Result
All PDF files and Google Docs documents are stored in a Form Publisher Output's Folder in your Google Drive.