A google apps script to send emails from a google sheet.

This script can be installed on any google form to setup automatic emails from that form.

• First you setup a google form.
• In this form you should collect email addresses somewhere. These can either be automatically collected from the logged in user, questions in the form, or both.
• You should also add a question that triggers when the form should be sent.
• Then whenever the trigger matches, the entire form will be sent to all the configured emails.

This script has a few configuration options which are set at the top. These correspond to values in your form that you use, and are described here in more detail.

The built in configuration (which can be seen below) is setup where the first two columns of the spreadsheet contain the email addresses. It is also setup with a question trigger assuming the form has a question called "Email manager?" which, when set to "yes" will send the email.

var EMAIL_CHECK_HEADING = 'Email manager?';
var EMAIL_CHECK_SEND = 'yes';
var EMAIL_CHECK_SENT = 'sent';
var EMAIL_COLUMNS = [1, 2];

To install this on your form, follow the following steps:

• Make a google form
• Configure the script variables as described above
• Load the responses spreadsheet
• Click "Tools" --> "Script Editor"
• Paste the contents of Code.gs into the text area.
• In the script editor menu chose the sendEmails function from the dropdown.
• Click the clock to open the triggers.
• Add a trigger to run the sendEmails function from the spreadsheet on form submit.
• Submitting a form should now send emails as configured (see above)