Google Apps Script: From Level Zero with 20 Projects (2023)

Focused View

Shahbaz Haidar

17:14:32

83 View

1 - Introduction

1 - Important Information.mp4

01:26

1 - Know about Google App Script.html

2 - Writing the first line of code.mp4

07:34

3 - Introduction.mp4

02:30

4 - script Editor Where codes are written.mp4

02:42

5 - Good Practices for writing Codes.mp4

09:32

2 - Handling Spreadsheet and For Loop

6 - Accessing an outside spreadsheet.mp4

07:24

7 - What can we do with the Spreadsheets.mp4

05:41

8 - Introduction to for Loop.mp4

09:25

9 - More on For Loop.mp4

09:12

3 - IF Statement and Array

10 - IF Statements.mp4

11:36

11 - Array of Variables.mp4

17:01

12 - Combining Array and For Loop.mp4

08:23

4 - Commonly used Functions in Spreadsheet

13 - Get Last Row of Spreadsheet.mp4

04:36

14 - CopyTo Copying from one cell to another.mp4

05:02

15 - Change Name Hide and Show Sheets.mp4

02:45

16 - Customized Menu.mp4

05:59

17 - Pop Up Dialogue Box.mp4

10:05

5 - Live Project 1 Send email with details of Google Form

18 - Creating Google Form.mp4

05:30

19 - Setting up For Loop.mp4

07:00

20 - Writing code for Loop.mp4

13:17

21 - Automatically trigger the code.mp4

04:18

6 - NEW COURSE Introduction

22 - Introduction.mp4

01:45

23 - What is Google Apps Script and how code runs.mp4

17:39

7 - NEW COURSE Interacting with Google Sheets

24 - Clarification on Authentication.mp4

01:22

25 - Google Sheet used in the Video.txt

25 - Read Data from Google Sheet.mp4

24:03

26 - Write data to Google Sheet.mp4

19:33

27 - More action with Google Sheet.mp4

19:18

8 - NEW COURSE ARRAY

28 - What is an Array.mp4

20:48

29 - Read and Write Array in Google Sheet.mp4

10:29

30 - Functions associated with Array.mp4

23:00

9 - NEW COURSE Conditional Executions IF and Loops

31 - IF statements.mp4

13:37

32 - FOR Loop.mp4

16:17

33 - WHILE Loop.mp4

06:14

10 - NEW COURSE Basic Projects

34 - Google Sheet with the Project Script.txt

34 - Project 1 Combining Data from Individual Sheets.mp4

18:38

35 - Google Sheet with the Project Script.txt

35 - Project 2 Combining Multiple Rows of Data.mp4

24:15

36 - Google Sheet with the Project Script.txt

36 - Project 3 Combining Data from Different Google Spreadsheets.mp4

21:08

11 - NEW COURSE GMAIL APP

37 - Read Email from Inbox.mp4

19:04

38 - More action on Inbox.mp4

31:59

39 - Send Email via Apps Script.mp4

16:24

12 - NEW COURSE CALENDAR APP

40 - Read Events from Google Calendar.mp4

17:05

41 - Write or Update Events in Google Calendar.mp4

36:33

13 - DOCUMENT APP And SLIDE APP

42 - Read and Write to a Google Doc.mp4

11:07

43 - Read from Google Slide.mp4

14:05

44 - Write to Google Slide.mp4

08:22

14 - NEW COURSE Interact with Google Drive and UI Elements

45 - Get Files and Folders.mp4

23:27

45 - Google Sheet used in the Video.txt

46 - Create PDF.mp4

16:28

47 - Google Sheet used in the Video.txt

47 - UI Alert and Prompt.mp4

18:09

15 - NEW COURSE Projects

48 - Google Sheet with the Project Script.txt

48 - Project 4 Get Item from Orders.mp4

34:04

49 - Google Sheet with the Project Script.txt

49 - Project 5 Salary Report And History.mp4

17:12

50 - Google Sheet with the Project Script.txt

50 - Project 6 Attendance Sheet.mp4

14:55

51 - Google Sheet with the Project Script.txt

51 - Project 7 Merge Assemblies.mp4

17:03

52 - Google Sheet with the Project Script.txt

52 - Project 8 Pingpong Winning Streak.mp4

33:26

53 - Project 8 Annexure.mp4

02:23

54 - Google Sheet with the Project Script.txt

54 - Project 9 Compare Data.mp4

