Email Notifications for Google Forms
Getting Started The Google Forms Email Notification (Premium) sends you an email message with all the data entered by the user in the Google Form. You can choose to receive the data as rich HTML, plain text or as PDF attachments. The sheet also allows you to send a copy of the submitted form to the submitter for confirmation. The functionality is mostly written using Google Apps Script.
Step 1 - Create Response Sheet Open the spreadsheet link that you have received in the email and click the "Yes, make a copy" link to create a copy of the sheet in your Google Drive.
Digital Inspiration www.labnol.org
Page 1
Email Notifications for Google Forms
Step 2 - Create Google Form Inside the new sheet, click Tools -> Create a form to create a Google Form. If you want to use an existing form, skip to step #6.
Digital Inspiration www.labnol.org
Page 2
Email Notifications for Google Forms
Step 3 - Open Google Drive Go to drive.google.com and create a new Gogle Form. If you have created a form already, please skip to step #6.
Digital Inspiration www.labnol.org
Page 3
Email Notifications for Google Forms
Step 4 - Build the Form You can have any number of fields in your Google Form. Just remember to include a field called Email Address (you can give it any name) where the form submitter will enter his or her email address. Make it a required field. This is required if you wish to send a copy of the filled form to the form submitter.
Digital Inspiration www.labnol.org
Page 4
Email Notifications for Google Forms
Step 5 - Preview the Google Form Our Google Form is now ready. Click the "View Form" button in the Form editor to preview the form.
Digital Inspiration www.labnol.org
Page 5
Email Notifications for Google Forms
Step 6 - Change Form Destination Switch to the Google Form editor and choose Change Response Destination under Responses.
Digital Inspiration www.labnol.org
Page 6
Email Notifications for Google Forms
Step 7 - Use Existing Spreadsheet Select "New Sheet in an Existing Spreadsheet" as the Response Destination.
Digital Inspiration www.labnol.org
Page 7
Email Notifications for Google Forms
Step 8 - Pick the Response Sheet Select the sheet that you created in Step #2 as new response destination.
Digital Inspiration www.labnol.org
Page 8
Email Notifications for Google Forms
Step 9 - Authorize Open the Responses Google spreadsheet and choose Authorize under the Google Forms menu.
Digital Inspiration www.labnol.org
Page 9
Email Notifications for Google Forms
Step 9a - Authorize Click OK at the Authorization Required dialog.
Digital Inspiration www.labnol.org
Page 10
Email Notifications for Google Forms
Step 9b - Request for Permission Click Accept at the Permission dialog. You are running the form in your own Google Drive and the none of your data will be visible to anyone other than you.
Digital Inspiration www.labnol.org
Page 11
Email Notifications for Google Forms
Step 10 - Configure In the same Google Sheet, choose Step 2: Configure under the Google Forms menu.
Digital Inspiration www.labnol.org
Page 12
Email Notifications for Google Forms
Step 11 - Enter Data This is the important part. 1. If you wish to use the submitter's email address in the replyTo field, select the column name that contains that email address. 2. Select your email address that will appear in the "FROM" field of the email notifications. You can select any account that is linked to your Gmail account. 3. Enter your name that will appear in the FROM field of outgoing notifications. 4. Enter one or more email addresses where the notifications should go. Separate addresses with a comma. 5. What will be the subject of the email message. 6. Enter text that will appear in the message body in addition to the form values. 7. Select the email format - choose between HTML (recommended), Text or PDF. 8. Would you like to send a copy of the mail to the form submitter. Save the change. It might take upto 5 seconds for the changes to get saved.
Digital Inspiration www.labnol.org
Page 13
Email Notifications for Google Forms
Step 12 - Test the Form Now that are form is ready, it is time to test the changes. In the sheet, choose Form -> Go to Live Form.
Digital Inspiration www.labnol.org
Page 14
Email Notifications for Google Forms
Step 13 - Dummy Data Enter some dummy data in the form and hit Submit.
Digital Inspiration www.labnol.org
Page 15
Email Notifications for Google Forms
Step 14 - Email Notification Open your mailbox and you should see a notificaition with the form fields and values.
Support Twitter: @labnol Email: amit@labnol.org Blog: labnol.org
Digital Inspiration www.labnol.org
Page 16