Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Development
Programming Languages
Google Apps Script
Google Apps Google Script - Content System Web App Project

Google Apps Google Script - Content System Web App Project

Loại khoá học: Programming Languages

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

image
50.000 VND
829.000 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

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.

Please note that this is a project based course and the scope of the course is to use technologies like HTML, CSS, JavaScript, jQuery, Bootstrap to create the project.  All of the source code is included.

Bạn sẽ học được gì

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

Yêu cầu

  • JavaScript
  • HTML CSS
  • Google Account
  • jQuery
  • Bootstrap

Nội dung khoá học

4 sections

Introduction to Google Script

12 lectures
Introduction to Creating webapps with Google Script
08:51
What is Google Scripts
03:21
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:37
Google Script Resources
00:03

Google Sheets get data with App Script launch web apps

15 lectures
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:15
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:12
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:34
Deploy as Web App
06:02
Source Code GS
00:22
Source Code Index.html
00:20

Portal Gateway Project with Content System using Apps Script

22 lectures
Custom portal setup Google Scripts
03:18
Create Alert with prompt response shown in sidemenu
05:55
Source Code Sidemenu response
00:07
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:26
Project Source Code index.html
00:24
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:33
Code Review Code Google Script
08:30
Source Code Code.gs Google Script
00:59

Bonus Content Sample code and exercises

4 lectures
Google Apps Script Coding Guide and examples Guide
01:05
Resources
00:01
Apps Script how to create a Doc with Code
06:31
reading Data from Sheets
07:33

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Master Network Automation with Python for Network Engineers

Master Network Automation with Python for Network Engineers

1.699.000 VND
50.000 VND
Unity Mobile Game Development - Exterminator

Unity Mobile Game Development - Exterminator

1.499.000 VND
50.000 VND
Mastering CSS Grid 2023 - With 3 cool projects

Mastering CSS Grid 2023 - With 3 cool projects

99 VND
50.000 VND
Django 3 - Full Stack Websites with Python Web Development

Django 3 - Full Stack Websites with Python Web Development

1.699.000 VND
50.000 VND
Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

Appium -Mobile Testing (Android/IOS) from Scratch+Frameworks

95 VND
50.000 VND
Appium - Mobile Testing with Latest 2.0 and Live Projects

Appium - Mobile Testing with Latest 2.0 and Live Projects

70 VND
50.000 VND
Deep Learning for Object Detection with Python and PyTorch

Deep Learning for Object Detection with Python and PyTorch

899.000 VND
50.000 VND
Full Android Development Masterclass | 14 Real Apps-46 Hours

Full Android Development Masterclass | 14 Real Apps-46 Hours

1.699.000 VND
50.000 VND
Go Java Full Stack with Spring Boot and Angular

Go Java Full Stack with Spring Boot and Angular

90 VND
50.000 VND
Machine Learning Practical Workout | 8 Real-World Projects

Machine Learning Practical Workout | 8 Real-World Projects

79 VND
50.000 VND
WordPress 2024: The Complete WordPress Website Course

WordPress 2024: The Complete WordPress Website Course

90 VND
50.000 VND
Android App Development Master Course with Java | Android

Android App Development Master Course with Java | Android

99 VND
50.000 VND
Unreal Engine 5: Soulslike Melee Combat System

Unreal Engine 5: Soulslike Melee Combat System

1.399.000 VND
50.000 VND
ASP.NET Core Web Application Using Razor Pages

ASP.NET Core Web Application Using Razor Pages

1.699.000 VND
50.000 VND
Build Undetectable Malware Using C Language: Ethical Hacking

Build Undetectable Malware Using C Language: Ethical Hacking

75 VND
50.000 VND
Angular - The Complete Guide (2024 Edition)

Angular - The Complete Guide (2024 Edition)

120 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi