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.

Ian Lurie

Ian Lurie is the founder of Portent. He's been a digital marketer since the days of AOL and Compuserve (that's more than 25 years, if you're counting). Ian's recorded training for, writes regularly for the Portent Blog and has been published on AllThingsD, Smashing Magazine, and TechCrunch. Ian speaks at conferences around the world, including SearchLove, MozCon, Seattle Interactive Conference and ad:Tech. He has published several books about business and marketing: One Trick Ponies Get Shot, available on Kindle, The Web Marketing All-In-One Desk Reference for Dummies, and Conversation Marketing. Ian is now an independent consultant and continues to work with the Portent team, training the agency group on all things digital. You can find him at

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,

Leave a Reply

Your email address will not be published. Required fields are marked *

Close search overlay