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
To set up the integration, perform the following steps:
Install the Add-on
Go to the "Cisco Identity Intelligence Sheets Extension" using this link link and select Install
Follow the on-screen prompts to grant installation permissions for your account or domain.
Launch and Configure
Create a new, empty Google Sheet
Within that Google Sheet, navigate to the menu and select Extensions > Cisco Identity Intelligence > 1. Configure Credentials which will open a configuration sidebar
Login to Identity Intelligence and navigate to the Integrations menu item > Add integration > and select SCIM integration. Keep this page open because you will need to copy the credentials in the next step
In the Google Sheets sidebar, paste the Endpoint URL, Token URL, Client ID, and Client Secret from the Identity Intelligence SCIM integration set up page (Step 4) into the corresponding fields and select Save
The first time you save, a dialog box titled "Authorization Required" will appear where Google will ask for your permission to authorize the add-on. Select Continue in the dialog box
Select your Google account. A professional consent screen will appear, showing the add-on name and the specific permissions requested
Review them and select Allow
Test Connection and Enable Sync
After you have successfully saved your credentials, the add-on will automatically add the required template headers and formatting to the empty sheet
NOTE: This templating feature will only work if the sheet is completely empty. If your sheet contains any data, the save will fail with a warning
Within that Google Sheet, navigate to the menu and select Extensions > Cisco Identity Intelligence > 2. Test Connection
A pop-up will appear confirming if the connection to the Identity Intelligence API was successful
To enable the automatic sync, navigate to the Extensions menu again, select Cisco Identity Intelligence > 3. Enable Automatic Sync. This will set up a trigger that automatically runs the sync process once every hour
If you need to push changes immediately, you can select Run Manual Sync Now from the Identity Intelligence Extensions menu at any time
Adding and Editing Users in the Sheet
Once the integration and connection between Google Sheets and Identity Intelligence has been configured, adding and editing users in the sheet is simple.
Add a new user
Fill out a new row with the user's details - Username, First Name, Last Name, Email, Active. Leave the Sync Details columns (Status, Sync Hash) blank.
The script will populate these fields automatically upon creation.
Update an Existing User
Change the desired value(s) in a given user's row. For ex: change the Active column from TRUE to FALSE. The script will detect the change and send an update request.
"Sync Details" Columns
The following columns are managed by the script and SHOULD NOT be edited manually:
Status - Shows if a row was successfully synced or if an error occurred
Sync Hash - A "digital fingerprint" of the row's data which is used to detect changes
Last updated