Overview

This article explains how to use the Google Sheets Custom Integration to enrich user data by syncing user attributes from a spreadsheet into custom user fields in Torii. This approach is especially useful when required user data is not available in your Identity Provider or HR system and you are unable to push that data into those systems.

Custom User data  in Torii

Torii allows you to enrich user identities with additional context that may not exist in your source systems. Using a Google Sheets Custom Integration, you can define custom columns for user attributes—such as internal classifications, risk indicators, regional tags, or business-specific metadata—and sync them directly into Torii as custom user fields.

Once synced, this data in integrated into the Tori platform. Specifically, it is:

• Available as a column in the Users table

• Available as a column when viewing app users in any specific app.

• Available as a column/data point in dashboard widgets. 

• Available as a filter on user data in relevant tables/widgets. 

• Supported in Workflows (including triggers and If/Else conditions)

You control and maintain the data in Google Sheets, and Torii keeps it automatically up to date with daily syncs.

Syncing Custom user data

Step 1 - Create a custom app to hold your data

• In the Applications page, click on the "+"(Add application) button.
• Type in a descriptive name for the app which will hold your custom data (e.g. "Custom User Details"). and click "Add a custom app <app name>".
  
• Fill in the Website, Category and Description fields with whatever data you'd like, and click "Add application".
   

Step 2 – Create Your Google Sheet

Create a Google Sheet with a single tab.
The sheet must include at least one user identifier column:

• Email or

• Id

In addition, you can create any custom columns you want to sync into Torii.

Example:

Column names are case-sensitive and must remain unchanged after setup.

Step 3 – Connect the Google Sheets Custom Integration

Follow the steps in the Google Sheets Custom Integration article to:

• Share the sheet with Torii’s service account

• Create a new Google Sheets integration in Torii

• Select the application to sync the data into

Step 4 – Enable Custom Fields in Torii

After the integration is connected:

1. Open a support ticket with Torii Support
   

2. Provide the exact column header names you want synced as custom fields

3. Specify the appropriate field type (text, number, date, etc.)

Once enabled:

• The fields will sync automatically as part of the daily integration run

• The data will appear across Torii wherever user fields are supported

⚠️ If a column header is renamed or removed later, the sync for that field will fail.

Using the Enriched Data in Torii

Once synced, the custom user fields can be used throughout the platform:

• Users table – view and filter users by the enriched fields in the Users table or a users table under any specific app.

• Workflows – use fields in triggers and If/Else conditions.

• Dashboards – use the data to create new widgets or filters based on this data. 

Any updates made in Google Sheets will be reflected in Torii after the next daily sync.

Common Use Cases

This method is ideal when:

• Your IdP or HRMS does not contain the required user attributes

• You cannot modify or extend those systems due to permission or policy limitations

• You need a lightweight, non-technical way to manage user metadata

• The data is maintained manually or comes from multiple business stakeholders

Example use cases include:

• Custom user state or classification

• Security or compliance tags

• Business unit overrides

• Temporary user flags

• Any internal attribute not stored elsewhere

   

If you have questions or need help enabling custom fields, please contact Torii Support.