Delete empty rows in google sheet from appsheet automation

[frankwanglinked]

Hi all, I am using google sheet as database. Have set up automation that delete a row when qty of this row is 0. Automation works fine, but if go back to google sheet, still can see that empty row in the middle of other rows. Is it possible to delete this empty row from appsheet automations? 

[Hussein_Osseily]

from appsheet, you can't beacuse the blank row is not recognized in appsheet as it misses the ID/ Key column value

Another workaround is to write a google apps script that deletes empty rows, and "call a script"in the automation that will delete these empty rows.

[frankwanglinked]

Thanks, good point! I will try this way.