Google Apps Google Script - Content System Web App Project
- Descrição
- Currículo
- FAQ
- Revisões
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.
-
1Introduction to Creating webapps with Google ScriptVídeo Aula
-
2What is Google ScriptsVídeo Aula
-
3Setup Google account open script editorVídeo Aula
-
4How to Create a Google Doc with Google ScriptVídeo Aula
-
5Access existing document and add content Google ScriptVídeo Aula
-
6Setup Triggers Run script using Google ScriptVídeo Aula
-
7Run method to copy current content and output as bold Google Script DocVídeo Aula
-
8Change text attributes output different colors Google ScriptsVídeo Aula
-
9Link more google services into your Script Use JavaScript MethodsVídeo Aula
-
10Google Scripts Send EmailVídeo Aula
-
11Google Script Source Code ExamplesTexto
-
12Google Script ResourcesTexto
-
13Use Google Sheets as a webapp with DataVídeo Aula
-
14Google Sheet data into local application jQueryVídeo Aula
-
15Source Code accessing Google SheetTexto
-
16OnOpen Setup default buttons Google ScriptVídeo Aula
-
17Get Sheet values into objectVídeo Aula
-
18Output data from spreadsheetVídeo Aula
-
19Source Code output as HTMLTexto
-
20Popup HTML file within Google SheetVídeo Aula
-
21Pass data Object to HTML page Google ScriptVídeo Aula
-
22Pass Sheet data as object array into HTML page Google ScriptVídeo Aula
-
23output content from sheet get each valueVídeo Aula
-
24Source CodeTexto
-
25Deploy as Web AppVídeo Aula
-
26Source Code GSTexto
-
27Source Code Index.htmlTexto
-
28Custom portal setup Google ScriptsVídeo Aula
-
29Create Alert with prompt response shown in sidemenuVídeo Aula
-
30Source Code Sidemenu responseTexto
-
31Setup testing popup modal with content Google ScriptVídeo Aula
-
32Setup user portal entry pageVídeo Aula
-
33Dynamic Drop down content from Google SheetVídeo Aula
-
34Pass Google Sheet data to Frontend Google ScriptVídeo Aula
-
35Generate home page content from google sheet dataVídeo Aula
-
36Send data to Google Script for processingVídeo Aula
-
37Generate Page Content Google SheetVídeo Aula
-
38Project Source Code Google ScriptTexto
-
39Project Source Code index.htmlTexto
-
40Callback webpage builderVídeo Aula
-
41Bug Fix and Tweak output pagesVídeo Aula
-
42Return row contents using Google ScriptVídeo Aula
-
43Add in validation check for email addressesVídeo Aula
-
44Tweaks and Bug Fixes Google ScriptVídeo Aula
-
45Deploy as webapp Google Script ApplicationVídeo Aula
-
46Code review Index.htmlVídeo Aula
-
47Index Source CodeTexto
-
48Code Review Code Google ScriptVídeo Aula
-
49Source Code Code.gs Google ScriptTexto
