Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Google Apps Script Quick Start Beginner Guide
Rating: 4.6 out of 5(157 ratings)
8,429 students
Created byLaurence Svekis
Last updated 11/2024
English

What you'll learn

  • Google Apps Script and how to apply it
  • Useful code to start writing and explore what can be done with Google Apps Script
  • Edit and create Google Scripts
  • GSuite of applications with Google Apps Script

Course content

2 sections30 lectures1h 13m total length
  • Introduction Apps Script2:55
  • Resource Guide0:17
  • Google Script Setup3:39
  • Get Coding Google Apps Script7:10
  • Source Code0:02
  • Create Google Files5:05
  • Source Code0:06
  • Create Spreadsheet Add Content2:25
  • Source Code0:04
  • Send an Email Google Script.4:37
  • Source Code0:05
  • DocumentApp Class6:38
  • Source Code0:09
  • Update element text3:36
  • Source Code0:11
  • Get Update Spreadsheet8:38
  • Source Code0:08
  • Bound Script UI Alert5:54
  • Source Code0:16
  • Bound Script UI Prompt4:05
  • Source Code0:09
  • ActiveDocument Cursor3:37
  • Source Code0:04
  • ActiveSpreadsheet7:06
  • Source Code0:11
  • Copy Sheet Data to New Sheet.4:27
  • Source Code0:06
  • Conclusion Apps Script1:22

Requirements

  • JavaScript, HTML and CSS
  • Prior programming knowledge
  • Solid understanding of JavaScript

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.

DO NOT TAKE THIS COURSE IF YOU HAVE NO JAVASCRIPT EXPERIENCE  - JAVASCRIPT IS AN ABSOLUTE PREREQUISITE!!!

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.

Who this course is for:

  • Web developers
  • Application developers
  • Anyone who wants to learn more about Google Apps Script
  • Anyone who wants to automate Google Suite
  • JavaScript coders