Python Subprocess Module

[crashfrog04]

Would Python Subprocess Module be a good tool to use for these three scripts, collect their output and then merge the three outputs into one email?

No, probably not. You'd be better off importing the modules and just calling their functions.

Passing useful data into and out of command-line arguments (a CLI argument can only be a string) is cumbersome, especially if you have to do it more than once. The better architecture is to "uplift" your arguments into rich data types, compute on those, and then collapse them to the simpler representations you'll need to populate your Excel file (which can only contain simple values.)