Recommended and mentioned products
Similar to IFTTT and Zapier you can create automated tasks based on APIs from various services.
I'll also add Microsoft's Power Automate (Assuming you have access to Office 365.) But even if not, fully agree that VBA maybe a better integrated solution that's going to not run foul of the IT team (speaking as someone who made a courageous move to get Anaconda Python in an approved software list for.... 2 years.) Lots of macro recording options as well, so given a choice for time, this maybe the way forward.
Connect the apps you use everyday to automate your work and be more productive. 1,500+ apps and easy integrations - get started in minutes.
RegExr.com is an online tool to learn, build, and test Regular Expressions.
Changing formatting in text: Thats a two step process. 1. Understand the old format 2. Write into the new format. One tool to understand the old format are Regex. Here is a online tool to create regex expression: https://regexr.com/ . When you have it use the python regex library to use this on your excel text. For writing into new formats your could just use "f-string".