If you're not a coder, I highly recommend Flow (https://flow.microsoft.com/en-us/) Which is an automation platform designed to be used with MS office products.

There are also a lot of options in Azure , but they require a little bit more of coding (They are incredible powerful nonetheless).