O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

An Apps Script Form Data Handler Exercise using Google Form and Spreadsheets

Video Description

Use Google Apps Script to add advanced functions to Form submissions, send emails automatically to users, and more.

About This Video

  • Accelerate your web pages with Google Sheet, Docs, and Slide

In Detail

Google Script is the best way to automate your Google suite, and best of all, it’s FREE and EASY to use. All you need is a Google account to get started. The IDE and everything you need is on the cloud.

Automate, add functionality, use spreadsheet data, create documents, interact with users through emails, generate reports, use data the list of all the amazing things you can do with Google Apps Script is endless.

You’ll learn the following lessons:

  • Set up a Google Form
  • Connect the form to put information into a spreadsheet
  • Add a trigger to do something when the form is submitted
  • Create a function to send an email
  • Create an email template that uses HTML and CSS
  • Replace template data with data from your spreadsheet
  • Automate the whole process with triggers
  • Send regular emails to subscribers
  • Get and use data from the form submission to do stuff
  • Source code included
  • Taught by an instructor with 18 years of experience
  • Step-by-step training lessons

This course covers everything you need to learn how to set up your own version of this application and get started using Google Script.