Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2020-11-30 17:48:06
30-Day Money-Back Guarantee

This course includes:

  • 22.5 hours on-demand video
  • 103 articles
  • 23 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Development Programming Languages Google Apps

Google Apps Script Complete Course Beginner to Advanced

Learn to power up your Google Suite of products using Apps Script to connect - automate - add advanced functionality
Bestseller
Rating: 4.5 out of 54.5 (1,779 ratings)
10,853 students
Created by Laurence Svekis
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Create custom functions within G Suite Apps Docs Sheets Slides Gmail Drive and more
  • Create Google Script to power Google Apps
  • Use Google Script to to add functionality automation and more to Google Docs Sheets plus
Curated for the Udemy for Business collection

Course content

17 sections • 308 lectures • 23h 33m total length

  • Preview06:23
  • New IDE editor added for Google Apps Script
    00:20
  • Preview04:14
  • Apps Script Power Example
    07:00
  • Source Code
    00:07
  • IDE Integrated Development Environment
    10:44
  • First Script using online IDE and Google Script
    08:43
  • Google Script Classes
    13:09
  • Apps Script Resources
    00:11
  • JavaScript Introduction
    12:59
  • Source Code
    00:09

  • Explore Document - Class DocumentApp
    05:18
  • DocumentApp Class overview
    00:19
  • Preview04:39
  • Preview03:51
  • Source Code 7 Class DocumentApp
    00:13
  • Preview06:54
  • Preview05:37
  • Source Code 10
    00:33
  • Document Classes and Methods
    08:07
  • Source Code 11
    00:41
  • Simple Copy Doc Script
    12:47
  • Source Code 12
    00:09
  • Preview06:38
  • Base Values within Script
    08:17
  • Preview06:12
  • Bound Content Interaction
    07:21
  • Ranged elements in Document
    06:02
  • Preview03:25
  • Source Code 18
    00:47
  • Search Content Replace With
    08:14
  • Find Content Update Attributes
    08:47
  • Content Selection Exercise
    14:45
  • Source Code 21
    00:35
  • DocumentApp Exercise
    15:12
  • Source Code 22
    00:47
  • DocumentApp Create Content
    17:02
  • insert Image DocumentApp
    05:32
  • DocumentApp Template Exercise
    04:13
  • Source Code 25
    01:19

  • StandAlone SpreadSheetApp
    03:04
  • Google SpreadSheetApp Methods CheatSheet
    00:57
  • Creating Content and Styling.
    07:16
  • Updated Lessons Set Values and Get Values
    04:27
  • Source Code for Updates
    00:18
  • Spreadsheet data to Doc Table
    07:19
  • Spreadsheet data dynamic
    04:10
  • SpreadSheet Tracker Exercise
    07:07
  • SpreadSheet Sheet Class
    06:09
  • From one sheet to another
    10:47
  • Source Code 33
    00:49
  • Bound Spreadsheet App
    03:18
  • Google Sheets Functions
    05:10
  • Source Code
    00:03
  • UI menu options Spreadsheet
    03:42
  • Spreadsheet UI Sidebar Modal
    05:44
  • Get Selected Content
    07:31
  • Exercise Cell Selection Add to Sheet
    08:26
  • Range to Another Sheet CopyTo
    04:55
  • Selecting Cell Values Loops
    13:30
  • Source Code
    00:38
  • Sidebar content HTML
    07:57
  • Script More UI options
    04:18
  • HTML to backend GS code.
    07:52
  • Google Sheet content to Client Side
    08:39
  • Source Code
    00:30
  • Triggers OnEdit OnChange
    03:20
  • Source
    00:36
  • Exercise Google SpreadsheetApp.
    05:29
  • Exercise Generate Random Content
    10:09
  • Adding new Column
    06:36
  • Add Formulas Set Colors
    07:04
  • HTML modal to Spreadsheet
    03:46
  • Sheet Data to HTML file
    07:51
  • Source Code
    00:28
  • Get Sheet Data
    07:18
  • Run Script Client Side
    07:01
  • Response with Google Sheet Data
    09:52
  • Source Code HTML index file
    00:25
  • Source Code GS
    00:38

  • Introduction to Google Sites
    08:41
  • New Google Sites
    07:41
  • Publish Web App Google Script
    08:12
  • Google Site Scripting
    05:45
  • Source Code
    00:08
  • Google Script Web App html page
    04:39

  • Google DriveApp Class
    03:49
  • Select Folder By ID
    02:57
  • Create Folder DriveApp
    07:13
  • DriveApp create File
    04:20
  • SpreadSheet with DriveApp Data
    09:53
  • Source Code
    00:20
  • Create Doc and Move it
    07:21
  • Source Code
    00:06
  • DriveApp Search
    09:38
  • DriveApp Search Files
    02:44
  • Source Code
    00:24
  • DriveApp searchFolders Params
    01:11
  • Add editors and Delete
    12:52
  • Source Code
    01:08
  • Redirect on search string
    10:03
  • Exercise WebApp Redirector
    07:10
  • Source Code
    00:21

  • Introduction to Class GmailApp
    02:35
  • Make Draft GmailApp
    04:46
  • View your Draft Email
    05:11
  • Use HTML Template email
    05:58
  • Send out a bunch of Emails
    11:10
  • Source Code
    00:31
  • Chat Threads GmailApp
    03:34
  • Get Gmail Messages
    12:26
  • Source Code
    00:42

  • Calendar App Service
    03:44
  • Add Location Info Calendar App
    04:46
  • Calendar Event with options
    05:33
  • Full Day events Calendar App
    05:43
  • Calendar App Event Series
    07:04
  • Calendar App Date Time
    03:23
  • Easy way to enter Events
    03:19
  • More Calendars
    04:03
  • Calendar Settings
    04:42
  • Get All Calendars
    05:25
  • Calendars By Name
    05:49
  • Source Code
    01:22
  • Calendar Events
    02:52
  • Calendar Events Explored
    05:05
  • Calendar Events into spreadsheet
    07:59
  • Google Calendar Events Invites No
    07:43
  • Source Code
    01:49
  • Send Weekly Calendar Events
    18:52
  • Source Code
    00:20
  • Review Google Script
    03:03

  • Apps Script Image Uploader project intro
    02:03
  • New Updates 2020
    00:48
  • HTML Content Service
    07:16
  • HTML Content Template File
    03:50
  • HTML Content from File
    08:47
  • Create the HTML form
    04:44
  • Send Data to Google Script Backend
    07:37
  • Send Image to Google Script
    06:23
  • Image upload Tweaks
    02:36
  • Spreadsheet App tracking uploads
    04:34
  • Send Email notification
    02:55
  • Final Application Image Uploader
    05:50
  • Project Source Code
    01:27

  • Setup Google Form
    06:36
  • Spreadsheet Bound Script
    03:44
  • Google Script Setup Project triggers
    05:02
  • Setup Email to Send
    04:14
  • MailApp Send Email
    04:15
  • Email HTML template
    05:58
  • HTML Service replace content
    03:31
  • Source Code
    00:19
  • HTML to PDF and Attach it
    05:16
  • Send automatic emails
    05:26
  • iterate Sheet Data Send Emails
    06:46
  • Review and update code for project
    05:57
  • Project Source Code
    00:21

  • Contact Form Setup
    05:12
  • Source code
    00:18
  • Create Spreadsheet and setup
    08:35
  • Sending an Email with Apps Script.
    05:33
  • Google Script send email
    00:03
  • Spreadsheet App add content
    07:11
  • Test Sheet Google Script
    00:06
  • Create Web App
    05:41
  • Google Script Trigger Examples
    00:04
  • Get Data Parameters
    03:33
  • JavaScript Fetch
    06:09
  • Outdate HTML in Submit
    02:05
  • Source Code
    00:31
  • Google Script Application
    07:24
  • Source Code Google Script Post
    00:16
  • Send email on submit
    03:08
  • Random ID function and Date Add
    03:24
  • Google Script doPost doGet Source Code
    00:48
  • Email template
    06:26
  • Source Code Google Script
    00:48
  • Create Web App
    05:29
  • Source Code
    00:49
  • App Wrap Up and Review
    02:48
  • Final Project Source Code
    01:01

