Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Google Apps Script Beginners Course

person icon Laurence Svekis

4.1

Google Apps Script Beginners Course

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

English [CC]

category icon Development,Programming Languages,Programming Languages Other

Lectures -18

Resources -2

Duration -1 hours

4.1

price-loader

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
Google Apps Script Beginners Course

Curriculum

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

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

Instructor Details

Laurence Svekis

Laurence Svekis

e


Course Certificate

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

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515