Google Apps Script Quick Start Beginner Guide

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

4.40 (113 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
Google Apps Script Quick Start Beginner Guide
7,475
students
1 hour
content
Feb 2023
last update
FREE
regular price

What you will 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

Why take this course?

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.

Content

Introduction to writing Google Apps Script Code

Introduction Apps Script
Resource Guide
Google Script Setup
Get Coding Google Apps Script
Source Code
Create Google Files
Source Code
Create Spreadsheet Add Content
Source Code
Send an Email Google Script.
Source Code
DocumentApp Class
Source Code
Update element text
Source Code
Get Update Spreadsheet
Source Code
Bound Script UI Alert
Source Code
Bound Script UI Prompt
Source Code
ActiveDocument Cursor
Source Code
ActiveSpreadsheet
Source Code
Copy Sheet Data to New Sheet.
Source Code
14

Bonus Section

Bonus Lecture

Screenshots

Google Apps Script Quick Start Beginner Guide - Screenshot_01Google Apps Script Quick Start Beginner Guide - Screenshot_02Google Apps Script Quick Start Beginner Guide - Screenshot_03Google Apps Script Quick Start Beginner Guide - Screenshot_04

Reviews

Sonia
August 11, 2021
Excellent intro to Google Apps Script for Docs and Sheets. Shows enough to spark the imagination and motivate reading through the documentation. Heed the requirements. You absolutely need at least a solid understanding of JavaScript fundamentals.
Igal
July 18, 2021
The code samples were very helpful for C&P. A quick walkthrough of reference resources for JS would also be very helpful.
Matthew
November 9, 2020
I appreciate the Quick start as a quick intro into what you can do with Google App Script. I will continue with his more in-depth course on Google App Script.
Amroe
October 11, 2020
It's fun, provides enlightenment for beginners in programming, especially for Google Apps Script. Always inspired by Laurence's class to get deeper into GAS...

Charts

Price

Google Apps Script Quick Start Beginner Guide - Price chart

Rating

Google Apps Script Quick Start Beginner Guide - Ratings chart

Enrollment distribution

Google Apps Script Quick Start Beginner Guide - Distribution chart

Related Topics

2509614
udemy ID
8/14/2019
course created date
8/16/2019
course indexed date
Bot
course submited by