Google Sheets - Delete Row

Hi there, I’m new to this platform, so bear with me. I’ve got a scenario running where I need to delete the data for a given date before I load fresh data into the sheet. The header has a column called ‘date’ that I’d like to filter for a given date and delete those rows. How do I do this in Make? The Google Sheets → Delete a Row action is looking for a “Row number”.

You need to search rows and delete using the returned row ID

MSQUARE