Google Apps Script Complete Course Beginner to Advanced

Google Apps Script Complete Course Beginner to Advanced, available at $119.99, has an average rating of 4.55, with 338 lectures, based on 3543 reviews, and has 23225 subscribers.

You will learn about Create custom functions within G Suite Apps Docs Sheets Slides Gmail Drive and more Create Google Script to power Google Apps Use Google Script to to add functionality automation and more to Google Docs Sheets plus This course is ideal for individuals who are Anyone who wants to create amazing things using Google Scripts or JavaScript developers who want to empower Google suite of products or Web developers who want to incorporate Google Script functionality or Application developers who want to access the power of Google G Suite or App Script Google Script developers It is particularly useful for Anyone who wants to create amazing things using Google Scripts or JavaScript developers who want to empower Google suite of products or Web developers who want to incorporate Google Script functionality or Application developers who want to access the power of Google G Suite or App Script Google Script developers.

Enroll now: Google Apps Script Complete Course Beginner to Advanced

Summary

Title: Google Apps Script Complete Course Beginner to Advanced

Price: $119.99

Average Rating: 4.55

Number of Lectures: 338

Number of Published Lectures: 338

Number of Curriculum Items: 338

Number of Published Curriculum Objects: 338

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Create custom functions within G Suite Apps Docs Sheets Slides Gmail Drive and more

Create Google Script to power Google Apps

Use Google Script to to add functionality automation and more to Google Docs Sheets plus

Who Should Attend

Anyone who wants to create amazing things using Google Scripts

JavaScript developers who want to empower Google suite of products

Web developers who want to incorporate Google Script functionality

Application developers who want to access the power of Google G Suite

App Script Google Script developers

Target Audiences

Anyone who wants to create amazing things using Google Scripts

JavaScript developers who want to empower Google suite of products

Web developers who want to incorporate Google Script functionality

Application developers who want to access the power of Google G Suite

App Script Google Script developers

Google Apps Script is a coding language in the cloud that is based on JavaScript – allowing you to connect the Google Workspace Services to do amazing advanced functionality within your Google Workspace.

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. Apps Script lets you do more with Google. All on a JavaScript platform in the cloud.G Suite Services.

Course content covers every step to get started with Google Scripts including an overview of the editor and what it does and how to use it.  Followed by more detailed syntax and code examples of applying Google Script in real world projects.  Perfect for students of all levels, with a step by step approach for anyone who has not used Google Script Before.

Apps Script allow you to power up your favorite Google apps and do more with them, way more.

Automate, add functionality, use spreadsheet data, create documents, interact with emails, generate reports, use data the list is endless on all the amazing things you can do with Google Apps Script.

Warning once you start using Google Apps Script you may want to use it for everything!!!

Just like JavaScript apps script is easy to write, uses the same structure as JavaScript and core fundamental functionality.   If you know JavaScript you can get started with apps script in minutes.  Functions, variables, loops, and more the same syntax as JavaScript.   With the added power of Google Classes you can connect data from your Google Apps and build on it.  Its the easy way to power up your applications.

Course will cover 

Standalone script

IDE editor

Quick demo to setup and get started with.

Document – DocumentApp

Get document

Document body

Get elements within body

Create docs on the fly

Document UI for alerts and responses.  Interact with users.

Selection of data and construction of content

Styling your doc content

Spreadsheet – SpreadsheetApp

How to Get spreadsheet data

Create spreadsheets and update, create and use the data

Get ranges – select sheets and get content

Get Sheet data and iterate through it to output it

Write to spreadsheet using script

Spreadsheet UI for added interactions with users

Update sheet with new data

Sidebar menu update sheet show sheet data and more

Google Sites – Standalone scripts

Sites class and how to use them

Sites dashboard navigation and use

Design sites interface with options to create pages and more

Add scripts to sites to create data driven and interactive pages

Output and setup sites content quickly and easily

Google Drive – DriveApp Class

Get drive data and use it

Setup files create new files

Move files from one folder to another

Get folder contents and list it

Create files copy files and update files

Search drive files and folders

Get permissions and set permissions

List files from folders in Google Sheet show permissions update permissions

Calendar Calendar – CalendarApp Class

Create events

Get event details

Update color style

Output events to Google Sheet

Using Calendar events checking availability and more

Gmail – GmailApp Class

Send message

Get inbox contents from folder

Create labels and move files

Get counts of emails and content

Mark Emails as read 

Track emails and use the content 

Search emails

Star Messages

Step by step training lessons

This course covers everything you need to learn about Google Apps Script, including practice exercises, loads of examples, source code and step by step training.  Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.  

Taught by a knowledge instructor with many years of web development experience, ready to help you learn.

