Add data before the last empty row in the google sheet

[Paul Hudson]

Hi,
I am trying to find a way how I can add data to the last empty row in google sheet, I am maintaining my sheet from the bottom toward the top and I have added a code in google script to add a new row when the last empty row gets filled with any value, so in my case, new data will add to top last empty row of the sheet.
Thanks.

 

[Supreme]

Hey @Paul Hudson

As we can see from the screenshot you have left the 2nd row unattended and since the Google Sheets action step filled the data to it first.

So, please try again by not missing a row in your Google Sheets and try again.

 

[Paul Hudson]

Hey @Paul Hudson

As we can see from the screenshot you have left the 2nd row unattended and since the Google Sheets action step filled the data to it first.

So, please try again by not missing a row in your Google Sheets and try again.

thanks for the response, actually sheet could have many empty rows I just want to add posted data to the very last empty row.

 

[Supreme]

You may try using the "Google Sheets: Append New Value" action step to pass the data to Google Sheets.