Formemailer Script for Google Forms

Created By: Kerri Lunn

Edited: 3/7/14

FormEmailer Script Instructions

This Formemailer script will automatically send an email to the person filling out your Google Form.  The basic steps to follow are listed below.  I have also included a great video I found on YouTube that walks you through the entire process as well.

Step 1: Create a form in google drive.  Be sure one of the data elements you are capturing is an email address 
of the person filling out the form.

Step 2: Create the response spreadsheet

Step 3: Go to the “Response” spreadsheet

Step 4: Click Insert / Script

Type formemailer in the search box and then click Install

l

 

Click “Continue” on the Authorization required popup box

Click “Accept” on the Request Permissions

Click Close

Step 5: Go back to the Responses spreadsheet for your form.  

Click on the Formemailer option and click Install

Once installed, it will bring you back to the Formemailer tab of the responses spreadsheet.  

This is an informational tab only.  

Step 6:  Go back to the responses tab of the spreadsheet

Step 7:  *  Ciick on FormEmailer and select Settings. The screen below will appear.

            *  Click on the Email tab, In the Answers placeholders select the Email address

*  Click in the To: box  then click the “insert placeholder” and it will insert the email field you are

               collecting from the google form.

*  In the Subject and Body areas, you can change the information to format it the way you wish

   pulling the data you are collecting from your form.  

* Then click Save and Close
                

Step 8:  The final step is to Add a Trigger so when the form is filled out it will automatically email them the

              information from the form (i.e. agenda, etc)

* Again, you are in the Responses spreadsheet of your form

* Click Tools / Script Editor

* Click Resources / Current Project Triggers

* Click Add New Trigger and select timedriven, from spreadsheet and the on form submit and click

Save as indicated in the screenshot below. 

* Once the trigger is created you can close the formemailer editor tab.

NOTE:  Here is a step-by-step video of this entire process as well that is perfect: 

Adding Script to Google Form to Email Responses