I tried my hands on JavaScript in InDesign for the first time, and thankfully I was able to make a script which did what I was doing manually.

Will post the script here after proper testing and debugging.

Thanks and regards.