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
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • JavaScript
  • HTML CSS
  • Google Account
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.

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
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
+
Bonus Content
1 Lecture 00:01
Resources
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!"