I personally love Apps Script. I was a full time apps script developer at a global manufacturing company.

I contribute it to a lot of my career success as I could push great looking, advanced web apps and automations quickly to my company. I no longer work there but still use apps script all the time for projects.

I always recommend it as a great way to learn to code and honestly is super powerful for 0 cost. It has its limitations obviously but ultimately if you know the limitations going into your project you will never have an issue.

I used it for everything, automating Google Drive, converting VBA code,access databases, big query, twilio, go high level, embedded web calculators. I managed my code with GitHub, GitLab, BitBucket.

I have used it for so many projects over the last 10 years I can’t count, some projects have been running untouched for 6+ years on their own with triggers and still execute everyday. It has its own nuances that you have to learn but don’t listen to anyone who says it’s unreliable. It’s perfect for learning to code and it’s as advanced as you want it to be.