Hi,
Your question is very general so I will answer in general. There isn't a best solution. It is more of a what you are comfortable with in terms of knowledge and skills. Overall you have 3 main services you can use:
- Azure Automation account - suitable for more operations oriented engineers. As languages you can use PowerShell and Python.
- Azure Logic App - suitable for engineers that do not code much. This is a low code service. You have a pre-defined variety of actions you can use + some general actions in case you cannot find suitable in the specific ones.
- Azure Functions - suitable for more development oriented engineers. Supports vast number of languages including PowerShell, Python, c#, etc.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.