Requirements

  • JavaScript and basic HTML and CSS knowledge
  • Internet Access
  • Google Account
  • Basic Web development understanding
  • JavaScript knowledge is REQUIRED

Description

Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, Sheets, and Slides. Apps Script lets you do more with Google. All on a JavaScript platform in the cloud.G Suite Services.

Course content 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.  Perfect for students of all levels, with a step by step approach for anyone who has not used Google Script Before.

Apps Script allow you to power up your favorite Google apps and do more with them, way more.

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!!!

Just like JavaScript apps script is easy to write, uses the same structure as JavaScript and core fundamental functionality.   If you know JavaScript you can get started with apps script in minutes.  Functions, variables, loops, and more the same syntax as JavaScript.   With the added power of Google Classes you can connect data from your Google Apps and build on it.  Its the easy way to power up your applications.

Course will cover 

  • Standalone script

  • IDE editor

  • Quick demo to setup and get started with.

Document - DocumentApp

  • Get document

  • Document body

  • Get elements within body

  • Create docs on the fly

  • Document UI for alerts and responses.  Interact with users.

  • Selection of data and construction of content

  • Styling your doc content

Spreadsheet - SpreadsheetApp

  • How to Get spreadsheet data

  • Create spreadsheets and update, create and use the data

  • Get ranges - select sheets and get content

  • Get Sheet data and iterate through it to output it

  • Write to spreadsheet using script

  • Spreadsheet UI for added interactions with users

  • Update sheet with new data

  • Sidebar menu update sheet show sheet data and more

