This article describes a new type of Custom Integration that enables you to push user data into Torii using Google Sheets — no development skills required.

💡 If you’re looking for the traditional JSON/API-based custom integration, click here.

Overview

The Google Sheets Custom Integration lets you sync user data into Torii from a spreadsheet you maintain. You can integrate any application by simply populating a shared Google Sheet. Torii will automatically sync the data once every 24 hours.

This integration is ideal for apps where there’s no native integration or API access is limited.

Step 1 – Prepare your Google Sheet

Create a new Google Sheet with only one sheet (tab). 
This sheet can contain the following column headers. 

💡 If you’d like to add custom fields beyond the standard ones, see the Custom Fields section below.

Note: Either Email or Id must be provided for each user. At least one of them is required for a successful sync.

Step 2 – Share the sheet with Torii

In order for Torii to sync the data, you need to share your Google Sheet with our integration service account.

1. Open your Google Sheet
2. Click Share
3. Enter the following email and select Viewer permission:
   sheets-sync@torii-email-integration.iam.gserviceaccount.com
4. Click Send

🔒 We recommend giving the lowest possible permission (Viewer) to ensure data security.

Step 3 – Set up the integration in Torii

1. In Torii, go to the Integrations page
2. Scroll to the bottom and click Build a Google Sheets integration
   
3. In the popup:
   • Select the application you want to integrate
   • Paste the Google Sheets URL

   • Click Connect

     

Custom Fields

In addition to the standard fields, Torii also supports custom fields for users.

To add a custom field:

1. Contact Torii Support and request the new field to be configured for your account.

2. Make sure to provide the exact column header from your Google Sheet (for example, Job Title), spelled exactly as it appears in the sheet, including uppercase/lowercase letters (case sensitive).
   ⚠️ If the column header name is changed later, the data will not sync.

   The supported custom field types are:

   • datePicker - uses ISO date format (e.g., 2026-01-01T11:30:00+02:00)
   • email
   • singleLine (Text)
   • user - A custom field of type user means that the value of the field is a reference to a user object, not free text. The value should be the user’s email address.
   • multiValueString - means the field can hold multiple text values in a single field, stored as a list (e.g,
     role1, role2, role3)
   • number
3. Once the new field is added by Torii Support, the data will be included in the daily sync.

What happens next?

• Torii will connect the integration and display it like any other app integration
• The data from the spreadsheet will be synced daily
• You’ll see synced users, roles, licenses, and usage data in Torii
• You can use this integration in workflows, license reports, and optimization insights

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 must contain only one sheet with the required columns.

Q: How often is the data synced?
A: Daily. You can always re-sync the integration.

Q: What happens if I change the sheet structure?
A: The sync will fail. Please keep the column headers and format as defined.

Q: Can I add custom fields?
A: Yes. Custom fields are supported, but they must first be enabled by Torii Support. You’ll need to provide the exact column header from your sheet.

If you have any questions, feel free to contact Torii Support.