CODE EXAMPLE FOR JAVASCRIPT

google script get sheet size

var lastColumn = sheet.getLastColumn();
// Returns the position of the last column that has content.