Google

Google Sheets

Google Sheets is a cloud-based spreadsheet application that allows users to create, edit, and collaborate on spreadsheets online. It supports real-time collaboration, formulas, charts, and integrations with other Google services.

Deploy in Cloud
Documentation

Connect to Sheets


Overview

Our Google Sheets integration enables seamless data management by connecting IDHub to Google Sheets via REST APIs. This allows real-time data retrieval, updates, and automated workflows.
 

IDHub fetches key user attributes from Google Sheets, including:

   userLogin – Unique identifier

   firstName, lastName – User’s name

   email – Email address

   status – Account status

   department – User’s department

   jobTitle – Job title

   employeeType – Worker classification

 

Additional attributes can be configured as needed.


Access & Permissions

IDHub integrates with Google Workspace to manage spreadsheet access. Employees can request access, and workflows automate approvals and updates.
 

Support

We provide out-of-the-box API integration with standard maintenance. Customizations require a managed services plan.

Implementation
Google

Feature Summary

1

Provisioning

  1. Create User
  2. Modify User
  3. Create Groups (Entitlements)
2

De-provisioning

  1. Remove user
  2. Remove Groups (Entitlements)
3

Reconciliation

  1. Fetch User
  2. Fetch Groups
  3. Fetch User Assigned Groups
4

Additional Use Case

  1. Sync to Azure AD
  2. Sync to Okta
  3. Powershell Scripting