How to add new row automatically

Hey everyone. I would be very grateful if you could help me.
I have a problem that would like your solution. I want to add new row automatically when 1 column was key as enum.
For example:
I am using this appsheet as an daily checking part result. I create 1 column (Enum which has “Finish” and “Not finish”). I want this appsheet to automatically add new row which have the same column data except date which have to be the next day. when I key “Not finish”. Sorry if my English is not understand.

How can I use bot and event for this?
Thank you