Report an issue
Back to plugin list
googleworkspace

Google Workspace

Pull directory information from your Google Workspace organization. Requires admin privileges.

Publisher

jsifuentes

Repositorygithub.com
Latest version

v1.0.1

Type

Source

Platforms
Date Published

Dec 11, 2023

Price

Free

Set up process


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync googleworkspace.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview

Google Workspace Source Plugin

A Google Workspace source plugin for CloudQuery that loads data from Google Workspace to any database, data warehouse or data lake supported by CloudQuery, such as PostgreSQL, BigQuery, Athena, and many more.

Configuration

The following source configuration file will sync to a PostgreSQL database. See the CloudQuery Quickstart for more information on how to configure the source and destination.
If token_file is set, after you successfully authenticate via OAuth, your access token will be written to the token_file. The token_file will be used on subsequent syncs.
How to find your Google Workspace Customer ID: https://support.google.com/a/answer/10070793?hl=en
You can get your own OAuth credentials using this guide. When creating your OAuth Client ID, you should select "Desktop app". You also need to enable the Admin SDK API for your Cloud Project.
kind: source
spec:
  name: "googleworkspace"
  path: "jsifuentes/googleworkspace"
  registry: "cloudquery"
  version: "v1.0.1"
  destinations:
    - "postgresql"
  spec:
    customer_id: your Google Workspace Customer ID
    oauth:
      # token_file: ./token.json
      client_id: your Google Cloud Project OAuth Client ID
      client_secret: your Google Cloud Project OAuth Client Secret


Subscribe to product updates

Be the first to know about new features.