[Last updated 3/2023] Google Apps Script: From Level Zero with 20 Projects (2023) (Udemy – Engsub)

About Course

Views

What you’ll learn:
What is Google Apps Script
How Software Code Works
IF, LOOP, Array etc.
Write Google Apps Script to perform various tasks
Connect Google Sheets with Google Doc, Slide, Gmail, Calendar and Drive
Generate Documents from Template
20 real life projects

Link gốc:
https://www.udemy.com/course/learn-google-app-script-from-zero-to-pro-level/

Time Course:
17 hours (65 Lectures + Documents)

Instructor
: Shahbaz Haidar
Total Weight:
10.28 GB
** Note
:

Chú ý:

Course Content

01 – Introduction

001 Important Information.mp4

01:26
002 Writing the first line of code.mp4

07:34
003 Introduction.mp4

02:30
004 script Editor Where codes are written.mp4

02:41
005 Good Practices for writing Codes.mp4

09:32

02 – Handling Spreadsheet and For Loop

03 – IF Statement and Array

04 – Commonly used Functions in Spreadsheet

05 – Live Project 1 Send email with details of Google Form

06 – NEW COURSE Introduction

07 – NEW COURSE Interacting with Google Sheets

08 – NEW COURSE ARRAY

09 – NEW COURSE Conditional Executions (IF) and Loops

10 – NEW COURSE Basic Projects

11 – NEW COURSE GMAIL APP

12 – NEW COURSE CALENDAR APP

13 – DOCUMENT APP & SLIDE APP

14 – NEW COURSE Interact with Google Drive and UI Elements

15 – NEW COURSE Projects

010 Project 12 Client onboarding.mp4

33:28
018 Project 20 Creating Personal Library of Images and PDF.mp4

16:13
017 Project 19 Slot Booking System.mp4

22:51
016 Project 18 Create Profile Card in Google Slides and save as PDF.mp4

28:15
015 Project 17 Store all Gmail Attachment in Google Drive.mp4

20:18
014 Project 16 Scrap Gmail Data.mp4

21:00
013 Project 15 Create Real Estate Documents.mp4

44:04
012 Project 14 Send Certificate using Google Doc.mp4

18:55
011 Project 13 Send Certificate from Sheet.mp4

20:49
001 Project 4 Get Item from Orders.mp4

34:04
009 Project 11 Invoice Management.mp4

27:15
008 Project 10 Managing Vendors & Quotations.mp4

42:10
007 Project 9 Compare Data.mp4

18:24
006 Project 8 Annexure.mp4

02:23
005 Project 8 Pingpong Winning Streak.mp4

33:26
004 Project 7 Merge Assemblies.mp4

17:03
003 Project 6 Attendance Sheet.mp4

14:55
002 Project 5 Salary Report & History.mp4

17:12

Student Ratings & Reviews

No Review Yet

About Course

Course Content

01 – Introduction

001 Important Information.mp4

002 Writing the first line of code.mp4

003 Introduction.mp4

004 script Editor Where codes are written.mp4

005 Good Practices for writing Codes.mp4

02 – Handling Spreadsheet and For Loop

001 Accessing an outside spreadsheet.mp4

002 What can we do with the Spreadsheets.mp4

003 Introduction to for Loop.mp4

004 More on For Loop.mp4

03 – IF Statement and Array

001 IF Statements.mp4

002 Array of Variables.mp4

003 Combining Array and For Loop.mp4

04 – Commonly used Functions in Spreadsheet

001 Get Last Row of Spreadsheet.mp4

002 CopyTo Copying from one cell to another.mp4

003 Change Name, Hide and Show Sheets.mp4

004 Customized Menu.mp4

005 Pop Up Dialogue Box.mp4

05 – Live Project 1 Send email with details of Google Form

001 Creating Google Form.mp4

002 Setting up For Loop.mp4

003 Writing code for Loop.mp4

004 Automatically trigger the code.mp4

06 – NEW COURSE Introduction

001 Introduction.mp4

002 What is Google Apps Script and how code runs.mp4

07 – NEW COURSE Interacting with Google Sheets

001 Clarification on Authentication.mp4

002 Read Data from Google Sheet.mp4

003 Write data to Google Sheet.mp4

004 More action with Google Sheet.mp4

08 – NEW COURSE ARRAY

001 What is an Array.mp4

002 Read and Write Array in Google Sheet.mp4

003 Functions associated with Array.mp4

09 – NEW COURSE Conditional Executions (IF) and Loops

001 IF statements.mp4

002 FOR Loop.mp4

003 WHILE Loop.mp4

10 – NEW COURSE Basic Projects

001 Project 1 Combining Data from Individual Sheets.mp4

002 Project 2 Combining Multiple Rows of Data.mp4

003 Project 3 Combining Data from Different Google Spreadsheets.mp4

11 – NEW COURSE GMAIL APP

001 Read Email from Inbox.mp4

002 More action on Inbox.mp4

003 Send Email via Apps Script.mp4

12 – NEW COURSE CALENDAR APP

001 Read Events from Google Calendar.mp4

002 Write or Update Events in Google Calendar.mp4

13 – DOCUMENT APP & SLIDE APP

001 Read and Write to a Google Doc.mp4

002 Read from Google Slide.mp4

003 Write to Google Slide.mp4

14 – NEW COURSE Interact with Google Drive and UI Elements

001 Get Files and Folders.mp4

002 Create PDF.mp4

003 UI Alert and Prompt.mp4

15 – NEW COURSE Projects

010 Project 12 Client onboarding.mp4

018 Project 20 Creating Personal Library of Images and PDF.mp4

017 Project 19 Slot Booking System.mp4

016 Project 18 Create Profile Card in Google Slides and save as PDF.mp4

015 Project 17 Store all Gmail Attachment in Google Drive.mp4

014 Project 16 Scrap Gmail Data.mp4

013 Project 15 Create Real Estate Documents.mp4

012 Project 14 Send Certificate using Google Doc.mp4

011 Project 13 Send Certificate from Sheet.mp4

001 Project 4 Get Item from Orders.mp4

009 Project 11 Invoice Management.mp4

008 Project 10 Managing Vendors & Quotations.mp4

007 Project 9 Compare Data.mp4

006 Project 8 Annexure.mp4

005 Project 8 Pingpong Winning Streak.mp4

004 Project 7 Merge Assemblies.mp4