Automated Google Workspace Reporting

Admin Report
Generator

Comprehensive analytics and security insights for your Google Workspace domain. Get detailed reports on user activity, storage usage, and security metrics.

Sign in with Google

Usage Analytics

Track adoption of Google Workspace apps, storage usage, and user activity across your organization.

Security Insights

Monitor 2-Step Verification status, suspicious logins, OAuth tokens, and third-party app access.

AI-Powered

Track Gemini AI adoption with detailed usage statistics for Gemini App and Sidepanel.

Requested Permissions

We request only the minimum permissions necessary to generate your report. We use read-only access for all data except where we need to create the report (e.g. creating the Google Sheet in your My Drive and, if you opt in, sending the summary by email). BigQuery is optional and requested only for deployments where you enable email security (Suspicious) analysis.

Sign-in / Identity

Basic

Identify who is signing in (email address) so the app can associate the report with your account

openid userinfo.email

Admin Directory

Read-only

View users, groups, domains and customer information

admin.directory.user.readonly admin.directory.group.readonly admin.directory.customer.readonly admin.directory.domain.readonly

Admin Reports

Read-only

Access audit logs and usage reports for analytics

admin.reports.audit.readonly admin.reports.usage.readonly

User Security

Read-only

View OAuth tokens issued to users for security analysis

admin.directory.user.security

Gmail

Send email

Send the generated report by email (when scheduled or requested)

gmail.send

Google Drive

Create report

Create and store the report as a Google Sheet in your My Drive (folder "Damson Cloud/Admin report")

drive.file

Google Sheets

Read-only / Create

Create the report spreadsheet and write its content (tables, metrics)

spreadsheets

BigQuery

Optional

Only requested when your deployment is configured to use BigQuery for email security (Suspicious) analysis. If you do not enable this feature, this permission is not requested.

bigquery

What's in the Report?

A comprehensive Google Sheets report with multiple sections

👥

User Accounts

Total users, admins, suspended accounts

🔐

Security Status

2SV enrollment, suspicious logins

📊

App Usage

Gmail, Drive, Meet, Chat adoption

🤖

Gemini AI

AI adoption and usage statistics

💾

Storage

Drive storage usage by type

🔗

OAuth Tokens

Third-party app access

📁

File Sharing

External sharing statistics

📈

Trends

Month-over-month changes