Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
Programming Languages
Google Apps Script
Google Apps Script Complete Course Beginner to Advanced

Google Apps Script Complete Course Beginner to Advanced

Loại khoá học: Programming Languages

Learn to power up your Google Suite of products using Apps Script to connect - automate - add advanced functionality

image
50.000 VND
2.499.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

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.


Bạn sẽ học được gì

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

Yêu cầu

  • JavaScript and basic HTML and CSS knowledge
  • Internet Access
  • Google Account
  • Basic Web development understanding
  • JavaScript knowledge is REQUIRED

Nội dung khoá học

19 sections

Introduction to using Google Script

11 lectures
Introduction to Google Script
06:23
New IDE editor added for Google Apps Script
00:20
Quick Start to Google Apps Script
04:14
Apps Script Power Example
07:00
Source Code
00:07
IDE Integrated Development Environment
10:44
First Script using online IDE and Google Script
08:43
Google Script Classes
13:09
Apps Script Resources
00:11
JavaScript Introduction
12:59
Source Code
00:09

Google DocumentApp

29 lectures
Explore Document - Class DocumentApp
05:18
DocumentApp Class overview
00:19
Get Document Contents
04:39
Document Body Contents
03:51
Source Code 7 Class DocumentApp
00:13
Document Body Updates
06:54
Document Body Children
05:37
Source Code 10
00:33
Document Classes and Methods
08:07
Source Code 11
00:41
Simple Copy Doc Script
12:47
Source Code 12
00:09
DocumentApp Bound Script
06:38
Base Values within Script
08:17
HTML in Google Documents
06:12
Bound Content Interaction
07:21
Ranged elements in Document
06:02
Translate Selected Content
03:25
Source Code 18
00:47
Search Content Replace With
08:14
Find Content Update Attributes
08:47
Content Selection Exercise
14:45
Source Code 21
00:35
DocumentApp Exercise
15:12
Source Code 22
00:47
DocumentApp Create Content
17:02
insert Image DocumentApp
05:32
DocumentApp Template Exercise
04:13
Source Code 25
01:19

Google Spreadsheet app

40 lectures
StandAlone SpreadSheetApp
03:04
Google SpreadSheetApp Methods CheatSheet
00:57
Creating Content and Styling.
07:16
Updated Lessons Set Values and Get Values
04:27
Source Code for Updates
00:18
Spreadsheet data to Doc Table
07:19
Spreadsheet data dynamic
04:10
SpreadSheet Tracker Exercise
07:07
SpreadSheet Sheet Class
06:09
From one sheet to another
10:47
Source Code 33
00:49
Bound Spreadsheet App
03:18
Google Sheets Functions
05:10
Source Code
00:03
UI menu options Spreadsheet
03:42
Spreadsheet UI Sidebar Modal
05:44
Get Selected Content
07:31
Exercise Cell Selection Add to Sheet
08:26
Range to Another Sheet CopyTo
04:55
Selecting Cell Values Loops
13:30
Source Code
00:38
Sidebar content HTML
07:57
Script More UI options
04:18
HTML to backend GS code.
07:52
Google Sheet content to Client Side
08:39
Source Code
00:30
Triggers OnEdit OnChange
03:20
Source
00:36
Exercise Google SpreadsheetApp.
05:29
Exercise Generate Random Content
10:09
Adding new Column
06:36
Add Formulas Set Colors
07:04
HTML modal to Spreadsheet
03:46
Sheet Data to HTML file
07:51
Source Code
00:28
Get Sheet Data
07:18
Run Script Client Side
07:01
Response with Google Sheet Data
09:52
Source Code HTML index file
00:25
Source Code GS
00:38

Google Script Sites

6 lectures
Introduction to Google Sites
08:41
New Google Sites
07:41
Publish Web App Google Script
08:12
Google Site Scripting
05:45
Source Code
00:08
Google Script Web App html page
04:39

Google Drive - DriveApp Class

