advertisement

Send Google Forms by Email - Premium

33 %
67 %
advertisement
Information about Send Google Forms by Email - Premium
How-to & DIY

Published on February 19, 2014

Author: labnol

Source: slideshare.net

Description

The Google Form by Email is a Google script that sends the form data in an email as soon as a user submits the form. The data can be sent as HTML, Text or as PDF attachments.

Available at http://labnol.org/?p=20884
advertisement

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

Add a comment

Related presentations

Belief comes through hearing. In order to have belief, we must listen, but we also...

Presentation held at the Etsy Team Captain Summit in Berlin, March 14-16, 2014

Download hack tool @ http://dragoncity.cooldownloadz.com

An how-to build an inexpensive Arduino Board for 5 USD.

step by step guide on how small businesses can start payroll software in -mid-year.

CLC Trendspotting - The Technologies of Makerspaces, presented by Edward Iglesias ...

Related pages

How to Get Google Forms Data in an Email Message

Get Google Forms Data in an Email ... though with Google Forms. Google Forms can send email notifications as ... available in the premium ...
Read more

Google Forms - create and analyze surveys, for free.

Analyze your results in Google Forms. Free from Google. Google ... you receive from Google Docs. ... collect email addresses ...
Read more

How to Send Confirmation Emails with Google Forms

Learn how to create an autoresponder for Google Forms and send automatic confirmation emails to the ... How to Send Confirmation Emails with Google Forms.
Read more

Export and email reports - Analytics Help

Export and email reports. Export a report. ... the email will be sent daily for a period of one month. ... Google Analytics training and support resources.
Read more

Google Docs - create and edit documents online, for free.

Free from Google. Google Editors ... Slides Forms; Help; Go to Google Docs ... You can unsubscribe at any time at the bottom of any email you receive from ...
Read more

Get your new email - Free email accounts | Register today ...

... Smart spam filters Unlimited email storage Email from any device and more ... Go Premium Now! ... facebook twitter google_plus. About mail ...
Read more

mail.com Premium Login - Free email accounts | Register ...

Log in to your premium email account at mail.com and experience unlimited access, ... facebook twitter google_plus. About mail.com; Terms & Conditions ...
Read more

Gmail, Docs, Calendar, & Cloud Storage - Google Apps for Work

Surveys and forms Slides. Beautiful presentations ... Want news and insights from Google Apps? Send me periodic emails with news, ...
Read more

Google Docs

Create and edit web-based documents, spreadsheets, and presentations. Store documents online and access them from any computer.
Read more