Google Apps Script Quick Start Beginner Guide
4.3 (8 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,879 students enrolled

Google Apps Script Quick Start Beginner Guide

Google Apps Script allows you to power up you G Suite with amazing functionality based on JavaScript
4.3 (8 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,879 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 14 articles
  • 3 downloadable resources
  • 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
  • Google Apps Script and how to apply it
  • Useful code to start writing and explore what can be done with Google Apps Script
  • Edit and create Google Scripts
  • GSuite of applications with Google Apps Script
Course content
Expand all 29 lectures 01:14:21
+ Introduction to writing Google Apps Script Code
28 lectures 01:13:09
Resource Guide
00:17
Source Code
00:02
Create Google Files
05:05
Source Code
00:06
Create Spreadsheet Add Content
02:25
Source Code
00:04
Send an Email Google Script.
04:37
Source Code
00:05
DocumentApp Class
06:38
Source Code
00:09
Update element text
03:36
Source Code
00:11
Get Update Spreadsheet
08:38
Source Code
00:08
Bound Script UI Alert
05:54
Source Code
00:16
Bound Script UI Prompt
04:05
Source Code
00:09
ActiveDocument Cursor
03:37
Source Code
00:04
ActiveSpreadsheet
07:06
Source Code
00:11
Copy Sheet Data to New Sheet.
04:27
Source Code
00:06
Requirements
  • JavaScript, HTML and CSS
  • Prior programming knowledge
  • Solid understanding of JavaScript
Description

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite.

DO NOT TAKE THIS COURSE IF YOU HAVE NO JAVASCRIPT EXPERIENCE  - JAVASCRIPT IS AN ABSOLUTE PREREQUISITE!!!

Explore how you can start using Google Apps Script to run code to make things happen within Google Suite of Apps.

BONUS - Downloadable PDF course Guide - with links and resources.

The course covers the following in regards to Apps Script and how to use it

  • Apply JavaScript methods within Apps Script like Date()

  • Create a document using script - add content to the document

  • Create a Spreadsheet using script

  • Get object info like ID and URL

  • Using session to get active user email address

  • Using Mail Service to send emails via script

  • DocumentApp and accessing updating existing docs by id

  • SpreadsheetApp and accessing data contained in existing sheets

  • Bound script in Docs and Sheets

  • How to add UI menu items

  • Running script funcitons from UI menu tab

  • Creating UI alerts

  • UI prompts to get user input and data

  • Active document get cursor location

  • Creating new sheet using script

  • Updating and copying sheet data selected by user

Source Code is included

Fast friendly support within the Q&A section - taught by an instructor with over 20 years of web development experiencing ready to help you learn.

What are you waiting for join now and start creating your own amazing projects with Google Apps Script.

Who this course is for:
  • Web developers
  • Application developers
  • Anyone who wants to learn more about Google Apps Script
  • Anyone who wants to automate Google Suite
  • JavaScript coders