Copying rows to the top of a sheet (Automation)


Hi Everyone,

This question was asked before but I have not found an answer. So asking again to see if there is any new development which I have missed.

I have set up an automation to copy rows from each project sheet to a master sheet (based on some trigger). The row for the first project was copied arbitrarily in the master sheet at the bottom (row 80). The subsequent rows were copied below 80.

Is there any way it will be copied from the first row.

In fact, there should be an option to select whether we can copy rows to the top of a sheet or bottom (similar to option in form responses).

We are dealing with over 200 projects. To manually drag the rows to the top of the master sheet or delete the blank rows is not feasible.

Thank you.