This is the code repository for An Apps Script Form Data Handler Exercise using Google Form and Spreadsheets [Video], published by Packt. It contains all the supporting project files necessary to work through the video course from start to finish.
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
- Create Google Script to power Google Apps
- Send email responses to form data submissions
- Track emails within Google Spreadsheets
To fully benefit from the coverage included in this course, you will need:
- A newbie who wants to create amazing things such as sending an email response and track Google Form data using Google Script. JavaScript developers who want to empower the Google suite of products. Web developers who want to incorporate Google Script functionality. App Script and Google Script developers.
This course has the following software requirements:
N/A