Add a new row in a table each month on the last day

[omyrco]

So, I want to

add a new row in a table
each month
on the last day
with The first column has the date of every new month

Like, each row will have a date of that month and I'll update the rest of the columns columns 

I am trying with bots, what I am doing is Event type -> schedule 
so I figure this out to make a trigger but how we can add a row?
Is it the right way? Is it possible to achieve this with AppSheet?

[Marc_Dillon]

The easiest way to add a new row would be to set up an "add new row" action, and run it from the Bot.

The problem I assume you're facing is that a basic schedule-event Bot can't run any actions, because all actions are built on specific tables, but a schedule-event is table-less. So the workaround there is to use the forEveryRow option, which then allows you to select a table, and include a condition expression to just run the event on a single row of the table (multiple options available there, simplest perhaps as just [_RowNumber]=2)