Google Sheets - Add new row - Adds a row at the bottom where it doesn't makes sense

[yesildaladam]

I am trying to automate Greenhouse with Google Sheets. I have a webhook that is triggered everytime a new job is created. It does that completely fine but it creates the new row at the bottom of the sheet. I am wondering if it is possible to add a new row at the first empty row.

For example, I have a sheet with 60 populated rows, when a new job is created I want it to be added at 61th row. Right now it gets added to 927th row which makes no sense. Is this related with the column type? Should I delete every empty row?

[samliew]

Yes, you cannot have non-empty rows like that dropdown and checkbox.

An empty checkbox’s value is “FALSE”, which is still a value.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.