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.

https://nathrupjyoti.gumroad.com/l/nxiyu