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 and Google Script - A Content System Web App Project

Video Description

Learn to build a custom web application using Google Scripts and connecting Google Apps together

About This Video

  • How to use JavaScript within web applications
  • How to build an application from scratch

In Detail

This course will teach you how to build web apps with Google Script. Apps Script lets you do more with Google–and all on a JavaScript platform in the cloud. You will learn about Google Script and how to write code with it. Various other topics related to Google Script—such as translating Google code into one line of code and changing colors and text within your Google documents—are also covered. Knowledge of JavaScript is a prerequisite to this course.

Table of Contents

  1. Chapter 1 : Introduction to Google Script
    1. Introduction to Creating webapps with Google Script 00:08:51
    2. What is Google Scripts 00:03:21
    3. Setup Google account open script editor 00:03:36
    4. How to Create a Google Doc with Google Script 00:09:28
    5. Access existing document and add content Google Script 00:05:47
    6. Setup Triggers Run script using Google Script 00:03:56
    7. Run method to copy current content and output as bold Google Script Doc 00:08:30
    8. Change text attributes output different colors Google Scripts 00:07:39
    9. Link more google services into your Script Use JavaScript Methods 00:04:43
    10. Google Scripts Send Email 00:08:06
  2. Chapter 2 : Google Sheets get data with App Script launch web apps
    1. Use Google Sheets as a webapp with Data 00:03:43
    2. Google Sheet data into local application jQuery 00:10:43
    3. OnOpen Setup default buttons Google Script 00:04:55
    4. Get Sheet values into object 00:06:34
    5. Output data from spreadsheet 00:04:03
    6. Popup HTML file within Google Sheet 00:04:32
    7. Pass data Object to HTML page Google Script 00:08:59
    8. Pass Sheet data as object array into HTML page Google Script 00:05:27
    9. output content from sheet get each value 00:05:06
    10. Deploy as Web App 00:06:03
  3. Chapter 3 : Portal Gateway Project with Content System using Apps Script
    1. Custom portal setup Google Scripts 00:03:19
    2. Create Alert with prompt response shown in sidemenu 00:05:56
    3. Setup testing popup modal with content Google Script 00:06:50
    4. Setup user portal entry page 00:09:19
    5. Dynamic Drop down content from Google Sheet 00:10:11
    6. Pass Google Sheet data to Frontend Google Script 00:05:40
    7. Generate home page content from google sheet data 00:06:14
    8. Send data to Google Script for processing 00:06:03
    9. Generate Page Content Google Sheet 00:07:29
    10. Callback webpage builder 00:10:45
    11. Bug Fix and Tweak output pages 00:02:39
    12. Return row contents using Google Script 00:08:20
    13. Add in validation check for email addresses 00:09:34
    14. Tweaks and Bug Fixes Google Script 00:08:54
    15. Deploy as webapp Google Script Application 00:08:58
    16. Code review Index.html 00:05:19
    17. Code Review Code Google Script 00:08:30