Google script spreadsheet, email sending row based

I m trying to make a script that would make spreadsheet send an email if expiry date is less than today but for each row by itself.

So i have a spreadsheet that has expiry date, and email for each supplier and i want to send a reminder for the supplier email if the expiry date is less than today.

Each row of the spreadsheet contain information about a supplier and the script should check for the expiry date compare with today and it less than then send an email to the supplier email which exists in a cell.

I tried to do for loop and such but failed. any help is appreciated, thanks !