Google Apps Script 2020: Build 16+ Fun Projects Sites GSuite

Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite. This course gives you an introduction to Google Apps Script. Find out how it works, get a quick refresher on JavaScript fundamentals like variables, arrays, objects, loops, functions, and conditions. Try it out and see with just a few lines of code how you can create a doc, spreadsheet access the Google Calendar add events and send emails with Script. This course comes with 16 projects that you need to build while you learn.

1,082 positive reviews from 7,640 students enrolled

Access 233 lectures & 21 hours of content 24/7

Build amazing web apps

Connect to your Google Spreadsheet as a source of data for your website

Emails users with the power of Gmail

Track users in a spreadsheet

Get messages from users right into a spreadsheet

Share content of your drive

Projects

Form Submission auto response

YouTube API - Connect to YouTube

Spreadsheet User data Project

Spreadsheet Mini Projects

Spreadsheet Data as API JSON

GDrive Image Gallery

HTML5 Canvas image uploade

HTML editor saving HTML files

Simple Auto Response

PDF Uploader

GmailApp

WebApp Sheet Data as API

Consent Form Exercise: JS Cloud

Google Sheets, JSON data source for JS

Build a team site on sites

Simple Google Sheet input

"I am very pleased with this course, it has great real-life examples. The teacher explained it all in depth and it is easy to follow. Thanks Laurence!" – Ivan Josipovic

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

Google Apps Script: Set Up Simple Twitter Posting Bot

If you use social media for brand marketing, this course is for you. Explore how you can connect your Twitter Account using Google Apps Script and automate posts coming from your Spreadsheet data. All of the source code is included as well as 12 step-by-step lessons to help you learn about the code being used and illustrate what it does. By the end of this course, you'll be able to automate Twitter posting and simplify marketing.

1,331+ students enrolled

Access 12 lectures & 1 hour of content 24/7

Create a Spreadsheet & add script

Set up an app as a Twitter Developer, create the app & get secret keys and tokens to automate Twitter interactions

Access Google Apps Script Developer Code Editor & write Google Script

Know which library to use & how to add libraries of existing code to your Google Apps Script

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

Google Apps Script Complete Course: Beginner to Advanced

Apps Script lets you do more with Google and that's what this course is all about. Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. This course covers every step to get started with Google Scripts including an overview of the editor and what it does and how to use it. Followed by more detailed syntax and code examples of applying Google Script in real-world projects. Automate, add functionality, use spreadsheet data, create documents, interact with emails, generate reports, use data the list is endless on all the amazing things you can do with Google Apps Script. Warning once you start using Google Apps Script you may want to use it for everything!

1,097 positive reviews from 7,674 students enrolled

Access 119 lectures & 12 hours of content 24/7

Learn about selection of data & construction of content

Use Spreadsheet UI for added interactions w/ users

Design sites interface w/ options to create pages & more

"He has also done a good job at moving slowly and not assuming certain information was already known by me as the student." – Tim Pedersen

"Laurence does a great job with breaking down how to do great things within Google Apps Script" – Cordelle Griffin

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

Google Apps Google Script: Content System Web App Project

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, and Sheets. Apps Script lets you do more with Google...all on a JavaScript platform in the cloud. If you know JavaScript you can jump right in and start creating web apps connecting all of your Google applications together. Automate your work you will be amazed at how easy it is to work with Apps Script. This is a project-based course and the scope of the course is to use technologies like HTML, CSS, JavaScript, jQuery, Bootstrap to create the project. All of the source code is included.

"Well paced and informative. The instructor covered the key items without getting bogged down in minute details. Enough information for the student to grasp and nowhere to look for help when experimenting." – Ged Mirski-Fitton

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

581,302 Total Students

33,520 Reviews

Important Details

Length of time users can access this course: lifetime

Access options: web & mobile streaming

Certification of completion included

Redemption deadline: redeem your code within 30 days of purchase

Updates included

Experience level required: all levels

Requirements

JavaScript

HTML CSS

Google Account

jQuery

Bootstrap

Course Outline

Write Google Script to create and connect Google apps together

1 Google Scripts Introduction - 8:51

2 What is Google Scripts - 3:21

