Embedded Files
autoCrat: Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data.
Automates the creation and sharing of personalized (e.g. merged) Google Docs or PDF email attachments from columns of data in a Google Sheet.
Optionally merge documents when forms are submitted!
It's simple!
Create your merge template as a Google Doc or Spreadsheet using any formatting you like, and set placeholder tags using a simple convention. (Example: Dear <<First Name>>, ...)
Match the fields from your Sheet to the tags in your doc.
Choose from among the various merge settings (PDF or shared Google Doc) and build a customized email message to recipients using placeholder variables from your sheet.
Preview your merge from the first data row before running on all records.
Other Tips
Other Tips
- You can choose to send your certificate (merge template) as a PDF or a Google Doc.
- Use the responses sheet to create your merge.
- You need to gather names and email addresses in your form.
- Fill out the form yourself so you know the merge works.
Report abuse