google-sheets.png

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.

Google
Sheets

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.

Feature Summary

Provisioning

done
Create User
done
Modify User
done
Create Groups (Entitlements)

Deprovisioning

done
Remove User
done
Remove Groups (Entitlements)

Reconciliation

done
Fetch Users
done
Fetch Groups
done
Fetch User Assigned Groups

Additional Use Case

done
Sync to Azure AD
done
Sync to Okta
done
Powershell Scripting