Google Apps Script Tip #1: Finding the last row

google devs Analytics

Ian Lurie Apr 8 2011

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.

tags : conversation marketingtools

related articles

2 Comments

  1. THanks Ian,
    I’ve been moving to GDocs and finding ways to do this really helps.
    Ivan

  2. Lois

    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,
    Lois

Comments are closed.