17 lectures
Google DriveApp Class
03:49
Select Folder By ID
02:57
Create Folder DriveApp
07:13
DriveApp create File
04:20
SpreadSheet with DriveApp Data
09:53
Source Code
00:20
Create Doc and Move it
07:21
Source Code
00:06
DriveApp Search
09:38
DriveApp Search Files
02:44
Source Code
00:24
DriveApp searchFolders Params
01:11
Add editors and Delete
12:52
Source Code
01:08
Redirect on search string
10:03
Exercise WebApp Redirector
07:10
Source Code
00:21

Google GmailApp

9 lectures
Introduction to Class GmailApp
02:35
Make Draft GmailApp
04:46
View your Draft Email
05:11
Use HTML Template email
05:58
Send out a bunch of Emails
11:10
Source Code
00:31
Chat Threads GmailApp
03:34
Get Gmail Messages
12:26
Source Code
00:42

Calendar App Class

20 lectures
Calendar App Service
03:44
Add Location Info Calendar App
04:46
Calendar Event with options
05:33
Full Day events Calendar App
05:43
Calendar App Event Series
07:04
Calendar App Date Time
03:23
Easy way to enter Events
03:19
More Calendars
04:03
Calendar Settings
04:42
Get All Calendars
05:25
Calendars By Name
05:49
Source Code
01:22
Calendar Events
02:52
Calendar Events Explored
05:05
Calendar Events into spreadsheet
07:59
Google Calendar Events Invites No
07:43
Source Code
01:49
Send Weekly Calendar Events
18:52
Source Code
00:20
Review Google Script
03:03

Exercise Google Script Image Uploader Project

13 lectures
Apps Script Image Uploader project intro
02:03
New Updates 2020
00:48
HTML Content Service
07:16
HTML Content Template File
03:50
HTML Content from File
08:47
Create the HTML form
04:44
Send Data to Google Script Backend
07:37
Send Image to Google Script
06:23
Image upload Tweaks
02:36
Spreadsheet App tracking uploads
04:34
Send Email notification
02:55
Final Application Image Uploader
05:50
Project Source Code
01:27

Form auto Email responder

13 lectures
Setup Google Form
06:36
Spreadsheet Bound Script
03:44
Google Script Setup Project triggers
05:02
Setup Email to Send
04:14
MailApp Send Email
04:15
Email HTML template
05:58
HTML Service replace content
03:31
Source Code
00:19
HTML to PDF and Attach it
05:16
Send automatic emails
05:26
iterate Sheet Data Send Emails
06:46
Review and update code for project
05:57
Project Source Code
00:21

Using Google Script for website form submission and handling

24 lectures
Contact Form Setup
05:12
Source code
00:18
Create Spreadsheet and setup
08:35
Sending an Email with Apps Script.
05:33
Google Script send email
00:03
Spreadsheet App add content
07:11
Test Sheet Google Script
00:06
Create Web App
05:41
Google Script Trigger Examples
00:04
Get Data Parameters
03:33
JavaScript Fetch
06:09
Outdate HTML in Submit
02:05
Source Code
00:31
Google Script Application
07:24
Source Code Google Script Post
00:16
Send email on submit
03:08
Random ID function and Date Add
03:24
Google Script doPost doGet Source Code
00:48
Email template
06:26
Source Code Google Script
00:48
Create Web App
05:29
Source Code
00:49
App Wrap Up and Review
02:48
Final Project Source Code
01:01

Calendar App and Calendar entry search Google Apps Script - CalendarApp Project

32 lectures
Calendar App Project Introduction
03:35
CalendarApp Setup
05:51
Source Code
00:04
Add SideBar Dialog
03:00
Source Code
00:05
HTML service Method
09:10
Source Code
00:11
CalendarApp Methods
03:02
Source Code
00:07
New Event Form HTML.
08:43
New Event .html file source code
00:35
JavaScript Form Submit Data
05:16
Google Script Run
03:20
HTML file source code
00:34
Create Calendar Event from Form
05:51
Source Code GS
00:14
Spreadsheet Tweaks
02:15
Source Code
00:13
Create Event Checker
04:33
Source Code event checker HTML
00:31
Client Side to Server Side
03:19
Source Code Codegs
00:18
SheetMaker Spreadsheet
05:11
Source Code Code GS
00:24
Get Event Data for Sheet
07:37
Source Code
00:32
Search Title Update
03:34
Source Code
00:37
WebApp Option to add
04:24
Source Code
00:40
Google App Code Review
12:54
Project Files and Source Code
00:40

