Skip to content

Google Apps Script for Beginners- Amazing Things with Code

CM


eTrain

Summary

Price
£99 inc VAT
Or £33.00/mo. for 3 months...
Study method
Online
Duration
3 hours · Self-paced
Access to content
1 year
Qualification
No formal qualification
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students

Overview

Get started with Google Apps Script - Perfect course for beginners who want to explore what they can do with Google Apps Script

Apps Script is based on JavaScript 1.6, (1.7 and 1.8). Many basic JavaScript features in addition to the built-in and advanced Google services. Apps Script code runs on Google's servers. Knowledge of JavaScript is a prerequisite to Google Apps Script which will allow you to jump right in and begin coding. - Just like JavaScript with some extra methods.

The course covers the following topics and is designed a quick beginners guide to using and creating Google Apps Script applications.

  • How and where to begin coding
  • How Google Apps Script works
  • Google Marcos - really apps script code
  • Editing and updating script code
  • Getting familiar with the Script editor
  • Standalone and Bound scripts
  • Document Service
  • JavaScript in Google Apps Script
  • JavaScript Variables, Arrays, Objects, Loops, Conditions, Functions....
  • Coding JavaScript within Apps Script
  • Explore the online editor File Tab
  • Creating new files
  • Apps Script triggers
  • View tab and debugging
  • Run tab and debugging
  • Create a web app publish tab
  • Using html file for client side web app
  • Web apps made dynamic
  • Dialogs and UI options
  • Document as PDF
  • Spreadsheet service
  • Sheet data and UI
  • Copy and select content in range and objects
  • Spreadsheet and calendar

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

Requirements:

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

Description

Course Curriculum

Introduction to Google Apps Script writing Code and Functionality

Introduction to Google Apps Script Course (4:42)

Google Apps Script (3:03)

Macros for Script (5:19)

More fun with Macros (3:55)

Google Apps Script Scripting (1:57)

Create Standalone Script (11:12)

Get by ID Document (5:24)

Document Service (3:59)

JavaScript code and Google Apps Script Coding

JavaScript in Apps Script (5:30)

JavaScript Array (5:26)

Google Sheets AppendRow (4:31)

JavaScript Objects (3:43)

JavaScript Functions (3:49)

JavaScript Conditions (2:54)

JavaScript Loops (3:31)

Explore the online IDE Code editor for Google Apps Script

Online Google Script Editor IDE Online Editor (3:07)

Online Google Script Editor Edit Tab (5:18)

Online Google Script Editor View Tab (1:47)

IDE Run Google Apps Script Editor (1:46)

WebApp launch and Publish Tab (6:51)

Web App Dynamic Code (2:45)

Editor Resources and Help (2:16)

Document App UI and Spreadsheet App - Fun with Google Apps Script Projects

Document Service (4:17)

Dialogs and custom UI buttons (8:34)

Document as PDF (8:00)

Spreadsheet Data (4:27)

Add new sheet (6:28)

Copy Content in Sheet (4:34)

Calendar Data to Spreadsheet (10:08)

Google Apps Script Conclusion (5:00)

Frequently Asked Questions

When does the course start and finish?

The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.

How long do I have access to the course?

After enrolling, you will have unlimited course access for 12 months.

What if I am unhappy with the course?

We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Who is this course for?

Requirements

Career path

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.