If you move to Premiere Pro and After Effects, you can automate almost everything that you might want to edit and or composite. Both have their own scripting l

If you move to Premiere Pro and After Effects, you can automate almost everything that you might want to edit and or composite. Both have their own scripting language based on JavaScript and After Effects also uses plain JS. There are also a number of paid plugins which provide varying levels of no-code automation. For example there is one which connects to Google Sheets and creates a new AE comp from each spreadsheet row, replacing text, images from URLs, changing dimensions of objects, etc. all based on the values of the spreadsheet cells.