Overview of the Apps Script dashboard

Jasper Duizendstra
Google Developer Experts
3 min readDec 10, 2020

--

The Apps Script dashboard lets you manage and monitor your Apps Script projects. This is the first sentence in the documentation about the Apps Script dashboard. It describes the high level purpose of the Apps Script dashboard, but what does that mean in real live environments. In this article I will describe some of my use cases for the Apps Script dashboard.

Photo by Mitchel Boot on Unsplash

Opening the Apps Script dashboard is usually the first step I take whenever I start working in a new environment. I work for multiple companies and I have a lot of Google Accounts. It is great to see all the projects in the “All Projects” section. This will immediately give you an idea of what kind of projects you have access to. This might sound obvious but when I opened the dashboard of my oldest account and sorted on the last modified date I saw a script last modified on Dec 2, 2010.

Projects overviews

The “My Projects” and “Shared with me” are nice subsets of the projects. I do miss a better filter and sorting on the owner would also be great. If you hover over a project you can open the project information by clicking on the information icon. The information page provides an overview of the script and container if it is a container bound script.

Starring projects is one of the most useful features for me. Hover over a project and use the three dots to open the menu and star the project. In the screenshot below I have starred five projects.

This overview shows all the relevant information for the starred projects.

Executions and triggers

The “My Triggers” and “My Executions” sections show your executions and triggers. This can be confusing because there can be other executions and triggers. Open the project itself if you want to see all the executions and triggers.

You can use the filters to limit the rows in the overview:

In the “My Triggers” section you can see all your triggers. Hover over the trigger and use the pencil icon if you want to edit the trigger. The trigger can be deleted in the menu that opens with the three dots.

The rest of the options

In the “Getting Started” you will find additional information and some starter projects. The “Settings” section only contains the option to enable the Google Apps Script API. And finally the “Service Status” section links to useful sections in the Guides.

Wrapping up

In this article I have discussed the “quirks and features” of the Apps Script dashboard. The Apps Script dashboard provides a bird’s-eye view of all the Google Apps Script script you own or have access to. It also enables you to dive right into the project information.

For me the Apps Script dashboard is the first thing I see when I start working on a new project or when I want to get familiar with the Google Apps Script scripts available for an account.

--

--

Jasper Duizendstra
Google Developer Experts

Freelance Google Cloud Platform Architect, Google Workspace GDE