This article describes a new method of uploading and maintaining user data for Custom Integrations that enables you to push user data into Torii using Torii Sheets — no development skills required.
💡 If you’re looking for the traditional JSON/API-based custom integration, click here.
💡 If you’re looking to upload user data to Torii via Google Sheets, click here.
Overview
Torii Sheets allow you to view, upload and update user data for Custom Integrations in Torii from a dedicated, Torii-built spreadsheet. Data is never saved outside of Torii, and you can upload data to any application by simply populating this sheet. Data is synced manually on demand and is ready to view in Torii shortly afterwards.
This feature is ideal for apps where there’s no native integration or API access is limited. It requires to coding knowledge and is easy to maintain.
Why use Torii Sheets?
Torii offers several ways of uploading user data manually:
- Manual file upload
- JSON/API-based custom integration
- Custom integration with Google Sheets
- Editing directly in Torii Sheets
Using Torii Sheets has several key benefits:
Secure data: You data never leaves Torii - Data from your integration is loaded to the client, and, after editing, is synced directly back to Torii without being saved anywhere else. This keeps your information private and secure.
Smart Imports: Move data from external CSV or Excel files into Torii with intelligent auto-mapping that recognizes your existing data and maps them to Torii-recognized fields.
Data validation: Torii Sheets checks for (and warns about) invalid emails and duplicate users to make sure you are uploading correct data to Torii.
-
IDP Agnostic: Unlike Google Sheets, Torii Sheets is available for all custom integrations, for all customers.
How to Use Torii Sheets
Step 1: Prepare your Custom Integration
Before you can sync data, you must create a custom integration in Torii:
Navigate to the Integrations page in Torii.
Scroll to the bottom and click the Build a Custom Integration tile.
Search for the app you want to manage and click Get Started.
Step 2: Open Torii Sheets
Still in the Integrations page, navigate to your custom integration, and click the menu button
Click on "Open in Torii Sheets", which will open in a new tab.
Step 3: Edit & Sync
- The Torii Sheet will open with the recognized Torii fields ready as columns to populate.
-
Click any cell to type, or paste data from another file - similar to Excel or Google Sheets.
You can import data from any .XLS or .CSV file to Torii sheet via either dragging it directly into the table, or by clicking in the import button.
Rows can be added/deleted freely.
Review Changes: Look for the blue corner indicators on edited cells.
-
Sync to Torii: Click Sync to Torii. The app will validate your data (checking for duplicate emails or invalid formats) and push the updates directly to Torii.
Additional Notes and capabilities
- Torii Sheets provides search and filtering capabilities, as well as data validation:
- Verify that there are no users with duplicate emails
- Verify that there are no users with an invalid email
- Verify that there are no users without an email
- Torii Sheets has a data validation sidebar, showing any potential issues, as well as changes made in the last sync. You can toggle this sidebar on/off via a dedicated button
- While columns can be deleted, this is not recommended. Missing columns will set that value to NULL for all synced users (i.e. deleting the "Roles" column and syncing to Torii will remove all users' roles).
- If you want to upload additional data to Torii via Torii Sheets, please open a support ticket and request that the support team creates a custom field for this application. Please provide the field name and type. Once the ticket is resolved, the field should appear when you next open the Torii Sheet so that you can populate data there.
- Only Torii members with the with the Integrations - Take Action scope can open Torii Sheets and update data.
- The user limit for Torii Sheets is 50,000 users. Attempting to load custom integration data in Torii Sheets for more users will fail.
File Schema
| Field Name | Description | Type & Options | Required |
| The user's unique email | String | Yes | |
| First Name | The user's first name | String | No |
| Last Name | The user's last name | String | No |
| Status | The status of the user in Torii. Only active users are displayed as users of the application |
Enum (Active/Deleted) Default: Active |
Yes |
| External Status | The status of the user as it appears on the application’s site | String | No |
| Roles | Array of roles the user has in the application | String[] | No |
| Licenses | Array of licenses the user has in the application | String[] | No |
| Last Used Date | The last date the user used the application |
Date ISO 8601 (YYYY-MM-DD) |
No |
FAQ
Q: Can I use this for any application?
A: Yes. This method supports any app, even custom or internal ones.
Q: Can I include multiple tabs or sheets?
A: No. The spreadsheet contains only one sheet with the required columns.
Q: How often is the data synced?
A: Manually. You must press "Sync to Torii" for data to be populated in Torii. As data is never saved outside of Torii, navigating away or reloading the page without syncing will result in loss of any changes made.
Q: What happens if I change the sheet structure?
A: The sync will fail. Please keep the column headers and format as pre-defined.
Q: Can I add custom fields?
A: Yes. Custom fields are supported, but they must first be enabled by Torii Support.