Enable import range App Scripts

enable-import-range-permission.js

function enableImportRangePermission(ssId, donorId) {
  console.log(`Addind ImportRangePermission for ${ssId}`)

  const url = `https://docs.google.com/spreadsheets/d/${ssId}/externaldata/addimportrangepermissions?donorDocId=${donorId}`
  const token = ScriptApp.getOAuthToken()

  const params = {
    method: 'post',
    headers: {
      Authorization: 'Bearer ' + token,
    },
    muteHttpExceptions: true
  }

  const response = UrlFetchApp.fetch(url, params)

  if (response.getResponseCode() < 200 || response.getResponseCode() > 299) {
    console.log(`[IMPORT_RANGE_ERROR] Error during feasibility enable import range permission, Feasibility ID: ${dt.id}`)
    throw new Error(`[IMPORT_RANGE_ERROR] Request error (${dt.callbackUrl}): ${response.getContentText()}`)
  }

  console.log(`Permission added to ${ssId} (donor: ${donorId})`)
}