Name: Getting started with Google Apps Script - Aryan Irani
Rating: 4.5 (6 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byAryan Irani

Last updated 12/2021

English

What you'll learn

Learn the basics of Google Apps Script
Create amazing projects using Google Apps Script
Use Google Apps Script for automation
Use Google Apps Script to interact with Google Workspace Apps [Google Sheets, Google Forms, Google Classroom]

Course content

5 sections • 16 lectures • 2h 41m total length

Introduction to Google Apps Script1:09

Variables in Google Apps Script10:05
Welcome to the First video in the Google Apps Script Course. In this video, we are going to take a look at variables in Google Apps Script.
Operators in Google Apps Script9:57
Welcome to the second video in the Google Apps Script Course. In this video, we are going to take a look at Operators in Google Apps Script.
Arrays and Objects in Google Apps Script15:02
Welcome to the third video in the Google Apps Script. In this video, we are going to take a look at Arrays and Objects in Google Apps Script.
Loops in Google Apps Script10:49
Welcome to the Fourth video in the Google Apps Script course. In this video, we will be taking a look at loops in Google Apps Script.

Get and set data in Google Sheets using Google Apps Script17:40
Welcome to the first video in the Google Sheets and Google Apps Script section. In this video, we will be working with Google Sheets using Google Apps Script. We will be getting and setting values in Google Sheets using Google Apps Script.
Change the color of cells in Google Sheets using Google Apps Script10:01
Welcome to the second video in the Google Sheets and Google Apps Script section. In this video, we will be changing the colours of cells in Google Sheets as soon as it meets a particular condition using Google Apps Script.
Send out Bulk emails using Google Apps Script14:22
Welcome to the third video in the Google Sheets and Google Apps Script section. In this video, we will be sending out bulk emails with data from a Google Sheet using Google Apps Script.
Macros in Google Sheets6:33
Welcome to the fourth video in the Google Sheets and Google Apps Script section. In this video, we will be taking a look at macros in Google Sheets
Custom functions in Google Sheets6:39
Welcome to the last video in the Google Sheets and Google Apps Script section. In this video, we will be taking a look at custom functions in Google Sheets using Google Apps Scrip.

Interacting with Google Forms using Google Apps Scirpt8:42
Welcome to the first video in the Google Forms and Google Apps Script section. In this video, we will be interacting with a Google Form using Google Apps Script.
Limit Responses in Google Forms using Google Apps Script8:23
Welcome to the second video in the Google Forms and Google Apps Script section. In this video, we will be taking a look at limiting responses in Google Forms using Google Apps Script.
Autofill options in Google Forms using Google Apps Script12:47
Welcome to the third video in the Google Forms and Google Apps Script section. In this video, we will be taking a look at auto-filling options in Google Forms using Google Apps Script.

Create Google Classrooms using Google Apps Script12:20
Welcome to the first video, in this video we will be using Google Apps Script to create Google Classrooms.
Add YouTube videos to playlist using Google Apps Script10:20
Welcome to the second video, in this video we will be getting YouTube statistics into our Google Sheet using Google Apps script.
Create Calendar Events using Google Apps Script6:21
Welcome to the last video in this course. In this video we will be creating Calendar Events from a Google Sheet using Google Apps Script.

Requirements

Internet Access
Google Account
Basic understanding of programming

Description

Hey folks !! Welcome to Getting started with Google Apps Script. If you are reading this description, this means that you are really interested in mastering Google Apps Script and let me tell you have reached the right place. If you want to learn Google Apps Script from the basics such as variables, loop and more, and want to work your way up the Apps Script ladder, let me tell you this is the course for you.

In this course, we will be covering the basics of Google Apps Script and working our way by working with Google Sheets, Google Workspace API's and more. After working with variables, operators, loops in Google Apps Script, we will be working with Google Sheets, where we will start out by getting and setting values in Google Sheets, followed by doing some amazing projects in Google Sheets and Google Apps Script. After working with Google Sheets, we will work with Google Forms, Google Classroom, YouTube and more.

By the end of this course, you will have a handful of automation projects in Google Apps Script, that you can add to your GitHub. You will be able to code well in Google Apps Script and make wonders.

Who this course is for:

Google Apps Script for developers
Anyone who wants to learn and use Google Apps Script for automation

What you'll learn

Explore related topics

Course content

Introduction to the Course1 lecture • 1min

Basics of Google Apps Script4 lectures • 46min

Google Sheets and Google Apps Script5 lectures • 55min

Google Forms and Google Apps Script3 lectures • 30min

Google Workspace API's and Google Apps Script3 lectures • 29min

Requirements

Description

Who this course is for: