Best answer

How can I position the newly created row in Google Sheets at the bottom of the spreadsheet?

  • 16 June 2022
  • 3 replies
  • 150 views

Userlevel 1

Hello community!

I’m building an automation between Jira and Google sheet in order to creare a row for each issue created (in Jira).

My question regards where the new row will be addend in the google sheet, I would like it was placed at the bottom of the last filled row, instead it is added at the top (see red and green arrow below).

Is there a setting to have contro where the row is added?

Thank you!
Daniele

icon

Best answer by Danvers 16 June 2022, 14:53

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +12

Hi @Daniele!

The Google Sheets action Create Spreadsheet Row will add the row to the first blank row in the sheet. This is generally the bottom of the sheet, but if your sheet is set up so that there are gaps/blank rows further up, the Zap will add the information there. 

From your screenshot, it doesn’t look like you have a blank row, but can I just double check that isn’t the case? Thanks!

Userlevel 1

Hi @Danvers,
thank you very much for you reply!

I confirm you that now it works well, I had just to clean some rows.

Have a nice day!
Daniele

Userlevel 7
Badge +9

Ayy! We’re so glad to hear it! Thanks for keeping us in the loop how that worked for you. 🎉