Join now and create your own Google Scripts Apps see what is possible.

Course Curriculum

Chapter 1: Introduction to using Google Script

Lecture 1: Introduction to Google Script

Lecture 2: New IDE editor added for Google Apps Script

Lecture 3: Quick Start to Google Apps Script

Lecture 4: Apps Script Power Example

Lecture 5: Source Code

Lecture 6: IDE Integrated Development Environment

Lecture 7: First Script using online IDE and Google Script

Lecture 8: Google Script Classes

Lecture 9: Apps Script Resources

Lecture 10: JavaScript Introduction

Lecture 11: Source Code

Chapter 2: Google DocumentApp

Lecture 1: Explore Document – Class DocumentApp

Lecture 2: DocumentApp Class overview

Lecture 3: Get Document Contents

Lecture 4: Document Body Contents

Lecture 5: Source Code 7 Class DocumentApp

Lecture 6: Document Body Updates

Lecture 7: Document Body Children

Lecture 8: Source Code 10

Lecture 9: Document Classes and Methods

Lecture 10: Source Code 11

Lecture 11: Simple Copy Doc Script

Lecture 12: Source Code 12

Lecture 13: DocumentApp Bound Script

Lecture 14: Base Values within Script

Lecture 15: HTML in Google Documents

Lecture 16: Bound Content Interaction

Lecture 17: Ranged elements in Document

Lecture 18: Translate Selected Content

Lecture 19: Source Code 18

Lecture 20: Search Content Replace With

Lecture 21: Find Content Update Attributes

Lecture 22: Content Selection Exercise

Lecture 23: Source Code 21

Lecture 24: DocumentApp Exercise

Lecture 25: Source Code 22

Lecture 26: DocumentApp Create Content

Lecture 27: insert Image DocumentApp

Lecture 28: DocumentApp Template Exercise

Lecture 29: Source Code 25

Chapter 3: Google Spreadsheet app

Lecture 1: StandAlone SpreadSheetApp

Lecture 2: Google SpreadSheetApp Methods CheatSheet

Lecture 3: Creating Content and Styling.

Lecture 4: Updated Lessons Set Values and Get Values

Lecture 5: Source Code for Updates

Lecture 6: Spreadsheet data to Doc Table

Lecture 7: Spreadsheet data dynamic

Lecture 8: SpreadSheet Tracker Exercise

Lecture 9: SpreadSheet Sheet Class

Lecture 10: From one sheet to another

Lecture 11: Source Code 33

Lecture 12: Bound Spreadsheet App

Lecture 13: Google Sheets Functions

Lecture 14: Source Code

Lecture 15: UI menu options Spreadsheet

Lecture 16: Spreadsheet UI Sidebar Modal

Lecture 17: Get Selected Content

Lecture 18: Exercise Cell Selection Add to Sheet

Lecture 19: Range to Another Sheet CopyTo

Lecture 20: Selecting Cell Values Loops

Lecture 21: Source Code

Lecture 22: Sidebar content HTML

Lecture 23: Script More UI options

Lecture 24: HTML to backend GS code.

Lecture 25: Google Sheet content to Client Side

Lecture 26: Source Code

Lecture 27: Triggers OnEdit OnChange

Lecture 28: Source

Lecture 29: Exercise Google SpreadsheetApp.

Lecture 30: Exercise Generate Random Content

Lecture 31: Adding new Column

Lecture 32: Add Formulas Set Colors

Lecture 33: HTML modal to Spreadsheet

Lecture 34: Sheet Data to HTML file

Lecture 35: Source Code

Lecture 36: Get Sheet Data

Lecture 37: Run Script Client Side

Lecture 38: Response with Google Sheet Data

Lecture 39: Source Code HTML index file

Lecture 40: Source Code GS

Chapter 4: Google Script Sites

Lecture 1: Introduction to Google Sites

Lecture 2: New Google Sites

Lecture 3: Publish Web App Google Script

Lecture 4: Google Site Scripting

Lecture 5: Source Code

Lecture 6: Google Script Web App html page

Chapter 5: Google Drive – DriveApp Class

Lecture 1: Google DriveApp Class

Lecture 2: Select Folder By ID

Lecture 3: Create Folder DriveApp

Lecture 4: DriveApp create File

Lecture 5: SpreadSheet with DriveApp Data

Lecture 6: Source Code

Lecture 7: Create Doc and Move it

Lecture 8: Source Code

Lecture 9: DriveApp Search

Instructors

Laurence Svekis
Instructor, GDE, Application Developer

Rating Distribution

1 stars: 33 votes

2 stars: 66 votes

3 stars: 314 votes

4 stars: 1176 votes

5 stars: 1954 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!