Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
9. Mash Up > Directing Email Using Google Forms
Directing Email Using Google Forms
Google Forms are a very convenient way to quickly get information into a spreadsheet. Add some Google Script and you can turbo charge that form to send email notifications, generate other data in the spreadsheet, and all those things you might want to do when getting data from a form.
In this section you will learn the basics of getting form information into a Google Script and sending an email depending on a selection from a drop down list in the Google form.
Highlights:
-
Google Forms
-
EmailApp
-
Event Triggers
Open up a Google spreadsheet and start creating a form. The example we will use is for routing inquiries to the right department: Sales or Service. Figure 9-1 shows the form editor and the drop down box selection.
