Outcome

Google Workspace

List files in Google Drive (Docs, Sheets, Slides, PDFs, etc.) for a Google Workspace domain

Google Workspace logo

Google Workspace

List files in Google Drive (Docs, Sheets, Slides, PDFs, etc.) for a Google Workspace domain

Service Account One-shot

Google Workspace is four connectors in one — Admin Directory for the formal org chart, Calendar for meeting patterns, Gmail metadata for communication intensity, and Drive for document collaboration. Delphi authenticates via a service account with read-only scopes, respects Workspace’s privacy model, and feeds the org graph analyzer that powers the Workforce tab.

What you can ask Delphi

  • Who are the heaviest email senders to external domains this month?
  • Show me calendar load for the engineering leadership team
  • Which shared drives have the most activity in the last 30 days?
  • Find all meetings longer than 60 minutes with more than 8 attendees

Use cases

Meeting load visibility

Delphi reads calendar metadata (never content) and surfaces who's overloaded, which teams meet too much, and which weeks are dominated by recurring noise.

Org graph intelligence

Combined with Delphi's org graph analyzer, Workspace data reveals the actual shape of how your company collaborates — formal hierarchy overlaid with real communication signal.

Technical details

Authentication
Method: Service Account
Required scopes:
  • https://www.googleapis.com/auth/admin.directory.user.readonly
  • https://www.googleapis.com/auth/calendar.readonly
  • https://www.googleapis.com/auth/gmail.metadata
  • https://www.googleapis.com/auth/drive.metadata.readonly
Ingestion
Mode: One-shot
Cadence: On-demand query
Tools exposed (5)
enterprise/list_google_drive_files

List files in Google Drive (Docs, Sheets, Slides, PDFs, etc.) for a Google Workspace domain. Use to discover documents before reading or promoting them. Requires a google_admin connector with drive.readonly scope and domain-wide delegation.

enterprise/query_gmail_metadata

Query Gmail structural metadata for org communication analysis. Returns patterns: who emails whom, message volume, timing, and label usage. PRIVACY-FIRST: NO subject lines or body content are returned — only sender, recipient, timestamp, and labels. Uses the gmail.metadata scope which explicitly forbids body access at the API level. Requires a google_admin connector with domain-wide delegation configured on the dashboard.

enterprise/query_google_admin_directory

Query Google Workspace Admin Directory for organizational data: users, groups, org units, and admin roles. Requires a google_admin connector configured on this dashboard with domain-wide delegation credentials stored in Secret Manager.

enterprise/query_google_calendar_metadata

Query Google Calendar structural metadata for org analysis. Returns meeting patterns: who meets whom, frequency, duration, recurrence, and room usage. PRIVACY-FIRST: NO event titles, descriptions, or body content are returned — only structural metadata. Requires a google_admin connector with domain-wide delegation configured on the dashboard.

enterprise/query_my_google

Query the current user's personal Google account (Gmail, Calendar, or Drive). Requires the user to have connected their Google account via the OAuth2 flow. Only accesses data belonging to the connected user — never org-wide data.

Inputs

enterprise/list_google_drive_files

Name Type Required Description
dashboardId string no Target dashboard/initiative ID. Omit to use the current dashboard.
domain string yes Google Workspace domain to scope the Drive query, e.g. "acme.com". Used to identify internal vs external file owners.
query string no Drive search query in Drive Query Language, e.g. "name contains 'budget'" or "mimeType='application/vnd.google-apps.document'". Omit to return recently modified files.
mimeType string no Filter by MIME type, e.g. "application/vnd.google-apps.document" (Docs), "application/vnd.google-apps.spreadsheet" (Sheets), "application/vnd.google-apps.presentation" (Slides), "application/pdf" (PDF). Appended to the query automatically when provided.
folderId string no Drive folder ID to restrict the search scope. Appended as "'<id>' in parents" to the query.
maxResults number no Maximum number of files to return (1–1000). Defaults to 50.

enterprise/query_gmail_metadata

Name Type Required Description
dashboardId string no Target dashboard/initiative ID. Omit to use the current dashboard.
domain string yes Google Workspace domain to query, e.g. "acme.com". Used to classify senders/recipients as internal vs external.
userEmail string no Specific user email to retrieve Gmail metadata for, e.g. "alice@acme.com". When omitted, queries the primary admin account configured on the google_admin connector. Requires domain-wide delegation to be enabled for the service account.
query string no Optional Gmail search query to filter messages, e.g. "after:2024/01/01 before:2024/02/01". Supports all Gmail search operators. Omit to retrieve recent messages.
maxResults number no Maximum number of messages to retrieve metadata for (1–500). Defaults to 100.

enterprise/query_google_admin_directory

No inputs.

enterprise/query_google_calendar_metadata

Name Type Required Description
dashboardId string no Target dashboard/initiative ID. Omit to use the current dashboard.
domain string yes Google Workspace domain to query, e.g. "acme.com". Used for org-level context and to filter events by internal vs external participants.
userEmail string no Specific user email to retrieve calendar events for, e.g. "alice@acme.com". When omitted, queries the primary admin account configured on the google_admin connector. Requires domain-wide delegation to be enabled for the service account.
timeMin string no ISO 8601 start of the query window, e.g. "2024-01-01T00:00:00Z". Defaults to 30 days ago if omitted.
timeMax string no ISO 8601 end of the query window, e.g. "2024-02-01T00:00:00Z". Defaults to now if omitted.
maxResults number no Maximum number of events to retrieve (1–2500). Defaults to 250.

enterprise/query_my_google

Name Type Required Description
dashboardId string no Target dashboard/initiative ID. Omit to use the current dashboard.
service string yes Which Google service to query. "gmail" — search and read email messages, "calendar" — list calendar events, "drive" — list and search files.
gmail calendar drive
query string no Search query. For Gmail: standard Gmail search syntax (e.g. "from:boss subject:review"). For Calendar: not used (returns upcoming events). For Drive: Drive search query (e.g. "name contains 'budget'").
maxResults number no Maximum number of results to return (1-100). Defaults to 20.

Built to deliver on better outcomes.

Schedule a demo or contact us to learn more.