Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with G Suite
Script Project
...Your Codes...
Interaction
Standalone
Bound script
Web Apps
function doGet(e) {
var params = JSON.stringify(e);
return HtmlService.createHtmlOutput(params);
}
return
or
依附於某個G-Suite app instance之下的script
要開發成add-on的script必須是standalone
G-Suite add-on
Editor add-on
Install
Authorize
Use or manage them
Extend Apps
v.s.
Editor add-ons extend one of the Google Drive editor applications.
UI creation
An Apps Script project manifest is a special JSON file that specifies a basic project information that Apps Script needs to run the script successfully.
package.json的概念
Example
This service provides utilities for string encoding/decoding, date formatting
This service allows scripts to access other resources on the web by fetching URLs.
A script can use the UrlFetch service to issue HTTP and HTTPS requests and receive responses.
Return class HTTPResponse
This service allows scripts to connect to JDBC-compliant databases
This service allows users to create charts using Google chart tools and render them server side.
This service provides access to script triggers and script publishing
提供各種控制event trigger的methods
如:Clock-trigger、各種editor-apps trigger builder
也可以處理cache!
Logger interface & UI 操作
Create custom features like menus, dialogs, and sidebars
clasp lets you to develop your Apps Script projects locally. You can write code on your own computer and upload it to Apps Script when you're done.
clasp can help transpiling the files from .ts to .gs