Skip to content
  • There are no suggestions because the search field is empty.

How to Create a Report in gPanel

Create custom reports in gPanel to track Google Workspace usage, monitor performance, and gain actionable insights.

 

Running a report will populate a Google Sheet in your Drive account with all of the configured information.

  1. Navigate to Reports. Then, click Create report on the top right corner.  

gPanel report management toolbar featuring Create Report button, delete, refresh, and template icons.

  1. The basic Information window will be displayed beginning on the Basic Info screen. Here you will enter the following information:

Basic Information

  • Report Name: Desired name of the configured report..
  • Report Type: Select among the available report types
  • Generated File name:This will be name of the generated report after the report runs. By default the report is formatted as {|ReportType|}_{|DateTime|}
  • Report Description: Provide an optional description as to what the policy is configured for.
  • Manual Run: Enable manual run if you want to manually decide when to run the report.
  • Set Schedule: Enable set schedule if you want to set a schedule for the report to run automatically.
  • Run without saving: Enable Run without saving if you only wish to generate a report one time

Destination Folder

  • Optionally provide a destination folder for your report to be placed in once it has been run. If none is provided, the report will be in the root of your My Drive.

Once you have configured the basic information, click Next to proceed.

gPanel Create Report interface showing Basic Information setup for an Abandoned Calendar Events report.

  1. Schedule: If you chose to run the report on a set schedule, this is where you configure the schedule. Select Time, frequency and define the end date for the schedule run.

gPanel Create Report schedule configuration screen showing options for time, frequency, and report end date.

  1. Depends on what report you selected. A Report configuration will occur.  In some cases a Date range, External Email Addresses, Sources or count of days back  would be needed. 

gPanel Report Configuration screen showing the Date Range selection for report data.

 Depending on which report type you select, the next sections that appear in your configuration will vary. Below is an overview of each section: 

  1. Select Columns: This is where you select which columns you want to be included in the report. These are the columns that will be displayed in the Google Sheet. You can add all columns or select specific columns to include.

gPanel Select Columns interface displaying a checklist of available report fields like Doc Owner, Doc Title, and Created Date.

  1. Sources: This is where you select which columns you want to be included in the report. These are the columns that will be displayed in the Google Sheet. You can add all columns or select specific columns to include.

gPanel Create Report Sources interface showing options to select report data from Users, Groups, Org Units, or Domains.

  1. Email Notifications and Sharing: This is where you can choose to send email notifications on completion of the report. You can select users by searching for their name and clicking the add icon. You can remove users by clicking the X next to their name. For sharing this  is where you can choose to share the report with other user(s). You can select users by searching for their name and clicking the add icon. You can remove users by clicking the X next to their name.

gPanel Email & Sharing configuration screen with user search fields for report notification emails and file sharing access.

  1. The final step is the Review screen. All of the information about the new report will be displayed. If you would like to run the report immediately after saving, switch the corresponding toggle to yes. Once you have reviewed the information, click Create Report to save.

gPanel Email & Sharing configuration screen with user search fields for report notification emails and file sharing access.