Increase the power of your favorite Google apps — like Calendar, Docs, Drive, Gmail, and Sheets.
Macros, menus, and custom functions
Managing responses for Google Forms
Intermediate tutorial: Simple mail merge
Intermediate tutorial: Gmail statistics report
NEW! Tailor spreadsheet functions to your needs and build reports with custom Google Sheets menu items.
NEW! Email Calendar invites and a personalized Google Doc to every user who responds to a form.
Lots of clients to contact and not enough time? Apps Script can send personalized emails on your behalf.
Find out how to generate charts of your Gmail activity with a script that runs on a monthly trigger.
February 25, 2014
- Deprecated the Finance service. As announced in the blog post, the service will remain available for the next six months but will be turned off on September 26, 2014.
UserPropertieswith a unified
PropertiesService. For more information, see the guide to the Properties service.
- Added the following
DocumentAppclasses and methods, which allow scripts to create bookmarks and named ranges, plus set the user's cursor position or selection.
- Added the following
ScriptAppclass and methods, which allow scripts to create state tokens that can be used in callback APIs (like OAuth flows), as well as to retrieve the script's own OAuth 2.0 access token.
- Added the method
showModalDialog(userInterface, title)to the
Uiclass, and replaced the method
showModelessDialog(userInterface, title). This allows scripts to specify whether a dialog in Google Docs, Forms, or the new version of Sheets should prevent the user from interacting with anything other than the dialog.
- Added the client-side HTML-service method
google.script.host.editor.focus(), which allows scripts to switch browser focus from the dialog or sidebar to the Google Docs, Sheets, or Forms editor.
- In Google Docs and Forms, sidebars now ignore the
setWidth()method; they cannot be changed from the default width of 300px. This change was applied to the new version of Sheets in the previous week's release.
- In Google Docs and Forms, the Undo command can now revert changes made by a script. This is also true in the older version of Sheets, but not the new version.
- In the HTML service, the
NATIVEsandbox mode is now the default if you have not specified which mode your script should use. In a few edge cases, this may affect how existing web apps operate; if so, append
HtmlOutputobject to restore the old behavior.
- The following fix was applied:
- Issue 3622: The title bar of a sidebar shown by a script in Google Docs, Forms, or the new version of Sheets is now the same height as in a sidebar shown by a built-in feature.