4.52 out of 5
4.52
1632 reviews on Udemy

Google Apps Script Complete Course – Beginner to Advanced

Learn to power up your Google Suite of products using Apps Script to connect - automate - add advanced functionality
Instructor:
Laurence Svekis
10,043 students enrolled
English [Auto]
Create Google Script to power Google Apps
Use Google Script to to add functionality automation and more to Google Docs Sheets plus

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.

 

Introduction to using Google Script

1
Introduction to Google Script
2
Quick Start to Google Apps Script
3
Apps Script Power Example
4
Source Code
5
IDE Integrated Development Environment
6
First Script using online IDE and Google Script
7
Google Script Classes
8
Apps Script Resources
9
JavaScript Introduction
10
Source Code

Google DocumentApp

1
Explore Document - Class DocumentApp
2
DocumentApp Class overview
3
Get Document Contents
4
Document Body Contents
5
Source Code 7 Class DocumentApp
6
Document Body Updates
7
Document Body Children
8
Source Code 10
9
Document Classes and Methods
10
Source Code 11
11
Simple Copy Doc Script
12
Source Code 12
13
DocumentApp Bound Script
14
Base Values within Script
15
HTML in Google Documents
16
Bound Content Interaction
17
Ranged elements in Document
18
Translate Selected Content
19
Source Code 18
20
Search Content Replace With
21
Find Content Update Attributes
22
Content Selection Exercise
23
Source Code 21
24
DocumentApp Exercise
25
Source Code 22
26
DocumentApp Create Content
27
insert Image DocumentApp
28
DocumentApp Template Exercise
29
Source Code 25

Google Spreadsheet app

1
StandAlone SpreadSheetApp
2
Google SpreadSheetApp Methods CheatSheet
3
Creating Content and Styling.
4
Updated Lessons Set Values and Get Values
5
Source Code for Updates
6
Spreadsheet data to Doc Table
7
Spreadsheet data dynamic
8
SpreadSheet Tracker Exercise
9
SpreadSheet Sheet Class
10
From one sheet to another
11
Source Code 33
12
Bound Spreadsheet App
13
Google Sheets Functions
14
Source Code
15
UI menu options Spreadsheet
16
Spreadsheet UI Sidebar Modal
17
Get Selected Content
18
Exercise Cell Selection Add to Sheet
19
Range to Another Sheet CopyTo
20
Selecting Cell Values Loops
21
Source Code
22
Sidebar content HTML
23
Script More UI options
24
HTML to backend GS code.
25
Google Sheet content to Client Side
26
Source Code
27
Triggers OnEdit OnChange
28
Source
29
Exercise Google SpreadsheetApp.
30
Exercise Generate Random Content
31
Adding new Column
32
Add Formulas Set Colors
33
HTML modal to Spreadsheet
34
Sheet Data to HTML file
35
Source Code
36
Get Sheet Data
37
Run Script Client Side
38
Response with Google Sheet Data
39
Source Code HTML index file
40
Source Code GS

Google Script Sites

1
Introduction to Google Sites
2
New Google Sites
3
Publish Web App Google Script
4
Google Site Scripting
5
Source Code
6
Google Script Web App html page

Google Drive - DriveApp Class

1
Google DriveApp Class
2
Select Folder By ID
3
Create Folder DriveApp
4
DriveApp create File
5
SpreadSheet with DriveApp Data
6
Source Code
7
Create Doc and Move it
8
Source Code
9
DriveApp Search
10
DriveApp Search Files
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.5
4.5 out of 5
1632 Ratings

Detailed Rating

Stars 5
854
Stars 4
564
Stars 3
172
Stars 2
31
Stars 1
10
494a3195e3482a807fe0b571b9968ab8
30-Day Money-Back Guarantee

Includes

21 hours on-demand video
101 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion
Hey Wait!

Get our latest Podcast episodes, Tutorials and discount coupons.