Google Sheets Add a Row - Automation is adding a new row above the header, not in the first empty row

This worked for me - Google Sheets - Fixing the issue of row Insert happening at top of sheet

The client changed the spreadsheet without notice, and cell A1 was empty, causing the problem.