Google Sheets - OpenText Identity and Access Management Integration and Automation

Common Integration Use Cases Between Google Sheets and OpenText Identity and Access Management

• Access request tracking and approval coordination
  Business teams maintain access request logs in Google Sheets for OpenText users, including requester name, department, required role, and justification. Approved requests are then synchronized to OpenText Identity and Access Management for provisioning or role assignment. This reduces manual email-based approvals and gives security and operations teams a shared, auditable workflow.
• Role and entitlement review campaigns
  Security administrators export current OpenText user roles and access entitlements into Google Sheets for periodic review by application owners and managers. Reviewers validate whether access is still required, flag exceptions, and add comments directly in the sheet. The reviewed data is then fed back into OpenText Identity and Access Management to remove unnecessary access and support compliance audits.
• Joiner, mover, leaver coordination
  HR or operations teams use Google Sheets as a lightweight staging area for employee status changes, department transfers, and terminations. The sheet is integrated with OpenText Identity and Access Management to trigger account creation, role changes, or deprovisioning based on approved records. This helps ensure timely access updates and reduces the risk of orphaned accounts.
• Access policy exception management
  When users need temporary or nonstandard access to OpenText services, request details are captured in Google Sheets for business review and exception tracking. Once approved, the exception data is pushed into OpenText Identity and Access Management to apply time-bound access or elevated permissions. This creates a controlled process for handling exceptions while preserving governance.
• Application onboarding and role mapping preparation
  Project teams use Google Sheets to define new application access models, including user groups, roles, approval owners, and segregation-of-duties notes before onboarding to OpenText Identity and Access Management. The structured sheet is then used to configure identity workflows and access rules. This shortens implementation cycles and improves consistency during new service rollouts.
• Identity data quality review and remediation
  Identity administrators export user profiles, group memberships, and access assignments from OpenText Identity and Access Management into Google Sheets for cleanup and validation. Business owners can correct department names, manager assignments, or role labels in a collaborative format. Cleaned data is then reimported to improve identity accuracy and reduce downstream access errors.
• Audit evidence collection for compliance reporting
  Compliance teams compile access review evidence, approval notes, and exception justifications in Google Sheets while OpenText Identity and Access Management provides the authoritative identity and access records. The integration supports periodic audit packages by linking spreadsheet-based review artifacts with system-generated access history. This simplifies evidence gathering for internal controls and external audits.
• Delegated access administration for distributed teams
  Regional managers or department leads maintain local access needs in Google Sheets, such as contractor onboarding lists or project-based access changes. The approved entries are synchronized to OpenText Identity and Access Management, where centralized policies still govern authentication and role assignment. This balances local operational flexibility with enterprise security control.