CREATE LIST OF AUTOMATION THAT DIDNT SEND EMAILS

[chiukim]

I would like to create an app/report that will summarize/generate all my bots under my account. 
1. Name of Bot - Given (key)

2. Date last send - will generate the last date was sent an email.

The reason for this is i want to monitor all my bots in my appsheet account, making sure that it sends daily in just One view or report. 
Asking for inputs. Thanks

This is the expected output. 

[Marc_Dillon]

Add an action to every single bot that adds a new row to a table.

[chiukim]

You mean to add an action to a new step per bot? is theres a possibility that the 1st step - email didnt work but the 2nd step - action worked? or if the 1st step didnt work the 2nd step didnt also?