PDF upload Project Spreadsheet App review

25 lectures
PDF Uploader Project Section
03:03
Updated Upload PDF for Blob
00:52
Google Apps Script Recent Changes - Please note more to come.
00:24
Section Resource Guide
00:03
Spreadsheet App
11:59
Source Code
00:04
Update Spreadsheet content
04:52
Get Content from Spreadsheet
07:52
Source Code
00:04
Add Content to Spreadsheet
07:23
Source Code
00:08
Spreadsheet content
04:57
Source Code
00:07
Create Web App.
06:00
Source Code
00:02
Templated HTML webApp
07:33
Index page source
00:09
Sheet Values on Client Side
08:29
Source Code
00:05
Upload PDF to Drive
08:37
Upload PDF to Drive 2
09:56
Upload PDF to Drive 3
07:30
Project Source Code
00:18
Upload html source code
00:10
Project Review Conclusion
10:33

Google DriveApp MailApp SpreadsheetApp Drive File Manager

29 lectures
Drive Files and Folder Manager Introduction
03:48
Project Setup add UI.
07:40
Source Code
00:03
Use index file for Modal Dialog
04:18
Source Code
00:08
Client Side HTML Page
04:57
Source Code
00:11
Client Side JavaScript Elements
07:19
Source Code
00:22
Google Script Run - Send Data
07:35
Source Code
00:12
More Google Script Functions
08:46
Source Code
02:42
Google Script Get More Data
09:01
Source Code
00:42
Client Side Use Data.
07:54
Source Code
00:33
User Interactions Client Side Coding.
06:42
Source Code
00:40
User Display of Content Client Side
05:12
Source Code
00:45
Email Search Results
07:43
Source Code
00:56
Apps Script Send Emails
07:16
Source Code
00:52
Add Selection to Spreadsheet
04:35
Source Code
00:56
Drive Application Manager Conclusion
04:45
Source Code
02:04

Open URL on bound sheet open - Trigger example - Client Side JavaScript UI class

16 lectures
Project Introduction Apps Script UI
04:16
Setup Google Apps Script Project.
02:01
Create PopUp HTML.
04:36
Source Code
00:02
Spreadsheet App UI button
02:44
Source Code
00:05
HTML and JavaScript in client Side
02:59
Source Code
00:05
On Failure to Run Callback.
02:27
Source Code
00:14
Open Page with JavaScript
01:43
Source Code
00:09
Setup Project Trigger.
04:04
Source Code
00:08
Project Code Review and Conclusion
11:27
Source and Resources
11:27

Google Apps Script Common Questions and Answers - Useful Code Snippets

23 lectures
Triggers onSelectionChange onEdit
11:15
Source Code Triggers
00:09
Setup Triggers using Google Apps Script Code
10:38
Source Code Setup of Project triggers
00:26
On Sheet open run script with onOpen Trigger bound and standalone scripts.
08:19
Setup Triggers on Open of Sheet
00:09
Gmail data into Spreadsheet
16:07
Source Code GmailApp labels and list messages into Spreadsheets Code Snippet
00:14
Web Apps Google Apps Script Code Example Class HtmlTemplate Evaluate
13:43
How to create HTML output in sidebar and modal and webapp Google Apps Script
00:18
Google Apps Script How to use Scriptlets HtmlService
08:20
Source Code how to include other files into Google Apps Script web app code
00:11
Apps Script Docs Tables Add Tables and Create Tables with Apps Script
16:50
Source Code for Apps Script Tables Demo
00:16
Copy of Document Contents using Element type and appending to new Document
13:38
How to copy Doc elements by type and place them in a new Document Code Example
00:13
How to send Emails from a Spreadsheet using Google Apps Script
18:43
How to use a custom HTML template for email and Updating Sheet when sent
09:08
Source Code Google Sheets emailer and updater mini project
00:32
GmailApp Class Labels
23:30
GmailApp Class Threads Messages Move threads and filter with Labels SourceCode
00:21
CopyTo examples SpreadsheetApp class examples
21:44
Source Code CopyTo SpreadsheetApp code examples
00:32

