Google Sheets Add new row related question.

[nghialele]

Hi guys, I am using Pabbly Connect to retrieve form data to put a new row in Google Sheets, but the thing is I want to Freeze the very first Row and wants all the new data to be inserted from second row onwards. Is it possible to make it work like this? Any configurations or tutorials will help. Thanks in advance!

 

[Pabbly]

Hi guys, I am using Pabbly Connect to retrieve form data to put a new row in Google Sheets, but the thing is I want to Freeze the very first Row and wants all the new data to be inserted from second row onwards. Is it possible to make it work like this? Any configurations or tutorials will help. Thanks in advance!

The current "Add New Row" action of Google Sheet will add the data in the next row itself. Can you confirm if you tested that action event? Please confirm.

 

[Pabblymember11]

Hey @nghialele

If you are using the "Google Sheets: Add New Row" action step then it will populate the data from the 1st row of the sheet.

But as a workaround, you can manually feed the data in the 1st row for afterward when your data get after the 2nd or third row then you can remove the data from the 1 st row.