Taking Advantage of Google Apps Script

Kanshi Tanaike

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Lessons (1h 4m)
    • 1. Introduction

      5:18
    • 2. Basic Level : Google Apps Script

      2:32
    • 3. Basic Level : Script Editor

      3:12
    • 4. Basic Level : Authorization and Libraries

      2:28
    • 5. Basic Level : Use API

      1:54
    • 6. Basic Level : Manifests and Debug

      2:43
    • 7. Intermediate Level 1: How to Use Google Docs

      5:12
    • 8. Intermediate Level 1: Put values to Google Docs

      2:25
    • 9. Intermediate Level 1: Sample situations of Spreadsheet

      5:02
    • 10. Intermediate Level 1: Sample situations of Document and Slides

      6:08
    • 11. Intermediate Level 1: Process Costs

      3:29
    • 12. Intermediate Level 2: How to use files in Google Drive

      3:53
    • 13. Intermediate Level 2: Move folder and Search files

      3:04
    • 14. Intermediate Level 3: How to use Web Apps

      6:00
    • 15. Advanced Level: File uploader to Google Drive

      3:51
    • 16. Advanced Level: File downloader from Google Drive

      3:04
    • 17. Advanced Level: Original APIs

      4:11

About This Class

  • What the class is about and a few of the skills students will learn
    - Users can learn about how to use Google Apps Script as follows.
    - Basic level: How to use script editor for using Google Apps Script, use libraries, APIs and Manifests.
    - Intermediate level 1: How to use Google Docs (Spreadsheet, Document and Slides) using Google Apps Script.
    - Intermediate level 2: How to use files in Google Drive using Google Apps Script.
    - Intermediate level 3: How to use Web Apps using Google Apps Script.
    - Advanced level: Create actual applications.
  • What students will create in their class project
    - Management of Google Docs using dialog and template file.
    - Library.
    - Add-on.
    - File uploader to Google Drive.
    - File downloader from Google Drive.
    - Original APIs.
    I will teach some of them.
  • Who the class is geared toward or if any prior knowledge or experience is required
    - In this class, any prior knowledge or experience is not required, because users can learn the basic usage at Basic level and Intermediate level. And also users can learn how to create some actual applications at Advanced level.

About the scripts used in this presentation, you can download the scripts from my Gists.

2259d43a