Advanced Analytica Advanced Analytica: IBOM
← All connectors
Gemini for Google Workspace logo

Source connector

Gemini for Google Workspace

Set up Gemini for Google Workspace as a source and move its data into your chosen destination.

Version 0.0.3 community alpha

Gemini for Google Workspace

This source syncs Gemini for Google Workspace activity from the Google Workspace Admin SDK Reports API. It reads feature_utilization events from the gemini_in_workspace_apps application. Admins can track Gemini adoption and usage across Gmail, Docs, Sheets, Slides, Meet and other Workspace apps. This supports auditing and governance.

This connector doesn’t read from the Gemini API (Google AI Studio or Vertex AI).

Prerequisites

  • A Google Workspace account with an admin who has the Reports admin privilege, such as a super admin.
  • A Google Cloud project where you can enable APIs and create OAuth clients.

Setup guide

Step 1: Enable the Admin SDK API

  1. In the Google Cloud console, select or create a project.
  2. Go to APIs & Services > Library, search for Admin SDK API, then click Enable.

Step 2: Create an OAuth client

  1. Go to APIs & Services > OAuth consent screen and configure the consent screen. Choose the Internal user type. This means only users in your Workspace organisation can authorise the app.
  2. Go to APIs & Services > Credentials, click Create credentials > OAuth client ID, then choose Web application.
  3. Under Authorized redirect URIs, add https://developers.google.com/oauthplayground.
  4. Click Create, then copy the Client ID and Client secret.

Step 3: Get a refresh token

The connector needs only one OAuth scope:

https://www.googleapis.com/auth/admin.reports.audit.readonly

Generate a refresh token with the OAuth 2.0 Playground:

  1. Click the gear icon, select Use your own OAuth credentials, then enter the Client ID and Client secret from Step 2.
  2. In Step 1 - Select & authorize APIs, enter the scope above, then click Authorize APIs.
  3. Sign in as the Workspace admin with the Reports privilege, then grant access.
  4. In Step 2 - Exchange authorization code for tokens, click Exchange authorization code for tokens, then copy the Refresh token.

Google expires refresh tokens after 7 days when the consent screen uses the External user type with Testing publishing status. Use the Internal user type to avoid this.

Step 4: Set up the connector in Airbyte

  1. In Airbyte, go to Sources and select Gemini for Google Workspace.
  2. Enter the Client ID, Client secret and Refresh token.
  3. Optionally, set Start Time and End Time in RFC 3339 format, such as 2026-01-01T00:00:00.000Z.
  4. Click Set up source.

Configuration

InputTypeDescriptionDefault Value
client_idstringClient ID. OAuth client ID from your Google Cloud project.
client_secretstringClient secret. OAuth client secret from your Google Cloud project.
client_refresh_tokenstringRefresh token. Refresh token granted by a Workspace admin with the admin.reports.audit.readonly scope.
start_timestringStart Time. Start of the report time range in RFC 3339 format. The API only allows data from the last 180 days, so earlier dates are adjusted forward to stay within that window.Start of the day (00:00:00 UTC) 180 days ago
end_timestringEnd Time. End of the report time range in RFC 3339 format.Start of the current day (00:00:00 UTC)

Streams

Stream NamePrimary KeyPaginationSupports Full SyncSupports Incremental
activity_eventstime, uniqueQualifierDefaultPaginator✅✅

Records include the actor, events and their parameters, resource IDs, and an isAgenticAction flag. Actor details include email, profile ID, caller type and application information. The ipAddress, networkInfo, resourceDetails, etag and kind fields are removed from records.

Sync behaviour

Incremental syncs use the time cursor in 1-day slices. A 1-day lookback window captures events that Google reports late. By default, the range ends at the start of the current UTC day. This means only complete days are synced. The Reports API retains only 180 days of activity data.

The connector retries HTTP 429, 500, 502, 503 and 504 responses with exponential backoff. For quota details, see Reports API limits and quotas.

Changelog

Expand to review
VersionDatePull RequestSubject
0.0.32026-11-1091523Update dependencies
0.0.22026-11-0390573Update dependencies
0.0.12026-10-2688377Initial release by @Joshua-omolewa via Connector Builder
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.