Universal DocsFromSheet
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 ?
- Works fine for any template
- Works with any number of merge/dynamic fields
- No code changes required at all
- You can have multiple sheets in the same spreadsheet, no problem!
Why you should get this script ?
- Zero Apps Script knowledge required
- Generate Multiple/Bulk Documents (& PDF)
- No Code Changes Required
- 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.
- 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.
- Awesome logs to debug.
- Lifetime Usage
- You are getting the full code , so you can modify accordingly.
Product Demo
If you are still not sure about what the product is or the script does, feel free to watch the demo video in YouTube: https://youtu.be/tULgrVMdXsw
What's included in the purchase/kit ?
- Getting Started Video: Step by step video on creating your own template & using the script to generate documents.
- Source Code: The actual Apps Script code.
- Documentation: PDF file containing all the details about the script, usage and additional information.
- _MERGE SHEET: This sheet is for reference (I also use in the Getting Started Video) & reuse to put the metadata like template id, folder id, the merge fields & other config.
- Sample Sheets & Templates: The sheets that I use in the demo & getting started video, so you can play around or follow along.
- Demo Video: The same YouTube video added for reference.
Refund Policy
Because I provide the full source code, I can't provide you a refund. The script is well tested & works fine. In case of an issue, just get back to me.
Contact
If you have any issue or queries, contact me at rupjyoti.docsfromsheets@gmail.com .
In case you purchase the script & don't receive an email from Gumroad, please contact me in the above email. I will resend the receipts and if required, I will manually send the assets.
Terms Of Use
You are not allowed to share the script with others, except if used within a single organization.
You are not allowed to sell/resell the script.
If you are a freelancer & write code for your clients, you can learn & use it. However, you cannot share it in public or provide all the assets directly to anyone.
Gumroad's Terms Of Use is also applicable: https://gumroad.com/terms
Gumroad's Privacy Policy: https://gumroad.com/privacy
My other script
Google Form Submissions Beautified: Script (Google Apps Script) to beautify Google Form submissions by merging submission data with a Spreadsheet template to create sheet & PDF.
Automatically send the beautified submission form/sheet PDF to yourself & the submitter on every form submission.
You'll get Getting Started Video, Full Apps Script Code, Documentation, required MERGE sheet & few sample sheets & templates to play around.