There are a few ways you could do this.
Filip’s answer is great as it costs you nothing.
A few more alternatives are:
– using CompsFromSpreadsheet (super easy to setup, one time fee)
– Templater (similar to CompsFromSpreadsheet, but one level up in terms of functionality)
– Plainly (plainlyvideos(dot)com which is again similar to the two solutions above but it would allow you to render these videos in the cloud instead of using your machine)