Google Apps Google Script - Content System Web App Project
3.8 (77 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,588 students enrolled

Google Apps Google Script - Content System Web App Project

Learn to Build a custom web application using Google Scripts connecting Google Apps together
3.8 (77 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,588 students enrolled
Created by Laurence Svekis
Last updated 7/2017
English
English [Auto-generated]
Current price: $11.99 Original price: $199.99 Discount: 94% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 13 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create Google Docs with script
  • Send gmail emails with Google Script

  • Translate Google docs to different languages

  • Use Google sheets to store data and access data
  • Create web apps using Google Script
Course content
Expand all 50 lectures 04:12:40
+ Introduction to Google Script
12 lectures 01:04:51
Setup Google account open script editor
03:36
How to Create a Google Doc with Google Script
09:28
Access existing document and add content Google Script
05:47
Setup Triggers Run script using Google Script
03:55
Run method to copy current content and output as bold Google Script Doc
08:29
Change text attributes output different colors Google Scripts
07:38
Link more google services into your Script Use JavaScript Methods
04:42
Google Scripts Send Email
08:06
Google Script Source Code Examples
00:54
Google Script Resources
00:03
+ Google Sheets get data with App Script launch web apps
15 lectures 01:02:27
Use Google Sheets as a webapp with Data
03:43
Google Sheet data into local application jQuery
10:42
Source Code accessing Google Sheet
00:19
OnOpen Setup default buttons Google Script
04:55
Get Sheet values into object
06:34
Output data from spreadsheet
04:02
Source Code output as HTML
00:19
Popup HTML file within Google Sheet
04:31
Pass data Object to HTML page Google Script
08:58
Pass Sheet data as object array into HTML page Google Script
05:27
output content from sheet get each value
05:06
Source Code
00:48
Deploy as Web App
06:02
Source Code GS
00:31
Source Code Index.html
00:29
+ Portal Gateway Project with Content System using Apps Script
22 lectures 02:07:22
Custom portal setup Google Scripts
03:18
Create Alert with prompt response shown in sidemenu
05:55
Source Code Sidemenu response
00:10
Setup testing popup modal with content Google Script
06:49
Setup user portal entry page
09:18
Dynamic Drop down content from Google Sheet
10:10
Pass Google Sheet data to Frontend Google Script
05:39
Generate home page content from google sheet data
06:14
Send data to Google Script for processing
06:02
Generate Page Content Google Sheet
07:29
Project Source Code Google Script
00:38
Project Source Code index.html
00:29
Callback webpage builder
10:44
Bug Fix and Tweak output pages
02:39
Return row contents using Google Script
08:20
Add in validation check for email addresses
09:34
Tweaks and Bug Fixes Google Script
08:53
Deploy as webapp Google Script Application
08:58
Code review Index.html
05:18
Index Source Code
00:43
Code Review Code Google Script
08:30
Source Code Code.gs Google Script
01:30
Requirements
  • JavaScript
  • HTML CSS
  • Google Account
  • jQuery
  • Bootstrap
Description

Learn how to build Web Apps with Google Script

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 application together.   Automate your work you will be amazed at how easy it is to work with Apps Script. 

JavaScript is a prerequisite to this course!

Course Lessons will demonstrate how to use Google Script

  • Learn what Google script is and how to write code with it

  • Create a Google Doc with one line of code 

  • Update existing Google Docs 

  • Setup up automation with Triggers 

  • Copy content from your Google Doc 

  • Change colors and text within your Google Doc 

  • Link to other Google apps 

  • Translate your Google Doc in One line of Code! 

  • Send your Google Doc info as an email through Gmail

Building a Webap

  • Connecting your Google Sheet Data

  • Accessing Sheet data via a JSON feed

  • Connecting your Sheet data to a local application using AJAX

  • How to add Bootstrap and jQuery into your Google App

  • How to create popup modals and dynamic interaction

  • Deploy your first web app

Build a Custom Content System driven from Google Sheet data

  • Add Alerts and interactive dialog

  • Setup HTML page

  • Add Bootstrap 4 and jQuery to your app

  • Create a dynamic drop list from Google Sheets

  • Generate a home page of content from Sheets

  • Send data back to GS to callback

  • Generate HTML output from Google Sheets data

  • Provide Access control of content

  • How to bug fix and tweak your application

  • Get a web url for your application

  • Check and authenticate users

  • Output content from Google Sheet data

  • Code review and output

Taught by an instructor with over 18 years of web development experience.  I'm here to help you learn about Google Scripts and ready to answer any questions you might have.

You will be amazed at what you can do with Google Scripts, join now to start creating your own applications today.

Please note that 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.

Who this course is for:
  • JavaScript application developers
  • Anyone who wants to do more with Google Apps
  • Anyone who wants to learn more about connecting Google Apps together