function onOpen() {
  SpreadsheetApp.getUi().createMenu("🔥")
    .addItem('сократить ссылку', 'create_ltb_url')
    .addToUi();
};

const litbytoken = '';

function create_ltb_url() {
  const cell = SpreadsheetApp.getActiveRange();
  const url = cell.getValue();
  var result = r2('https://api-ssl.bitly.com/v4/shorten', 'POST', litbytoken, {
    "long_url": url
  });

  result = result['link'];
  // Logger.log(result)
  cell.offset(0, 1).setValue(result);
  SpreadsheetApp.flush();
}

function r2(url, method, token, data) {
  let params = {
    method: method,
    muteHttpExceptions: true,
    contentType: 'application/json',
    payload: JSON.stringify(data),
    'headers': {
      'Authorization': 'Bearer ' + token,
      'contentType': 'application/json'
    }
  };

  var r = UrlFetchApp.fetch(url, params);
  Logger.log(r);
  return JSON.parse(r);
};