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
    /**
 * 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.');
  }
}

    1. 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.

    Further reading

    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).