18:24

55 - Google Sheet with the Project Script.txt

55 - Project 10 Managing Vendors And Quotations.mp4

42:10

55 - Quotation Template used in the Project.txt

56 - Google Sheet with the Project Script.txt

56 - Project 11 Invoice Management.mp4

27:15

57 - Google Sheet with the Project Script.txt

57 - Project 12 Client onboarding.mp4

33:28

58 - Google Sheet with the Project Script.txt

58 - Project 13 Send Certificate from Sheet.mp4

20:49

59 - Certificate Template.txt

59 - Google Sheet with the Project Script.txt

59 - Project 14 Send Certificate using Google Doc.mp4

18:55

60 - Google Sheet with the Project Script.txt

60 - NOC Template.txt

60 - Novation Template.txt

60 - Project 15 Create Real Estate Documents.mp4

44:04

61 - Google Sheet with the Project Script.txt

61 - Project 16 Scrap Gmail Data.mp4

21:00

62 - Google Sheet with the Project Script.txt

62 - Project 17 Store all Gmail Attachment in Google Drive.mp4

20:18

63 - Google Sheet with the Project Script.txt

63 - Google Slide Template used in the Project.txt

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

28:15

64 - Google Sheet with the Project Script.txt

64 - Project 19 Slot Booking System.mp4

22:51

65 - Google Sheet with the Project Script.txt

65 - Project 20 Creating Personal Library of Images and PDF.mp4

16:13

Description

Automate your day to day tasks like a pro

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

Who is this for?

If you want to start coding, this course can help you a lot, as I have started from very basic and described how a software works

If yo want to pursue your career as automation expert, this course is very good starting point, as it will help you to achieve very complicated things in few steps.

If you have a hobby of using google sheet for anything and everything, this course is for you, to take it to next level.

If you use different tools by google like Google Sheet, Doc, Slide etc. and want to connect all of them to improve the efficiency, this course is definitely for you.

What You Need to Know?

Basic knowledge of Google Spreadsheet as it will help you to understand better the output and results

Not a must, but if you have some experience with coding with any programming language, it will help

Hunger for knowledge

More details

Description
Since I am a full time Google Spreadsheet and Apps ScriptÂ consultant, with clients all over the world,Â I know what are the things that are important and should be taught to students.
Google Apps Script is a powerful tool by Google that takes the productivity of a team, or process to next level. One can use this toÂ
Automate data calculation
Fetching data from 3rd party software like Trello, Salesforce etc (Not Covered in this Introduction Course)
Sending data to 3rd party
Connecting various sheets , Documents and other tools
Setting a trigger for an action, based on an event. For Example, send an Email, when form is filled
The best part of writing codes in Google Apps script is that you do not need to worry about hosting the code on a server and maintaining it. Google takes care of everything. You write the lines of codes and it is up and running. Above all, it is free.
Here are some thoughts by students of this course:
"This has been of the best course I've taken in Udemy. One can begin to apply the new knowledge to real world almos instantly. I cant wait to take another Shahbaz course. Thanks!!!"
"I really enjoyed this class -- I think for a beginner or even someone who has a little experience but needs to see more examples of how to use the Google Apps documentation, this is a great course. The pace of the course was also nice for beginners. You will not be an expert after you finish this course but you will have a good understanding of the fundamentals and you will be more comfortable using the Google documentation on your own. This course sets the learner up perfectly for a follow-up intermediate level course and it would be great to see this instructor add an intermediate level course to this one with more real world projects. Thanks for sharing your knowledge -- nice job."
"Detailed instructions at a good pace. The course was short and accomplishable within a certain time period ending with a real world application."
Who this course is for:
If you want to start coding, this course can help you a lot, as I have started from very basic and described how a software works
If yo want to pursue your career as automation expert, this course is very good starting point, as it will help you to achieve very complicated things in few steps.
If you have a hobby of using google sheet for anything and everything, this course is for you, to take it to next level.
If you use different tools by google like Google Sheet, Doc, Slide etc. and want to connect all of them to improve the efficiency, this course is definitely for you.

User Reviews

Rating

average 0

Total votes0

Focused display

When I started my career as a Marketing Manager, the biggest problem I had was recording the events happening around me. Then I realized Google Spreadsheet need to be a part of my life. After that I have never looked back. At least more than 10 companies are using Sheets and Dashboards that I designed for them. Now I also design dashboards as a freelancer.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.