How to insert rows into Google Sheets at row 2 instead of end of file?

Hi Pabbly Connect,

I'm trying to add in entries from a form into a Google Spreadsheet in DECREASING order (aka the most recent entries at the top, the older entries at the bottom). However, Pabbly Connect upon adding a new row always adds it at the bottom.

There's two ways I was thinking of getting around this:

(1) Use the =sort function to autosort. The only problem is, sort takes data from a master sheet. So if I put data into Sheet 1, for example, then I would have to create a sorted version in Sheet 2. This would make triggers confusing, as then if I triggered from Sheet 2, I'd need to make sure to update Sheet 1 as well automatically. I'm also concerned that the autosoring on Sheet 2 would accidentally trigger the trigger column, since all the values would be updated and reordered.

(2) (better) Insert into row 2 of the spreadsheet (the top) instead of the bottom of the spreadsheet with Pabbly Connect. The only thing is, I don't know if Pabbly Connect supports this functionality.

If neither version works, is there a more efficient way of doing this? Right now I'm just manually sorting each time I read through it.

Thank you!

Hey @JeffreyYu

Currently there is no option avialable to feed the data in Google Sheets from top instead form the new row.

Hey @JeffreyYu

Currently there is no option avialable to feed the data in Google Sheets from top instead form the new row.

Would autosorting cause the spreadsheet to trigger the workflow each time it is sorted?

Got it. I’ll try it out