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

Focused View

Shahbaz Haidar

2:29:32

97 View

1 - Introduction

1 - Introduction.mp4

02:30

1 - Know about Google App Script.html

2 - script Editor Where codes are written.mp4

02:42

3 - Writing the first line of code.mp4

07:34

4 - Good Practices for writing Codes.mp4

09:32

2 - Handling Spreadsheet and For Loop

5 - Accessing an outside spreadsheet.mp4

07:24

6 - What can we do with the Spreadsheets.mp4

05:41

7 - Introduction to for Loop.mp4

09:25

8 - More on For Loop.mp4

09:12

3 - IF Statement and Array

9 - IF Statements.mp4

11:36

10 - Array of Variables.mp4

17:01

11 - Combining Array and For Loop.mp4

08:23

4 - Commonly used Functions in Spreadsheet

12 - Get Last Row of Spreadsheet.mp4

04:36

13 - CopyTo Copying from one cell to another.mp4

05:02

14 - Change Name Hide and Show Sheets.mp4

02:45

15 - Customized Menu.mp4

05:59

16 - Pop Up Dialogue Box.mp4

10:05

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

17 - Creating Google Form.mp4

05:30

18 - Setting up For Loop.mp4

07:00

19 - Writing code for Loop.mp4

13:17

20 - Automatically trigger the code.mp4

04:18

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.

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

Google Apps Script

Shahbaz Haidar

Instructor's Courses

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.