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.
Hey Product Hunt Community,
I am excited for the launch!
What is it ?
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.
I hate to view default form submission in form & sheet!
Why use this script ?
1. Convert to offline submitted form to maintain office records.
2. Send a copy to the submitter to get signed or other legal reasons.
3. View submissions better & clear , similar to an offline version of the form
4. Convert offline forms into Google forms & back again to submitted form. You just need to crate the template.
Practical Use Cases
Tenant Form : Generate offline copy & get signed. Keep a legal record.
Paying Guest Application
Membership Forms
Convert any offline form to Google Form & back to offline!
This script works for any template & form!
Works fine for any template
Works with any number of fields in the form
No code changes required
Why you should get this script ?
Zero Apps Script knowledge required
Generate Multiple/Bulk Sheet (& 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.
Awesome logs to debug.
Lifetime Usage
You are getting the full code , so you can modify accordingly.
What's included in the kit ?
1. Getting Started Video + PDF guide
2. Source Code: The actual Apps Script code.
3. Documentation: PDF file containing all the details about the script, usage and additional information.
4. Sample Sheets & Templates: The sheets that I use in the demo & getting started video, so you can play around or follow along.
5. Video showing how to create trigger to generate & email form response PDF automatically on every form submission.
Gmail To Slack