Automation to create related row monthly if originating row is in certain "status"

Hi again,

I was wondering if I can create with Automation this type of situation:

I want to have a row to represent an advertising campaign that I turn on and off throughout the year. I would have a column with a status of “on” or “off.” If the status is “on,” can I create with automation at the start of every month a related row that is a reminder to check in with the campaign or some kind of similar “task” associated with that row?

Thanks guys!

Hi @ABp

Maybe this post as giving you the right direction

Automated Text By Month