Google Apps Script is a rapid application development platform that makes it fast and easy to create business applications that integrate with Google Workspace. You write code in modern JavaScript and have access to built-in libraries for favorite Google Workspace applications like Gmail, Calendar, Drive, and more. There's nothing to install—we give you a code editor right in your browser, and your scripts run on Google's servers.
If you're new to JavaScript, Codecademy offers a number of JavaScript courses. (Note that these courses weren't developed by and aren't associated with Google.)
What can Apps Script do?
Apps Script is versatile. Among other things, you can:
- Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.
- Write custom functions and macros for Google Sheets.
- Publish web apps — either standalone or embedded in Google Sites.
- Interact with other Google services, including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.
- Build add-ons to extend Google Docs, Sheets, Slides, and Forms, and publish them to the Add-on store.
- Convert an Android app into an Android add-on so that it can exchange data with a user's Google Doc or Sheet on a mobile device.
- Streamline Google Chat workflows by building a chat bot.
Your first script
Build and run a simple standalone script that creates a Google Doc and emails you a link to it.
Set it up
To build the script, follow the steps below.
New editor
- Sign in to your Google Account.
- To open the script editor, go to
script.google.com
. If this is the first time you've been toscript.google.com
, click View Dashboard. - At the top left, click New project.
Delete any code in the script editor and paste in the code below.
At the top, click Save
.At the top left, click Untitled project.
Enter a name for your script and click Rename.
Legacy editor
- Sign in to your Google Account.
- To open the script editor, go to
script.google.com
. If this is the first time you've been toscript.google.com
, click View Dashboard. Delete any code in the script editor and paste in the code below.
Select the menu item File > Save. Name your new script and click OK.
Try it out
To execute the script, follow the steps below.
New editor
- At the top of the editor, click Run.
- In the first dialog box that appears, click Review permissions. In the second dialog box, review the permissions your script uses and click Allow.
- When the script execution completes, check your Gmail inbox for the new email.
- Open the email and click the link to open the Google Doc you created.
Legacy editor
- To execute the script, either click run ▶ or select the menu item Run > createAndSendDocument.
- A dialog box will appear and tell you that the script requires authorization. Click Continue. A second dialog box will then request authorization for specific Google services. Read the notice carefully, then click Allow.
- A yellow bar at the top of the script editor will indicate when the script is running. When the yellow bar disappears, the script has finished.
- Check your Gmail inbox for the new email, then click the link to open the Google Doc you created.
- Open your Google Drive. You'll see that both the script and the document are stored there.
Learn more
To continue learning about Apps Script, take a look at the following resources: