Group items tagged

run directly on Google servers in order to provide direct access to the products they control.

can also use Google Apps Script from Google Sites

Google Apps Script Template Gallery

Google Apps Script Blog

guide contains the information you need to use Google Apps Script, a server-side scripting language, based on JavaScript, that runs on Google's servers alongside Google Apps

enable varying degrees of interactivity among the applications

easy enough to use that you don't have to be a programmer to create scripts.

use it to automate complex tasks within Google Apps

You don't have to be a programmer to use Google Apps Script

A script is a series of instructions you write in a computer language to accomplish a particular task. You type in the instructions and save them as a script. The script runs only under circumstances you define.

The Google Apps Script API provides a set of objects. You can use these objects and their associates methods to access Google Docs and Spreadsheets, Gmail, Google Finance, and other Google applications.

To run a script, you must first add the script to a Google Spreadsheet or Google Site using the Script Editor.

You can retrieve information from a wide selection of Google Apps and Services and from external sources, including web pages and XML sources. You can use Google Apps Script to create email, spreadsheets, pages on Google Sites, and files in the Google Docs Document List.

The instructions in a script are grouped into functions.

objects

methods

for such tasks

Create pages on a Google Site

Customize a Spreadsheet

Send email based on information in a Spreadsheet

You can manipulate

numeric

financial

string

an XML document

controlling data in the following applications

Spreadsheets

Google Document List

Contacts

Calendar

Sites

Google Maps

create and display interactive user interface elements

interact with relational database management systems

create folders, subfolders, and files in the Google Docs document list

access to user, session, and browser information

access to web services

extract data from XML documents and then manipulate that data

obtain translations of text from one language to another

send email

UrlFetch services

encode and decode strings and format dates

store properties on a per-script and per-user basis

create, delete and update contact information for individuals and for groups in Google Contacts