Google Apps Script Web App Project Course

Google Apps Google Script - Content System Web App Project

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

Created by : Rated :4.3 96582 views

Last Updated: 2024-11-19 07:11:25 English Course Type: Self Learning

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
HTML CSS
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

Section 1 : Introduction to Google Script 12 Lectures 01:04:03
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 15 Lectures 01:00:10
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 22 Lectures 02:04:06
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 1 Lectures
Lecture 1 :
Resources

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
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 certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Laurence Svekis,

684034 Course Views

20 Courses

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