You'd only automate if its going to happen more than once. What is the business logic there?
If you have regular small volumes (under 200 rows), could you look at converting to MySQL or MSSQL, then using the SQL connector to run queries?
Edit - even this is not great, would need to schedule API workflow just to create the new rows.
I think every way is messy.