Please ensure Javascript is enabled for purposes of website accessibility

About This Course

Who this course is for:

  • Web developers
  • App Developers
  • Anyone who wants to learn to automate workflow with Spreadsheets

What you’ll learn: 

  • How to connect spreadsheet to form data
  • Explore how Google Scripts works
  • Setup automation and triggers on Script function
  • Send emails using Google Apps Script


  • JavaScript experience
  • Computer access
  • A Google account

Google Apps Script is based on JavaScript and you can write code online in the online editor, the only requirement is a Google Account to get started. Please note this course covers how to use Google Apps Script to automate and increase productivity within GSuite – coding experience is required.

This is a coding course, JavaScript experience is a prerequisite to write Google Apps Script code. It covers the basics of setting up form submission, using spreadsheets to track data, and setting up triggers of scripts to automate content.

Coding includes the following :

  • Setting up form to submit data
  • Sending an email on form submission, setup of trigger to catch form submissions
  • Use of Spreadsheet to track data
  • Update and getting content from the Spreadsheet to use in Google Apps Script code
  • Update set and get of Sheet data
  • Sending of emails from sheet data – checking to see if user from sheet already has email sent
  • Adding UI for advanced menu option within spreadsheet

Source code is included so you can copy and paste the code to try for yourself, together with step-by-step learning from an instructor with over 20 years of experience, ready to help you learn. You have nothing to lose – join now and start learning to create your own version of this helpful application today!

Our Promise to You

By the end of this course, you will have learned to connect spreadsheets to form data using Google Apps Script.

30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.

Get started today and learn more about script function.

Course Curriculum

Section 1 - Introduction
Introduction Google Scripts – Getting Started With Apps Script 00:00:00
Google Forms Setup 00:00:00
Send Email Via Script 00:00:00
Setup Trigger For Automation Of Scripts On Event 00:00:00
Copy To Another Sheet 00:00:00
Copy Content On Submit 00:00:00
Sheet Data Sorter 00:00:00
Check Sheet Data For Value 00:00:00
Quick Fixes And Updates 00:00:00
Update Spreadsheet UI 00:00:00
Conclusion Spreadsheet Data 00:00:00
Automate Spreadsheet Data Using Google Script – Source Codes 00:00:00
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel