Automated Quote/Invoice Using Google Apps Script & Google Forms

Introduction

• When someone fills out a Google Form selecting services they are interested in, a PDF is emailed.
• All of the information is logged
• The creation of the form uses the process outlined here: Creating A Google Form Using Google Apps Script
• A video demonstration of the tool can be found here: https://youtu.be/Zslma6MGE1w
• You can even fill out the current version I have just to see how it behaves for the end user

Key Points To Call Out

• By utilizing the form creation process above, this is a way to share a Google Sheets that is linked to a form.
• Google Apps Scripts does a fine job creating 1 PDF as users fill out the forms. However, if you needed to produce a high number of PDFs (ie 500), it is not possible with Google Apps Scripts due to rate limits and the fact that Google Apps Scripts can’t run for more than 6 minutes. The most PDFs I have been able to create has been about 60. I stress this PDF creation point because it is a point I am going to try and discuss with various tools such as Excel+VBA and python. Excel+VBA is my preferred method due to efficiency