Task Automation Solution Needed

My main objective is to remove as much manual work from our day-to-day processes as possible. I know I need reliable task automation, but I have not yet pinned down the exact steps or tools that will achieve the best result... (Budget: $250 - $750 USD, Jobs: Airtable, Automation, JavaScript, PHP, Power Automate, Python, Software Architecture, Zapier)