How to update the last row in google sheets

(alan) #1

Hi,

I want to know how to update the last row of a google sheets document, but i don’t know how. Also, don’t know how to obtain the last row id.

thanks.

(Sarah Palombo) #2

Hi Alan

Search and Get rows forces you to choose what row you need but unfortunately, you don’t know the row ID :worried:
Perhaps you could work with this in either of the following ways:

You could use a list rows to get the last row then use update row (now that you have the last row) .

Does that sound like this could work?

Sarah :slight_smile: