Google Apps Script Quickstart

Complete the steps described in the rest of this page to create a simple Google Apps Script that makes requests to the Reports API.

Prerequisites

To run this quickstart, you need the following prerequisites:

A Google Workspace domain with API access enabled

A Google account in that domain with administrator privileges

Access to Google Drive

Step 1: Create the script

1. Create a new script by going to script.google.com/create.
2. Replace the contents of the script editor with the following code:

adminSDK/reports/quickstart.gs

View on GitHub

/**
 * List login events for a G Suite domain.
 */
function listLogins() {
  var userKey = 'all';
  var applicationName = 'login';
  var optionalArgs = {
    maxResults: 10
  };
  var response = AdminReports.Activities.list(userKey, applicationName, optionalArgs);
  var activities = response.items;
  if (activities && activities.length > 0) {
    Logger.log('Logins:');
    for (i = 0; i < activities.length; i++) {
      var activity = activities[i];
      Logger.log('%s: %s (%s)', activity.id.time, activity.actor.email,
          activity.events[0].name);
    }
  } else {
    Logger.log('No logins found.');
  }
}

New editor

3. Click Save .
4. Click Untitled project at the top left, type Quickstart, and click Rename.

Legacy editor

3. Click File > Save, name your project “Quickstart”, and click OK.

Step 2: Turn on the Reports API

Enable the Admin Reports API advanced service in your script.

Step 3: Run the sample

New editor

In the Apps Script editor, click Run.

The first time you run the sample, it will prompt you to authorize access:

1. Click Review permissions.
2. Choose an account.
3. Click Allow.

The script's execution log appears at the bottom of the window.

Legacy editor

In the Apps Script editor, click Run > listLogins.

The first time you run the sample, it will prompt you to authorize access:

1. Click the Continue button.
2. Click the Accept button.

To view the script's output, click View > Logs.

It worked!

Great! Check out the further reading section below to learn more.

There was a problem

Bummer, let us know what went wrong. Check out our troubleshooting section below for some common errors and solutions. If you have found a bug in the code, report the issue on GitHub or submit a pull request.

Further reading

• Google Apps Script Advanced Services documentation
• Admin SDK Reports API reference documentation

Troubleshooting

This section describes some common issues that you may encounter while attempting to run this quickstart and suggests possible solutions.

ReferenceError: "[API NAME]" is not defined

This error occurs when the API hasn't been toggled on in the Apps Script code editor. Revisit Step 2.b and ensure the corresponding toggle is set to on.

This app isn't verified

If the OAuth consent screen displays the warning "This app isn't verified," your app is requesting scopes that provide access to sensitive user data. If your application uses sensitive scopes, your your app must go through the verification process to remove that warning and other limitations. During the development phase you can continue past this warning by clicking Advanced > Go to {Project Name} (unsafe).