Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function onOpen() {
- SpreadsheetApp.getUi()
- .createMenu("Shorten")
- .addItem("Go !!","rangeShort")
- .addToUi()
- }
- 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]);
- }
- range.offset(0,1).setValues(output);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement