Google Script to shorten URLs.

// Grabbed from http://webapps.stackexchange.com/questions/76050/google-sheets-function-to-get-a-shortened-url-from-bit-ly-or-goo-gl-etc

// Add a menu action item when the sheet is opened.
function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu("Shorten")
    .addItem("Go !!","rangeShort")
    .addToUi()  
}

// Get the active range. Can be a single cell or a highlighted column.
function rangeShort() {
  var range = SpreadsheetApp.getActiveRange(), data = range.getValues();
  var output = [];
  for(var i = 0, iLen = data.length; i < iLen; i++) {
    var url = UrlShortener.Url.insert({longUrl: data[i][0]});
    output.push([url.id]);
  }
  // Add the shortened URL to the cell immediately to the right of the selected cell.
  // If you want to replace the selected URL rather than append, change range.offset to (0,0)
  range.offset(0,1).setValues(output);
}