• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $149 (🏆Lifetime Access) - View offer

Google Sheets Add New Row

Status
Not open for further replies.
Something has recently changed since around November 1st with the "Add New Row" action for Google Sheets integration. This used to add the new row at the bottom of the sheet which was perfect but since November 1st now it adds the row at the top which makes no sense at all. Any column headings that are in row 1 get pushed down lower and lower now causing all sorts of issues with other integrated systems that rely upon the column header names in row 1. Why was this changed and can you please fix this promptly?
 

Supreme

Well-known member
Staff member
Hey @andrewstrealtor

Sorry for the inconvenience can you please tell us if you have added any gap or empty row between the first entered row in your desired sheets?

Further, can you please try reconfiguring the "Add New Row" action step once and then try again?
 
It appears that if cell A1 is blank, it will add a new row at the top instead of at the bottom. This means A1 can not be left blank which seems like something that should be corrected with Pabbly or with Google.
 

Supreme

Well-known member
Staff member
It's advisable to refrain from leaving empty spaces in the top rows of your sheets to prevent the inclusion of unnecessary row data in your automation process.
 
@Supreme
Same issue here. My first row is a header (A1 is not empty). But still the new rows are getting added on top (first row). I tried re-connecting the sheet and created flow. But still same issue. Please help.
 

Subin

Member
Staff member
@rajeswernaidu !

Please make sure that no header columns of the Google Sheet(row1) are empty.

Leaving any header columns empty will lead to adding new data on top of Google Sheets rows.
 
Status
Not open for further replies.
Top