Google Apps Script Beginners Course

person icon Laurence Svekis

3.9 ★★★ ★ ★

Buy Now

Google Apps Script Beginners Course

Name: Google Apps Script Beginners Course
Rating: 3.9 (379 reviews)
Author: Laurence Svekis

Google Apps Script allows you to power up you G Suite with amazing functionality based on JavaScript

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Laurence Svekis

category icon Development,Programming Languages,Programming Languages Other

Lectures -18

Resources -2

Duration -1 hours

3.9 ★★★ ★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite.

Explore how you can start using Google Apps Script to run code to make things happen within Google Suite of Apps.

BONUS - Downloadable PDF course Guide - with links and resources.

The course covers the following in regards to Apps Script and how to use it

Apply JavaScript methods within Apps Script like Date()
Create a document using script - add content to the document
Create a Spreadsheet using script
Get object info like ID and URL
Using session to get active user email address
Using Mail Service to send emails via script
DocumentApp and accessing updating existing docs by id
SpreadsheetApp and accessing data contained in existing sheets
Bound script in Docs and Sheets
How to add UI menu items
Running script functions from UI menu tab
Creating UI alerts
UI prompts to get user input and data
Active document get cursor location
Creating new sheet using script
Updating and copying sheet data selected by user

Source Code is included

Fast friendly support within the Q&A section - taught by an instructor with over 20 years of web development experiencing ready to help you learn.

What are you waiting for join now and start creating your own amazing projects with Google Apps Script.

Goals

What will you learn in this course:

Explore what you can do with Google Apps Script
Create Google Apps Script Apps
Connect G Suite products together

Prerequisites

What are the prerequisites for this course?

JavaScript
Prior Coding Experience
Google Account

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction to writing Google Apps Script Code
17 Lectures

Introduction Apps Script 02:55 02:55
Resource Guide
Course Resources
Google Script Setup 03:39 03:39
Get Coding Google Apps Script 07:10 07:10
Create Google Files 05:05 05:05
Create Spreadsheet Add Content 02:25 02:25
Send an Email Google Script 04:37 04:37
DocumentApp Class 06:38 06:38
Update element text 03:36 03:36
Get Update Spreadsheet 08:38 08:38
Bound Script UI Alert 05:54 05:54
Bound Script UI Prompt 04:05 04:05
ActiveDocument Cursor 03:37 03:37
ActiveSpreadsheet 07:06 07:06
Copy Sheet Data to New Sheet 04:27 04:27
Conclusion Apps Script 01:22 01:22

Instructor Details

Laurence Svekis

Instructor, GDE, Application Developer

I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today
Google Developers Expert - GSuite

Providing Web development courses and digital marketing strategy courses since 2002.

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998. I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education. The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online. Technology connects us all in many ways. It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications. Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO.

"Understanding technology provides a means to better connect with users. It also opens so many doors. Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"

Course Certificate

Use your certificate to make a career change or to advance in your current career.