---
updatedAt: 2025-09-25T21:10:46.000Z
agentTools:
  projectIndex: https://developers.toriihq.com/llms.txt
---

# Stripe Custom Integration

```javascript JavaScript
function onOpen() {
  let ui = SpreadsheetApp.getUi();
  ui.createMenu('Torii')
      .addItem('Sync now','syncNow')
      .addItem('Reconfigure','readConfig')
      .addToUi();
}

function syncNow(){
  //readConfig();
  let docProperties = PropertiesService.getDocumentProperties();
  API_KEY = docProperties.getProperty('api_key');
  APP_ID = docProperties.getProperty('app_id');


  if (!API_KEY || !APP_ID) {
    readConfig();
    docProperties = PropertiesService.getDocumentProperties();
    API_KEY = docProperties.getProperty('api_key');
    APP_ID = docProperties.getProperty('app_id');
  }

  let file = createJsonFile();
  let fileId = uploadFile(file);  
  syncIntegration(fileId);
}

function readConfig() {
  /*
  let = sheet = SpreadsheetApp.getActive().getSheetByName("Configuration");
  API_KEY = sheet.getRange('B1').getValue();
  APP_ID = sheet.getRange('B2').getValue();
  Logger.log(API_KEY);
  Logger.log(APP_ID);
  */
  let ui = SpreadsheetApp.getUi();
  let result = ui.prompt("Please enter Torii API Key");
  API_KEY = result.getResponseText();

  result = ui.prompt("Please enter the APP ID");
  APP_ID = result.getResponseText();

  let docProperties = PropertiesService.getDocumentProperties();
  docProperties.setProperty('api_key', API_KEY);
  docProperties.setProperty('app_id', APP_ID);
}

function createJsonFile() {
  let = sheet = SpreadsheetApp.getActive().getSheetByName("Users");
  let data = sheet.getDataRange().getValues(); 
  Logger.log(SpreadsheetApp.getActiveSheet().getName());
  Logger.log(data);
  data.shift();

  let users = [];
  let licensedUsers = [];
  data.forEach(function (row) {
    let id = row[0];
    let fullName = row[1]
    let firstName = fullName.split(' ').slice(0, -1).join(' ');
    let lastName  = fullName.split(' ').slice(-1).join(' ');
    let email = row[0];
    let type = row[3];
    let status = row[2].toString();
    let lastUsedDate = Utilities.formatDate(new Date(row[5]), "UTC", 'YYYY-MM-dd');
    let licenseType = "Stripe";
  

    users.push(
        {
            email: email,
            firstName: firstName,
            lastName: lastName,
            status: 'active',
            externalStatus: status,
            roles: [type],
            lastUsedDate: lastUsedDate
            
        }
    );
    if (licenseType == "Stripe"){
    licensedUsers.push(
        {
            email: email,
            licenseStatus: "active"
        }
    );
    }

  });

  let file = {
    users: users,
    licenses: [{
      name: "Stripe",
      pricePerUser: 0,
      unassignedAmount: 0,
      users: licensedUsers
    }   
    ]
  }
  Logger.log(file);

  return file;
}

function syncIntegration(fileId) {
  response = UrlFetchApp.fetch('https://api.toriihq.com/v1.0/services/sync/custom',
    {
      muteHttpExceptions: false,
      'method' : 'put',
      'contentType': 'application/json',
      'payload' : JSON.stringify({
          idFile: fileId,
          idAppAccount: APP_ID
      }),   
      headers: {
        'Authorization': `Bearer ${API_KEY}`
      }
    }
  );
  Logger.log(response);
}

function uploadFile(file) {
  let response = UrlFetchApp.fetch('https://api.toriihq.com/v1.0/files/url?name=my_file.json&type=customIntegrationData',
    {
      headers: { 'Authorization': `Bearer ${API_KEY}` }
    });

  let jsonResponse = JSON.parse(response);
  let s3url = jsonResponse.uploadFileParameters.url;
  let filePath = jsonResponse.uploadFileParameters.filePath;  
  Logger.log(s3url);
  Logger.log(filePath);

  response = UrlFetchApp.fetch(s3url,
    {
      'method' : 'put',
      'contentType': 'customIntegrationData',
      'payload' : JSON.stringify(file)
    }
  );
  
  // Get file id
  response = UrlFetchApp.fetch('https://api.toriihq.com/v1.0/files',
    {
      method: 'post',
      contentType: 'application/json',
      headers: { 'Authorization': `Bearer ${API_KEY}` },
      payload: JSON.stringify({
        path: filePath,
        type: 'customIntegrationData'
      }),
      headers: {
        'Authorization': `Bearer ${API_KEY}`
      }
    });

    jsonResponse = JSON.parse(response);
    let fileId = jsonResponse.id;
    Logger.log(fileId);
    return fileId;
};
```

```json Response Example
{"success":true}
```

# Create Menu

<!-- javascript@1-6 -->



# Sync

<!-- javascript@9-26 -->



# Read Config

<!-- javascript@28-46 -->



# Create JSON File

<!-- javascript@48-105 -->



# Call Sync Integration Endpoint

<!-- javascript@107-123 -->



# Upload file to Torii

<!-- javascript@125-164 -->