Search the first empty row in a Google Sheet file

How To
3

Hello @Michelangelo_Romano,

What do you mean data validation is skipped? You try to enter data into that cell but it ends up blank?
Does what you’re trying to put into that cell pass the validation if you were entering it manually?
If I use Add a Row and one of the cells is a dropdown, it selects it correctly as long as I enter the text correctly.
Even if I don’t enter it correctly it still gets in the cell, but reports an error that that I must select an item from the list.

If you want to find the last used row there are a few ways I can think of.

  1. Use the Google Sheets Get Range Values module. Input a range you know will be outside the existing used range, but the module will only return those with data. If you have 43 rows of data it will return 43 bundles. That number 43 is the last used row so if you want to update a row, use 44 to use the next blank row.
  2. If you Add a Row, that module will return the row number data was added to. You can then use that row number in the update a row module.
  3. Use Google Sheets Make an API Call to query a single column and determine the last used row similar to option 1. Please see this post Add Column in Google Sheets module instead of Add Row - #4 by Donald_Mitchell
3 Likes