Struggle with Google Drive, OpenAI and Video Maker

Hi Makers!

I am trying to create the Automation below for one of my clients.
I believe I have the right process, just need to fine-tune it and figure out some of this process.
I know Creatomate and Shotstack could probably create the video, but any other ideas would be helpful

Thanks!