3 Setup Google account open script editor - 3:36

4 How to Create a Google Doc with Google Script - 9:28

5 Access existing document and add content Google Script - 5:47

6 Setup Triggers Run script using Google Script - 3:55

7 Run method to copy current content and output as bold Google Script Doc - 8:29

Google Apps Script Projects

Do you want to connect Google Apps Together and make some really amazing things happen? This course will provide you the foundation to work with Google Script to build a Web App that can be embedded in Google Sites. Within the course, you'll learn how to use Google Spreadsheet as a source for retrieving and storing data. Power up what you do online, bringing together built-in functionality in your Google Suite. Source Code is included so you can build the same app in the course but even better!

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

581,302 Total Students

33,520 Reviews

Important Details

Length of time users can access this course: lifetime

Access options: web & mobile streaming

Certification of completion included

Redemption deadline: redeem your code within 30 days of purchase

Updates included

Experience level required: all levels

Requirements

Computer with internet access

Google Account

JavaScript Knowledge

Course Outline

Google Apps Script for Beginners- Amazing Things with Code

0 Google Apps Script Introduction - 4:42

Resource Guide

1 Marcos for Script - 5:19

2 More fun with Marcos - 3:55

3 Google Apps Script Scripting - 1:57

4 Create Standalone Script - 11:12

5 Get by ID Document - 5:24

6 Document Service - 3:59

7 JavaScript in Apps Script - 5:30

8 JavaScript Arrays - 5:26

9 Google Sheets AppendRow - 4:31

10 JavaScript Objects - 3:43

11 JavaScript Functions - 3:49

12 JavaScript Conditions - 2:54

13 JavaScript Loops - 3:31

14 IDE Online Editor - 3:07

15 IDE edit tab - 5:18

16 IDE view tab - 1:47

17 IDE Run - 1:46

18 Publish Tab - 6:51

19 Web App Dynamic Code - 2:45

20 Editor Resources and Help - 2:16

21 Document Service - 4:17

22 Dialogs and custom UI buttons - 8:34

23 Document as PDF - 8:00

24 Spreadsheet Data - 4:27

25 Add new sheet - 6:28

26 Copy Content in Sheet - 4:34

27 Calendar Data to Spreadsheet - 10:08

28 Google Apps Script Conclusion - 5:00

Google Script Create Google Docs on the fly from templates

1 Introduction to Google Scripts - 7:41

2 Make Google Folders and Files - 3:29

3 Setup Files and Headings - 4:17

4 Create menu items to launch functions - 7:13

5 Source Code for GS

6 Create HTML Popup Dialog Window - 8:22

7 Source Code to Get HTML file contents

8 Build HTML frontend - 6:40

9 List gDrive files - 8:24

10 source code

11 List Google Drive Contents into Google Spreadsheet - 11:04

12 source code

13 Read Document Content use body content in Google Script - 12:00

14 Use Google Script Get Spreadsheet data and return as an array - 6:23

Google App – Gmail: Increase your Email Productivity

15+ Tips to Save Time & Be More Productive with Your Emails

If you're handling business you probably have times when you almost drown in a bunch of emails that you haven't read. Not only does it take time to skim all of them, you'll also have to reply! This course will save you time and give you tips on how to better use Gmail and be more productive with your emails.

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.

Dynamic Quiz App Using Google Sheets as Source Google Script

Create Web Apps with Java Script & Google Script

This course will help you build your own Dynamic and interactive quiz that uses only Google Sheet data to output the contents of the quiz, and JavaScript on your web page or website. You will be amazed at what you can do with just a few lines of code and how easy it is to connect Google Sheets to your website. This is a great solution to avoid backend code using only Google Script which is essentially JavaScript with a bunch of methods in the cloud.

Build a quiz application from scratch that uses Google Sheets as the data source

Add data from input form to Google Spreadsheet

"This course covers the skills needed to work with Google Suite products particularly Google Sheets. Laurence is clear with all of his explanations and is very responsive to all questions you may have." – Guillermo Ithier

Providing Web development courses and digital marketing strategy courses since 2002. Laurence Svekis is an innovative technology expert with a wide range of real-world experience providing smart digital solutions online for both small and enterprise level businesses.