Google Sheets
Overview
The Cisco Identity Intelligence Integration for Google Sheets allows you to use a familiar spreadsheet interface to manage user identity data. This add-on, available on the Google Workspace Marketplace, lets you add or update user information directly in any Google Sheet, and the integration will automatically synchronize these changes to your Identity Intelligence tenant via SCIM. This approach provides a simple, auditable, and efficient way for administrators to manage user identities without needing direct access to the Identity Intelligence portal for every change.
Privacy Policy & Terms of Use
For information on the Cisco Identity Intelligence Privacy Policy, please see this resource: https://oort.io/company/product-privacy-policy/
For our Terms of Use, please see this resource: https://oort.io/terms-of-use/
How the Google Sheets Integration works
The Google Sheets integration is an official Google Workspace Add-on that you install directly into your Google account. Once installed, it adds a custom option under the Extensions toolbar to any Google Sheet you open, allowing you to configure and manage the sync process. The add-on runs entirely within your Google environment, acting on your behalf to securely send user data from your sheet to the Identity Intelligence SCIM endpoint.
Permission Requirements within Google Sheets
The first time you run a function from the add-on menu, Google will require your permission for the add-on to work. This is a standard security procedure. You will be presented with a professional consent screen asking for a minimal set of permissions:
See, edit, create, and delete the current spreadsheet: This scope is restricted to only the single spreadsheet you are working in. The add-on cannot see or access data within any other Google Sheets that do not have the add-on enabled
Display and run third-party web content in prompts and sidebars: This allows the add-on to show the configuration menu
Connect to an external service: This allows the add-on to send SCIM data to the secure Identity Intelligence API endpoint you configure
Allow this application to run when you are not present: This permission is required for the "Enable Automatic Sync" feature to work, allowing the add-on to check for updates on a schedule even when the spreadsheet is closed.
Configuration Steps
Coming soon
Last updated