Skip to main content
Best answer

Fix Google Sheets New Spreadsheet Row from adding to the bottom?

  • November 14, 2021
  • 2 replies
  • 646 views

I set up an action to “Create Spreadsheet Row in Google Sheets”

It is simply just importing values into different cells in a new row.

Previously, they would be added to the bottom of the current filled rows, however recently they started adding to the bottom of the 500 row sheet. Is there a way to revert this so they dont create new rows at the very bottom?

Thanks

Best answer by mzsadiek

Hi @mdcooks ! So if I understand you correctly, you have a Google Spreadsheet, and the ‘Create Spreadsheet Row’ does not create a new row at the bottom of the filled rows, but at the bottom of the whole sheet? If so, are you sure that the ‘empty’ rows are completely empty? You could try to ‘delete’ the empty rows to be sure they are really empty.

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

2 replies

mzsadiek
Forum|alt.badge.img+5
  • Zapier Solution Partner
  • Answer
  • November 14, 2021

Hi @mdcooks ! So if I understand you correctly, you have a Google Spreadsheet, and the ‘Create Spreadsheet Row’ does not create a new row at the bottom of the filled rows, but at the bottom of the whole sheet? If so, are you sure that the ‘empty’ rows are completely empty? You could try to ‘delete’ the empty rows to be sure they are really empty.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 15, 2021

Hi @mdcooks 

Check the change history in the GSheet to determine what may have changed and when that could have caused the issue you are noticing.

https://support.google.com/docs/answer/190843