How to change sender's name when sending automated...

[Mygrate]

hi guys, is there a way to create an automation that sends an email at a date recorded in a base? the date is a future date and it changes depending on the record.

[TheTimeSavingCo]

Yeap, add a formula field to check whether today matches the date value in that field and make the automation trigger off that