All in One Offer! | Access Unlimited Courses in any category starting at just $29. Signup today. Offer Ends in: 5 Days!

Browse Library

Google Apps Google Script - Content System Web App Project

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

Instructed by Laurence Svekis

5 days left at this price!
Get Unlimited Courses Access $29
It Includes
  • Get Full Access to the platform
  • Access to 16000+ online courses
  • High Quality Recorded Lectures
  • Learn Online from Mobile/PC/Tablet
  • Assignments & Projects
  • Online iLab Access
  • Certificate of Completion
  • Download for offline viewing
  • Free Instructor Support
  • Access valid for 1 user only
  • Cancel Anytime
  • 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

Google Apps Google Script - Content System Web App Project
Learn to Build a custom web application using Google Scripts connecting Google Apps together
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.

  • JavaScript
  • Google Account
  • jQuery
  • Bootstrap
  • JavaScript application developers
  • Anyone who wants to do more with Google Apps
  • Anyone who wants to learn more about connecting Google Apps together
View More...

Section 1 : Introduction to Google Script

  • Lecture 1 :
  • Google Scripts Introduction Preview
  • Lecture 2 :
  • What is Google Scripts
  • Lecture 3 :
  • Setup Google account open script editor
  • Lecture 4 :
  • How to Create a Google Doc with Google Script
  • Lecture 5 :
  • Access existing document and add content Google Script
  • Lecture 6 :
  • Setup Triggers Run script using Google Script
  • Lecture 7 :
  • Run method to copy current content and output as bold Google Script Doc
  • Lecture 8 :
  • Change text attributes output different colors Google Scripts
  • Lecture 9 :
  • Link more google services into your Script + Use JavaScript Methods
  • Lecture 10 :
  • Google Scripts Send Email
  • Lecture 11 :
  • Google Script Source Code
  • Lecture 12 :
  • Google Script Resources

Section 2 : Google Sheets get data with App Script launch web apps

  • Lecture 1 :
  • Use Google Sheets as a webapp with Data
  • Lecture 2 :
  • Google Sheet data into local application jQuery
  • Lecture 3 :
  • Source Code accessing Google Sheet
  • Lecture 4 :
  • OnOpen Setup default buttons Google Script
  • Lecture 5 :
  • Get Sheet values into object
  • Lecture 6 :
  • Output data from spreadsheet
  • Lecture 7 :
  • Source Code output as HTML
  • Lecture 8 :
  • Popup HTML file within Google Sheet
  • Lecture 9 :
  • Pass data Object to HTML page Google Script
  • Lecture 10 :
  • Pass Sheet data as object array into HTML page Google Script
  • Lecture 11 :
  • output content from sheet get each value
  • Lecture 12 :
  • Source Code
  • Lecture 13 :
  • Deploy as Web App
  • Lecture 14 :
  • GS source Code
  • Lecture 15 :
  • HTML Source Code

Section 3 : Portal Gateway Project with Content System using Apps Script

  • Lecture 1 :
  • Custom portal setup Google Scripts
  • Lecture 2 :
  • Create Alert with prompt response shown in sidemenu
  • Lecture 3 :
  • Source Code Sidemenu
  • Lecture 4 :
  • Setup testing popup modal with content Google Script
  • Lecture 5 :
  • Setup user portal entry page
  • Lecture 6 :
  • Dynamic Drop down content from Google Sheet
  • Lecture 7 :
  • Pass Google Sheet data to Frontend Google Script
  • Lecture 8 :
  • Generate home page content from google sheet data
  • Lecture 9 :
  • Send data to Google Script for processing
  • Lecture 10 :
  • Generate Page Content Google Sheet
  • Lecture 11 :
  • Project Source Code Google Script
  • Lecture 12 :
  • Project Source Code index.html
  • Lecture 13 :
  • Callback webpage builder
  • Lecture 14 :
  • Bug Fix and Tweak output pages
  • Lecture 15 :
  • Return row contents using Google Script
  • Lecture 16 :
  • Add in validation check for email addresses
  • Lecture 17 :
  • Tweaks and Bug Fixes Google Script
  • Lecture 18 :
  • Deploy as webapp Google Script Application
  • Lecture 19 :
  • Code review Index
  • Lecture 20 :
  • Index Source Code
  • Lecture 21 :
  • Code Review Code Google Script
  • Lecture 22 :
  • Source Code GS

Section 4 : Bonus Content

  • Lecture 1 :
  • Resources
  • How do i access the course after purchase?

    Once you purchase a course (Single course or Subscription), you will be able to access the courses instantly online by logging into your account. Use the user name & password that you created while signing up. Once logged in, you can go to the "My Courses" section to access your course.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certification after completing the course?

    Yes. Once you succesfully complete any course on Learnfly marketplace, you get a certiifcate of course completion emailed to you within 24 hours with your name & the Learnfly badge. You can definately brag about it & share it on your social media or with friends as one of your achievement. Click here to view the sample certificate Click Here
  • For how long can i access my course after the purchase?

    If you buy a single course, that course is accessible to you for a lifetime. If you go for a premium subcription, you can access all the courses on Learnfly marketplace till your subscription is Active.
  • Whats the difference between Single Course Purchase & Go Premium option?

    With Single Course Purchase, you only get an access of one single course. Whereas, with premium monhtly or annual subscription, you can access all the existing or new courses on learnfly marketplace. You can decide what option suits you the best and accordingly you can make your purchase.
  • Is there any free trial?

    Currently, we don't have any free trial but it may be available in near future.
  • What is the refund policy?

    We would hate you to leave us. However, if you are not satisfied, you can ask for a full refund within 30 days & we will be happy to assist you further.

Laurence Svekis,

Instructor, 18+yrs Web Experience I'm here to help you learn, achieve your dreams, come join me on this amazing adventure today Providing Web development courses and digital marketing strategy courses since 2002. 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 tobring 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!"
View More...

The Extreme Web Development Course

By : Paul Carlo Tordecilla

Lecture 124


Develop your own Chrome Extension &...

By : Harshit Srivastava

Lecture 15


The Ultimate Codeigniter 3 Course

By : Paul Carlo Tordecilla

Lecture 23


Superb Advance Javascript - Become ...

By : Paul Carlo Tordecilla

Lecture 28


Application development with IBM Wa...

By : Harshit Srivastava

Lecture 14


Learn React 16 and Redux by buildin...

By : Haider Malik

Lecture 74

Sign up and start learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password Request
Enter your email address and we'll send you a link to reset your password.