Google Script Form Submission Response and Spreadsheet Data
4.2 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,831 students enrolled

Google Script Form Submission Response and Spreadsheet Data

Explore how you can submit data to Google Spreadsheet update the data and send emails on form submission.
4.2 (4 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,831 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto-generated]
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 9 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Requirements
  • JavaScript Experience
  • Computer access
  • Google Account
Description

Please note this course covers how to use Google Apps Script to automate and increase productivity within gSuite - Coding is required

Google Apps Script is based off JavaScript and you can write code online in the online editor, only requirement is a Google Account to get started.

This is a coding course! - JavaScript experience is a prerequisite to write Google Apps Script code.

Course covers the basics of setting up form submission.

Using Spreadsheets to track data

Setting up triggers of scripts to automate content

Coding includes below :

  • 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.

Step by step learning

Fast friendly support is always available within the Q&A section

Experienced 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!!!


Who this course is for:
  • Web developers
  • Application Developers
  • Anyone who wants to learn to automate workflow with Spreadsheets
Course content
Expand 20 lectures 01:02:00
+ Introduction to creating amazing things with Google Apps Script
20 lectures 01:02:00
Source Code
00:02
Setup Trigger. For automation of scripts on event
07:05
Source Code Google Apps Script
00:05
Copy to another Sheet.
08:55
Source Code Google Apps Script
00:08
Copy content on Submit
04:33
Source Code Google Apps Script
00:09
Sheet data sorter.
04:38
Source Code Google Apps Script
00:05
Check Sheet Data for Value
07:17
Source Code Google Apps Script
00:08
Quick Fixes and Updates
02:13
Source Code Google Apps Script
00:11
Update Spreadsheet UI.
03:58
Source Code Google Apps Script
00:14
Conclusion Spreadsheet Data
03:59
Source Code Google Apps Script
00:45