Automate emails with Google Forms and Google Apps Script

This Google Apps Script tutorial video will teach you how to automate emails using onForm Submit with a Google Sheets workbook and a Google Form.

The begins with a short demo, which will show you what the end product will look like. We'll begin by setting up our files in the Google Apps Script environment. The getSheetById() will be created — you can learn more about that in the video linked below — followed by the composition of our main function.

After accessing the data from our workbook, we will connect the code file to the html file and then write some html. We'll conclude by setting our onForm Submit trigger followed by a concluding demo.

Sorry about the funny error at the end — after I finished recording I realized I entered my email "@google.com" instead of "@gmail.com", haha.

In case you missed my first video on email, you can watch it here:    • Automate emails with Google Sheets  

or, you can learn more about the getSheetById function:    • Automate data collection in Google Sh...