I extensively use Integromat for automation. They offer a free solution which can be viable for many smaller implementations. If your IT folks are skeptical, have them do a little research.
Microsoft Power Automate (formerly Microsoft Flow) is also a very viable solution. You mentioned that your IT department does not want to trust 3rd parties... Do you guys use Outlook? Word? Excel? All Microsoft products just like Power Automate.