O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Google Apps Script Complete Course - Beginner to Advanced

Video Description

Learn to power up your Google Suite products using Apps Script to connect, automate, and add advanced functionality

About This Video

  • Power up your Google suite of products using Apps Script.
  • Use Google Script to add functionality, automation, and more to Google Docs Sheets

In Detail

This course will take you on a journey where you'll learn to power up your Google Suite products using Apps Script to connect, automate, and add advanced functionality. Apps Script allows 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 email, generate reports, use data more effectively—the list of amazing things you can do with Google Apps Script is endless. Just like JavaScript, Apps Scripts are easy to write and use the same structure and core fundamental functionality as JavaScript. If you know JavaScript, you can get started with Apps Script in minutes. Functions, variables, loops, and more use the same syntax as JavaScript. With the added power of Google Classes, you can connect data from your Google apps and build on it. It's the easy way to power up your applications.

Table of Contents

  1. Chapter 1 : Introduction to using Google Script
    1. Introduction to Google Script 00:06:24
    2. Quick Start to Google Apps Script 00:04:15
    3. Apps Script Power Example 00:07:00
    4. IDE Integrated Development Environment 00:10:45
    5. First Script using online IDE and Google Script 00:08:43
    6. Google Script Classes 00:13:09
    7. JavaScript Introduction 00:12:59
  2. Chapter 2 : Google DocumentApp
    1. Explore Document - Class DocumentApp 00:05:18
    2. Get Document Contents 00:04:39
    3. Document Body Contents 00:03:52
    4. Document Body Updates 00:06:55
    5. Document Body Children 00:05:37
    6. Document Classes and Methods 00:08:08
    7. Simple Copy Doc Script 00:12:48
    8. DocumentApp Bound Script 00:06:39
    9. Base Values within Script 00:08:17
    10. HTML in Google Documents 00:06:12
    11. Bound Content Interaction 00:07:22
    12. Ranged elements in Document 00:06:03
    13. Translate Selected Content 00:03:25
    14. Search Content Replace With 00:08:14
    15. Find Content Update Attributes 00:08:48
    16. Content Selection Exercise 00:14:46
    17. DocumentApp Exercise 00:15:13
    18. DocumentApp Create Content 00:17:03
    19. insert Image DocumentApp 00:05:33
    20. DocumentApp Template Exercise 00:04:14
  3. Chapter 3 : Google Spreadsheet app
    1. StandAlone SpreadSheetApp 00:03:04
    2. Creating Content and Styling. 00:07:17
    3. Spreadsheet data to Doc Table 00:07:19
    4. Spreadsheet data dynamic 00:04:10
    5. SpreadSheet Tracker Exercise 00:07:08
    6. SpreadSheet Sheet Class 00:06:09
    7. From one sheet to another 00:10:47
    8. Bound Spreadsheet App 00:03:18
    9. Google Sheets Functions 00:05:10
    10. UI menu options Spreadsheet 00:03:43
    11. Spreadsheet UI Sidebar Modal 00:05:45
    12. Get Selected Content 00:07:31
    13. Exercise Cell Selection Add to Sheet 00:08:26
    14. Range to Another Sheet CopyTo 00:04:56
    15. Selecting Cell Values Loops 00:13:28
    16. Sidebar content HTML 00:07:58
    17. Script More UI options 00:04:18
    18. HTML to backend GS code 00:07:52
    19. Google Sheet content to Client Side 00:08:39
    20. Triggers OnEdit OnChange 00:03:21
    21. Exercise Google SpreadsheetApp. 00:05:30
    22. Exercise Generate Random Content 00:10:10
    23. Adding new Column 00:06:36
    24. Add Formulas Set Colors 00:07:05
    25. HTML modal to Spreadsheet 00:03:46
    26. Sheet Data to HTML file 00:07:51
    27. Get Sheet Data 00:07:19
    28. Run Script Client Side 00:07:01
    29. Response with Google Sheet Data 00:09:53
  4. Chapter 4 : Google Script Sites
    1. Introduction to Google Sites 00:08:42
    2. New Google Sites 00:07:41
    3. Publish Web App Google Script 00:08:13
    4. Google Site Scripting 00:05:45
    5. Google Script Web App html page 00:04:40
  5. Chapter 5 : Google Drive - DriveApp Class
    1. Google DriveApp Class 00:03:49
    2. Select Folder By ID 00:02:58
    3. Create Folder DriveApp 00:07:13
    4. DriveApp create File 00:04:20
    5. SpreadSheet with DriveApp Data 00:09:53
    6. Create Doc and Move it 00:07:22
    7. DriveApp Search 00:09:39
    8. DriveApp Search Files 00:02:44
    9. Google DriveApp searchFolders Params 00:01:12
    10. Add editors and Delete 00:12:53
    11. Redirect on search string 00:10:03
    12. Exercise WebApp Redirector 00:07:11
  6. Chapter 6 : Google GmailApp
    1. Introduction to Class GmailApp 00:02:36
    2. Make Draft GmailApp 00:04:47
    3. View your Draft Email 00:05:11
    4. Use HTML Template email 00:05:58
    5. Send out a bunch of Emails 00:11:11
    6. Chat Threads GmailApp 00:03:34
    7. Get Gmail Messages 00:12:27
  7. Chapter 7 : Calendar App Class
    1. Calendar App Service 00:03:44
    2. Add Location Info Calendar App 00:04:47
    3. Calendar Event with options 00:05:33
    4. Full Day events Calendar App 00:05:43
    5. Calendar App Event Series 00:07:04
    6. Calendar App Date Time 00:03:23
    7. Easy way to enter Events 00:03:19
    8. More Calendars 00:04:03
    9. Calendar Settings 00:04:42
    10. Get All Calendars 00:05:26
    11. Calendars By Name 00:05:49
    12. Calendar Events 00:02:53
    13. Calendar Events Explored 00:05:06
    14. Calendar Events into spreadsheet 00:07:59
    15. Google Calendar Events Invites No 00:07:44
    16. Send Weekly Calendar Events 00:18:52
    17. Review Google Script 00:03:04
  8. Chapter 8 : Exercise Google Script Image Uploader Project
    1. Apps Script Image Uploader project intro 00:02:03
    2. HTML Content Service 00:07:16
    3. HTML Content Template File 00:03:50
    4. HTML Content from File 00:08:47
    5. Create the HTML form 00:04:44
    6. Send Data to Google Script Backend 00:07:38
    7. Send Image to Google Script 00:06:24
    8. Image upload Tweaks 00:02:36
    9. Spreadsheet App tracking uploads 00:04:34
    10. Send Email notification 00:02:56
    11. Final Application Image Uploader 00:05:50
  9. Chapter 9 : Form auto Email responder
    1. Setup Google Form 00:06:37
    2. Spreadsheet Bound Script 00:03:45
    3. Google Script Setup Project triggers 00:05:03
    4. Setup Email to Send 00:04:14
    5. MailApp Send Email 00:04:16
    6. Email HTML template 00:05:58
    7. HTML Service replace content 00:03:32
    8. HTML to PDF and Attach it 00:05:16
    9. Send automatic emails 00:05:27
    10. iterate Sheet Data Send Emails 00:06:47
    11. Review and update code for project 00:05:57