Hey ProductHunt,
Really excited for this launch!
What is it ?
Script (Google Apps Script) to generate dynamic documents (& PDF) from data in Google Sheets & using Google Doc as a template
Why I developed this script ?
Most of you hire an Apps Script developer for the minor changes required to add a new merge/dynamic field to the template or change the entire template. All the solutions work only with the particular template & the particular sheet.
So, I created this script which requires Zero Apps Script Knowledge to either work with a whole new template or add/modify existing merge fields of the existing template.Why Universal Script ?
1. Works fine for any template
2. Works with any number of merge/dynamic fields
3. No code changes required at all
4. You can have multiple sheets in the same spreadsheet, no problem!
How is it different ?
1.Zero Apps Script knowledge required
2. Generate Multiple/Bulk Documents (& PDF)
3. No Code Changes Required
4. Working with new template & change/addition of merge fields is super easy. Only changes required in a sheet containing metadata like template id, destination folder id, merge fields & additional config.
5. Generating bulk documents & worried about 6 minutes time limit ? The script works just fine. It will continue to generate where it left off in the next execution.
6. Awesome logs to debug.
7. Lifetime Usage
8. You are getting the full code , so you can modify accordingly.
Use Cases
1. Generate Internship Certificates
2. Roll out Offer Letters
3. Generate Contracts
4. Workshop/Event Participation Certificates
5. Any dynamic documents that you generate using a single google doc template
I would be happy to get honest feedback. Don't hesitate to reach me out for any issue or queries.
If you have any questions, just ask !
Gmail To Slack