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 G Suite 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.');
  }
}

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

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.

The OAuth consent screen that is presented to the user may show the warning "This app isn't verified" if it is requesting scopes that provide access to sensitive user data. These applications must eventually 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).