Google Apps Script Quick Start Beginner Guide

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

  • ( 5.0 ) (2 Reviews) 87 students enrolled

Course Overview

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 an 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 a new sheet using script

·         Updating and copying sheet data selected by the 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 the requirements?

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

What am I going to get from this course?

  • 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

What is the target audience?

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

About the Author

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 Curriculum

Introduction to Writing Google Apps Script Code
13 Document Lectures | 15 Video Lectures | 01:11:21

  • Introduction Apps Script
    02:56
     
  • Resource Guide
    14 Page
  • Google Script Setup
    03:39
     
  • Get Coding Google Apps Script
    07:10
     
  • Source Code
    1 Page
  • Create Google Files
    05:05
     
  • Source Code
    1 Page
  • Create Spreadsheet Add Content
    02:25
     
  • Source Code
    1 Page
  • Send an Email Google Script.
    04:37
     
  • Source Code
    1 Page
  • DocumentApp Class
    06:39
     
  • Source Code
    1 Page
  • Update element text
    03:37
     
  • Source Code
    1 Page
  • Get Update Spreadsheet
    08:39
     
  • Source Code
    1 Page
  • Bound Script UI Alert
    05:54
     
  • Source Code
    1 Page
  • Bound Script UI Prompt
    04:06
     
  • Source Code
    1 Page
  • ActiveDocument Cursor
    03:37
     
  • Source Code
    1 Page
  • ActiveSpreadsheet
    07:06
     
  • Source Code
    1 Page
  • Copy Sheet Data to New Sheet.
    04:28
     
  • Source Code
    1 Page
  • Conclusion Apps Script
    01:23
     

reviews

  • Giri Gel
    Bana
  • Rashid Badar
    great