Google Apps Script New IDE

9 lectures
Introduction IDE new version section intro
01:43
getting started Google Apps Script IDE
10:16
Debugging new IDE Apps Script How to Debug.
08:35
Autocomplete Apps Script Code
08:07
Menu LeftSide Nav Apps Script
08:54
Apps Script Libraries and Services
07:15
Deploy Library Apps Script
13:31
Apps Script Web App Deploy.
08:30
Apps Script IDE Features review
08:46

Google Apps Script Coding Example and Exercises

8 lectures
Apps Script Coding Example Guide Code Snippets
12:16
Google Apps Script Examples Guide
01:08
Chart in sheets
20:34
Create Doc
03:13
Create Forms
02:20
Send Emails Automatically
01:59
Add Data to sheet
02:44
Automate Google email
01:50

Apps Script Code Examples and Question Responses

7 lectures
How to apply text style with Google Apps Script to Doc Content
10:33
Code Example Google Apps Script set Style of text with Code
00:16
Select emails from the Google Doc Body and highlight them with Style Regex match
09:48
Source Code Regex match Doc text content and apply style
00:13
Apps Script - Search Active Sheet to find matching text results of cells
09:20
Source code Apps Script - Search Active Sheet to find matching text results
00:32
Create a table in Docs from Sheet Values
09:28

Google Apps Script Project Examples and Source Code

1 lectures
4 Google Apps Script Sheets and UI menu Projects
19:47

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

The Complete UML Course (2024): Learn to Design UML Diagrams

The Complete UML Course (2024): Learn to Design UML Diagrams

25 VND
50.000 VND
Master Network Automation with Python for Network Engineers

Master Network Automation with Python for Network Engineers

1.699.000 VND
50.000 VND
Unity Mobile Game Development - Exterminator

Unity Mobile Game Development - Exterminator

1.499.000 VND
50.000 VND
Mastering CSS Grid 2023 - With 3 cool projects

Mastering CSS Grid 2023 - With 3 cool projects

99 VND
50.000 VND
Django 3 - Full Stack Websites with Python Web Development

Django 3 - Full Stack Websites with Python Web Development

1.699.000 VND
50.000 VND
Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

95 VND
50.000 VND
Appium - Mobile Testing with Latest 2.0 and Live Projects

Appium - Mobile Testing with Latest 2.0 and Live Projects

70 VND
50.000 VND
Deep Learning for Object Detection with Python and PyTorch

Deep Learning for Object Detection with Python and PyTorch

899.000 VND
50.000 VND
Full Android Development Masterclass | 14 Real Apps-46 Hours

Full Android Development Masterclass | 14 Real Apps-46 Hours

1.699.000 VND
50.000 VND
Go Java Full Stack with Spring Boot and Angular

Go Java Full Stack with Spring Boot and Angular

90 VND
50.000 VND
Machine Learning Practical Workout | 8 Real-World Projects

Machine Learning Practical Workout | 8 Real-World Projects

79 VND
50.000 VND
WordPress 2024: The Complete WordPress Website Course

WordPress 2024: The Complete WordPress Website Course

90 VND
50.000 VND
Android App Development Master Course with Java | Android

Android App Development Master Course with Java | Android

99 VND
50.000 VND
Unreal Engine 5: Soulslike Melee Combat System

Unreal Engine 5: Soulslike Melee Combat System

1.399.000 VND
50.000 VND
ASP.NET Core Web Application Using Razor Pages

ASP.NET Core Web Application Using Razor Pages

1.699.000 VND
50.000 VND
Build Undetectable Malware Using C Language: Ethical Hacking

Build Undetectable Malware Using C Language: Ethical Hacking

75 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi