Trang chủ

Programming Languages

Google Apps Script

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

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

Loại khoá học: Programming Languages

Automate your day to day tasks like a pro

50.000 VND

85 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

Mô tả

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."

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

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

Yêu cầu

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

Nội dung khoá học

15 sections

Introduction

6 lectures

Important Information

01:26

Writing the first line of code

07:34

Introduction

02:30

script Editor: Where codes are written

02:42

Good Practices for writing Codes

09:32

Know about Google App Script

3 questions

Handling Spreadsheet and For Loop

4 lectures

Accessing an outside spreadsheet

07:24

What can we do with the Spreadsheets

05:41

Introduction to for Loop

09:24

More on For Loop

09:12

IF Statement and Array

3 lectures

IF Statements

11:35

Array of Variables

17:00

Combining Array and For Loop

08:23

Commonly used Functions in Spreadsheet

5 lectures

Get Last Row of Spreadsheet

04:35

CopyTo : Copying from one cell to another

05:02

Change Name, Hide and Show Sheets

02:45

Customized Menu

05:59

Pop Up Dialogue Box

10:05

Live Project 1: Send email with details of Google Form

4 lectures

Creating Google Form

05:30

Setting up For Loop

07:00

Writing code for Loop

13:17

Automatically trigger the code

04:18

NEW COURSE: Introduction

2 lectures

Introduction

01:45

What is Google Apps Script and how code runs

17:38

NEW COURSE: Interacting with Google Sheets

4 lectures

Clarification on Authentication

01:22

Read Data from Google Sheet

24:03

Write data to Google Sheet

19:33

More action with Google Sheet

19:18

NEW COURSE: ARRAY

3 lectures

What is an Array

20:48

Read and Write Array in Google Sheet

10:29

Functions associated with Array

23:00

NEW COURSE: Conditional Executions (IF) and Loops

3 lectures

IF statements

13:37

FOR Loop

16:17

WHILE Loop

06:14

NEW COURSE: Basic Projects

3 lectures

Project 1: Combining Data from Individual Sheets

18:38

Project 2: Combining Multiple Rows of Data

24:15

Project 3: Combining Data from Different Google Spreadsheets

21:08

NEW COURSE: GMAIL APP

3 lectures

Read Email from Inbox

19:04

More action on Inbox

31:59

Send Email via Apps Script

16:24

NEW COURSE: CALENDAR APP

2 lectures

Read Events from Google Calendar

17:05

Write or Update Events in Google Calendar

36:33

DOCUMENT APP & SLIDE APP

3 lectures

Read and Write to a Google Doc

11:06

Read from Google Slide

14:05

Write to Google Slide

08:22

NEW COURSE: Interact with Google Drive and UI Elements

3 lectures

Get Files and Folders

23:27

Create PDF

16:28

UI Alert and Prompt

18:09

NEW COURSE: Projects

18 lectures

Project 4: Get Item from Orders

34:04

Project 5: Salary Report & History

17:12

Project 6: Attendance Sheet

14:55

Project 7: Merge Assemblies

17:03

Project 8: Pingpong Winning Streak

33:26

Project 8: Annexure

02:23

Project 9: Compare Data

18:24

Project 10: Managing Vendors & Quotations

42:10

Project 11: Invoice Management

27:15

Project 12: Client onboarding

33:28

Project 13: Send Certificate from Sheet

20:49

Project 14: Send Certificate using Google Doc

18:55

Project 15: Create Real Estate Documents

44:04

Project 16: Scrap Gmail Data

21:00

Project 17: Store all Gmail Attachment in Google Drive

20:18

Project 18: Create Profile Card in Google Slides and save as PDF

28:15

Project 19: Slot Booking System

22:51

Project 20: Creating Personal Library of Images and PDF

16:13

Đá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?

Email

Nội dung

Khoá học liên quan

Self Driving and ROS - Learn by Doing! Odometry & Control

Self Driving and ROS - Learn by Doing! Odometry & Control

Practice Exams | AWS Certified Solutions Architect Associate

Practice Exams | AWS Certified Solutions Architect Associate

Ethical Hacking Course by Black Hat Pakistan

Ethical Hacking Course by Black Hat Pakistan

AWS Cloud for beginner (Vietnamese)

AWS Cloud for beginner (Vietnamese)

OpenStack Essentials

OpenStack Essentials

Java Certification : OCA (1Z0-808) Exam Simulation [2023]

Java Certification : OCA (1Z0-808) Exam Simulation [2023]

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

Master Big Data - Apache Spark/Hadoop/Sqoop/Hive/Flume/Mongo

Reverse Engineering and Malware Analysis Fundamentals

Reverse Engineering and Malware Analysis Fundamentals

Microsoft Windows Server 2016 Training for Beginners

Microsoft Windows Server 2016 Training for Beginners

Learn Autocad API with C# - MVVM - WPF

Learn Autocad API with C# - MVVM - WPF

Ultimate AWS Certified Solutions Architect Associate SAA-C03

Ultimate AWS Certified Solutions Architect Associate SAA-C03

Website Hacking / Penetration Testing

Website Hacking / Penetration Testing

10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

10 Sample Exams ISTQB Foundation Level (CTFL) v4.0 [NEW!]

MongoDB : A Complete Database Administration Course

MongoDB : A Complete Database Administration Course

Become Zabbix Administrator For Expert

Become Zabbix Administrator For Expert

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Learn 5 PLCs in a Day-AB, Siemens, Schneider, Omron & Delta

Đă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