Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
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(158 ratings)
8,462 students

Google Apps Script Quick Start Beginner Guide

Google Apps Script allows you to power up you G Suite with amazing functionality based on JavaScript
Created byLaurence Svekis
Last updated 11/2024
English
English [Auto],

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 sections • 30 lectures • 1h 13m total length

  • Introduction Apps Script2:55

    Learn to use Google Apps Script and JavaScript to quickly automate emails, documents, and spreadsheets within the Google suite, with UI prompts and practical sample code.

  • Resource Guide0:17
  • Google Script Setup3:39

    Log into your Google account and create a new script at script.google.com. This cloud-based JavaScript environment integrates with Sheets, Docs, Gmail, Drive, and Calendar and includes guides and code samples.

  • Get Coding Google Apps Script7:10

    Learn to code with Google Apps Script by building standalone scripts, running and logging results, and creating Google documents with the document class and drive integration.

  • Source Code0:02
  • Create Google Files5:05

    Create Google files with Apps Script by building a document, accessing its body, appending a horizontal rule and a paragraph, and logging the URL and ID, using the spreadsheet app.

  • Source Code0:06
  • Create Spreadsheet Add Content2:25

    Learn how to append a row to a spreadsheet using Google Apps Script, handle default sheets, manage multi-sheet workbooks, and log the spreadsheet URL for dynamic content insertion.

  • Source Code0:04
  • Send an Email Google Script.4:37

    Send an email quickly with Google Apps Script using the mail service and mail app service, guided by the logger and session utilities. Master one-line email sending and permissions.

  • Source Code0:05
  • DocumentApp Class6:38

    Learn to open a Google document by id with DocumentApp, access the body, count and loop its children, inspect paragraph elements, and insert new paragraphs with a date.

  • Source Code0:09
  • Update element text3:36

    Update element text by selecting the document body, retrieving all paragraphs with get paragraphs, iterating with forEach, and append text with index-based updates.

  • Source Code0:11
  • Get Update Spreadsheet8:38

    Open a spreadsheet by id, access its first sheet, read data with get data range and get values, and append rows to update the sheet using Google Apps Script.

  • Source Code0:08
  • Bound Script UI Alert5:54

    Explore bound scripts that run inside a Google doc or sheet and access the document UI. Create a custom menu, trigger functions, and use UI alerts with yes/no options.

  • Source Code0:16
  • Bound Script UI Prompt4:05

    Master bound script UI prompts in Google Apps Script by collecting a user’s name with a prompt, handling OK cancel close options, and displaying the result in logs and alerts.

  • Source Code0:09
  • ActiveDocument Cursor3:37

    Access the active document, identify the cursor, and insert text at that position via a custom menu button in Google Apps Script, with a no cursor fallback.

  • Source Code0:04
  • ActiveSpreadsheet7:06

    Learn to bind a Google Apps Script to a spreadsheet, add a UI menu, and on open trigger to prompt for a sheet name and delete then create the sheet.

  • Source Code0:11
  • Copy Sheet Data to New Sheet.4:27

    Copy the active sheet data to a new sheet in Google Apps Script by capturing the active range values. Overwrite an existing sheet by name when needed.

  • Source Code0:06
  • Conclusion Apps Script1:22

    Master the basics of Google Apps Script and connect apps in the G Suite with practical code samples, a PBF resource guide, and Q&A support.

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

Report abuse