Please follow the below path to download the  Automated Notifications Report

Path: Communication---> Reports--->  Notifications Report---> Click on  Automated Notifications Report---> Select Notification Type, Date Type as Today/Last 7 days/Last 30 days/Date Range and click on Get----> Click on EXCEL Icon