Google sheets: getting the row I just appended

I didn’t complete my answer another feature of doing that is, when we need to make update operation we could select use number row to make update, just not key value that is today. This is good when you have duplicate keys on the sheet.