Thanks and for everyone else response, soz for not posting back.
But I've got the problem solved, at least I think so based on the progress I'm making so far.
The setup would be like this,
Email -> Microsoft Power Automate for parsing -> Save csv to dropbox -> IBridgePY via Python for the automated trading code and read csv as the signal -> Interactive Brokers
All be on Amazon EC2, but still looking for other alternatives. Still have to figure out dropbox integration on these virtual hosting, but I think it should be fine.
IBridgePy works quite well so far, and Python is just easy to use as I had previous R coding experiences.