If you use Google Apps, then chances are you’re not using them to their full extent. With Google Apps Script, you can add custom menus and dialogs, write custom functions and macros, and build add-ons to extend Google Docs, Sheets, and Slides.
What Is Google Apps Script?
Google Apps Script is a cloud-based development platform for creating custom, light-weight web applications. You can build scalable applications directly inside your browser that integrate effortlessly with Google products.
You can make two types of scrips with Google Apps Script:
- Standalone: These scripts aren’t bound to any service—like Google Docs, Sheets, or Slides. They can perform system-wide functions, sort of like macros. They’re not ideal for sharing with a broader audience because you need to copy and paste the code to use them. Examples include searching your Drive for files with specific names or seeing who has access to your shared files and folders in Drive.
- Bound: These are linked to a Google Docs, Sheets, Forms, or Slides file. Bound scripts extend a file’s functionality and perform actions only in that specific file. Examples include adding custom menus, dialogs boxes, and sidebars to a service or a script that emails you notifications any time a particular cell in a Sheet changes.
How to Create a Standalone Script
Head on over to Google Apps Script. In the top left corner, click the hamburger icon, then click “New Script.”