Skip to content

Instantly share code, notes, and snippets.

function shortenUrl() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var longUrls = sheet.getRange("J3:J10").getValues();
var writeValues = []
var numRows = longUrls.getNumRows();
var numCols = longUrls.getNumColumns();
for (var i =1 ; i <= numRows; i++) {
function shortenUrl() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var longUrls = sheet.getRange("J3:J10").getValues();
var writeValues = []
for (var i =1 ; i <= numRows; i++) {
var row = []
var numRows = longUrls.getNumRows();