//email-import-vcards function removeColumns() { var sheet = SpreadsheetApp.getActiveSheet(); var data = sheet.getDataRange().getValues(); var newData = []; for(i in data){ var column1 = [data[i][0]]; var column2 = [data[i][2]]; var column3 = [data[i][14]]; newData.push(column1.concat(column2,column3)); } sheet.clearContents(); sheet.getRange(1, 1, newData.length, newData[0].length).setValues(newData); removeRow(); } function onOpen() { var ui = SpreadsheetApp.getUi(); // Or DocumentApp or FormApp. ui.createMenu('Cleanup contacts') .addItem('Run this on imported vcard data only!', 'removeColumns') .addToUi(); }