Autofilled mogrt in Premiere with a json file

Hello everyone,

I'm trying for a project with a lot of different exports to automatically import data from a json file into a mogrt in Premiere and the rush accordingly.

To be a bit clearer, here's what I'd like to do:

- I have a folder with 500 video files

- I have a json file with 500 names linked with the previous files (could also be an excel tab. What's important is that I have, for each video file, a coresponding speaker name)

- I want to automatically create 500 sequences that each have a video file, and on top of that a mogrt layer with the right name.

My problem is that I could create those sequences with XML (for instance) but I can't force to add a mogrt on another chanel, neither tell what to filled in the mogrt.

I know I could do that in after effects maybe quicker, but I'll have to edit the rush later, so premiere is my hope here.

Do you know how I can achieve this? script? Specific format file? (xml, json, excel, csv, you name it)

Thank you so much!