Google Apps Script Tip #1: Finding the last row

Ian Lurie

I’ve been building some custom reports for Portent in Google Spreadsheets. They do fun stuff like grab Google Analytics data, insert data from other APIs and such.

One thing that nearly drove me batty, though, was figuring out how to automatically add a new row below the last row with data.
Turns out, Google App Script has it’s own nifty command, called getLastRow. Here’s how you do it:

function FindRows() {
range = SpreadsheetApp.getActiveSheet().getLastRow();
return range;

That’s it. It’ll return the value range. That value is the number of the last row on the sheet that has data. You can then pass that back to other functions to start adding new rows in the right place, delete rows, etc..

If this is all gibberish, fear not. Marketing Ian will be back Monday. Today is Nerd Ian.

Start call to action

See how Portent can help you own your piece of the web.

End call to action


  1. Whether Nerd Ian or Marketing Ian arrives in my inbox, I am always delighted to read your emails. Your sense of humor is wacky and wonderful. The knowledge you share very much appreciated.
    I especially liked yesterday’s giving points to clients or taking them away.
    All the best,

Comments are closed.

Close search overlay