Google Sites - Standalone scripts

  • Sites class and how to use them

  • Sites dashboard navigation and use

  • Design sites interface with options to create pages and more

  • Add scripts to sites to create data driven and interactive pages

  • Output and setup sites content quickly and easily

Google Drive - DriveApp Class

  • Get drive data and use it

  • Setup files create new files

  • Move files from one folder to another

  • Get folder contents and list it

  • Create files copy files and update files

  • Search drive files and folders

  • Get permissions and set permissions

  • List files from folders in Google Sheet show permissions update permissions

Calendar Calendar - CalendarApp Class

  • Create events

  • Get event details

  • Update color style

  • Output events to Google Sheet

  • Using Calendar events checking availability and more

Gmail - GmailApp Class

  • Send message

  • Get inbox contents from folder

  • Create labels and move files

  • Get counts of emails and content

  • Mark Emails as read 

  • Track emails and use the content 

  • Search emails

  • Star Messages

Step by step training lessons

This course covers everything you need to learn about Google Apps Script, including practice exercises, loads of examples, source code and step by step training.  Along with friendly support in the Q&A to help you learn and answer any questions you may have.

Try it now you have nothing to lose, comes with a 30 day money back guarantee.  

Taught by a knowledge instructor with many years of web development experience, ready to help you learn.

Join now and create your own Google Scripts Apps see what is possible.


Who this course is for:

  • Anyone who wants to create amazing things using Google Scripts
  • JavaScript developers who want to empower Google suite of products
  • Web developers who want to incorporate Google Script functionality
  • Application developers who want to access the power of Google G Suite
  • App Script Google Script developers

Instructor

Laurence Svekis
Instructor, GDE, Application Developer
Laurence Svekis
  • 4.3 Instructor Rating
  • 41,864 Reviews
  • 707,389 Students
  • 369 Courses

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!"

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.