• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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

JeffreyYu

Member
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!
 
P

Pabblymember11

Guest
Hey @JeffreyYu

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