 Have you
already written some scripts? We would love to get some feedback from you! Take a few minutes to fill in our survey.
|
Welcome to Google Apps Script: an easy way to automate simple tasks across Google Products.
With scripts, you can:
- Create your own custom spreadsheet functions
- Automate repetitive tasks (e.g. process responses to Google Docs forms)
- Link multiple Google products together (e.g. send emails or schedule Calendar events from a list of addresses in a Spreadsheet)
- Customize existing Google products (e.g. add custom buttons or menus to run your own scripts)
Google Apps Script provides:
- Easy interaction with different Google Products and capabilities using JavaScript APIs
- Fast development:
- use standard JavaScript
- use Google's online Web Script Editor or your favorite Desktop development tool
- Basic collaboration and sharing support
- Execution and hosting of scripts on the Google cloud
- Basic support for event handling that can run even when users are offline
- Easy deployment and maintenance
- Standard methods of security using OAuth: users or domain administrators have to grant each script access to the data it needs to run.
Users write scripts in JavaScript using libraries designed to provide a powerful interface with Google products. If you already are a JavaScript developer, a key difference is that scripts run on Google Servers instead of user browsers. As a result, direct operations on the client-side DOM are not supported, although some restricted functionality is provided. Your code executes server-side, and operates on the Google products you've coded for.
Get started today!
An online Script Editor is accessible from Google Spreadsheets and lets you manage and run your scripts.
The Google Apps Script libraries currently support basic events and dozens of actions in Google products, in addition to providing a base library for generic actions within the scripts environment itself. Read the overview, browse the API documentation, or get started in minutes by checking out some working examples from our tutorials.