Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
Get Unlimited Learning Access
$29
4 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
4 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Instant access to 11,000+ online courses
- Play & Pause Course Videos
- HD Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Chat Support
- Cancel Plan Anytime
$29
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 Overview
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.
Pre-requisites
- JavaScript
- HTML CSS
- Google Account
- jQuery
- Bootstrap
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
Curriculum 50 Lectures 04:08:19
-
Section 1 : Introduction to Google Script
- 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
Our learners work at
Frequently Asked Questions
-
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?
Instructor
677984 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!"
View More...
