Google Apps Google Script - Content System Web App Project
4.1 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,713 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Google Apps Google Script - Content System Web App Project to your Wishlist.

Add to Wishlist

Google Apps Google Script - Content System Web App Project

Learn to Build a custom web application using Google Scripts connecting Google Apps together
4.1 (15 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,713 students enrolled
Created by Laurence Svekis
Last updated 7/2017
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
  • 4 hours on-demand video
  • 13 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • JavaScript
  • Google Account

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.

Who is the target audience?
  • JavaScript application developers
  • Anyone who wants to do more with Google Apps
  • Anyone who wants to learn more about connecting Google Apps together
Students Who Viewed This Course Also Viewed
Curriculum For This Course
50 Lectures
Introduction to Google Script
12 Lectures 01:04:51

Setup Google account open script editor

How to Create a Google Doc with Google Script

Access existing document and add content Google Script

Setup Triggers Run script using Google Script

Run method to copy current content and output as bold Google Script Doc

Change text attributes output different colors Google Scripts

Link more google services into your Script Use JavaScript Methods

Google Scripts Send Email

Google Script Source Code Examples

Google Script Resources
Google Sheets get data with App Script launch web apps
15 Lectures 01:02:27
Use Google Sheets as a webapp with Data

Google Sheet data into local application jQuery

Source Code accessing Google Sheet

OnOpen Setup default buttons Google Script

Get Sheet values into object

Output data from spreadsheet

Source Code output as HTML

Popup HTML file within Google Sheet

Pass data Object to HTML page Google Script

Pass Sheet data as object array into HTML page Google Script

output content from sheet get each value

Source Code

Deploy as Web App

Source Code GS

Source Code Index.html
Portal Gateway Project with Content System using Apps Script
22 Lectures 02:07:22
Custom portal setup Google Scripts

Create Alert with prompt response shown in sidemenu

Source Code Sidemenu response

Setup testing popup modal with content Google Script

Setup user portal entry page

Dynamic Drop down content from Google Sheet

Pass Google Sheet data to Frontend Google Script

Generate home page content from google sheet data

Send data to Google Script for processing

Generate Page Content Google Sheet

Project Source Code Google Script

Project Source Code index.html

Callback webpage builder

Bug Fix and Tweak output pages

Return row contents using Google Script

Add in validation check for email addresses

Tweaks and Bug Fixes Google Script

Deploy as webapp Google Script Application

Code review Index.html

Index Source Code

Code Review Code Google Script

Source Code Google Script
Bonus Content
1 Lecture 00:01
About the Instructor
Laurence Svekis
4.2 Average rating
13,244 Reviews
297,688 Students
185 Courses
Instructor, 18+yrs Web Experience

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today

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