I do bookkeeping and office backend administration for a small sales company. I use Airtable as a semi-technical person to automate processes we used to drive b

I do bookkeeping and office backend administration for a small sales company. I use Airtable as a semi-technical person to automate processes we used to drive by hand in a google spreadsheet - the main one being commission calculation. I was able to put this together in the 10-15 hours per week that remains after I finish my core job responsibilities. I want to learn how to do things the 'real-code' way but the learning curve is steep! Low code tools like Airtable let me use the limited time I have available to get something up and running. I can add improvements incrementally as my skills expand. When I first set up the Airtable, I was importing data manually from our CRM and from our accounting software. Now I have an awful Postman collection rigged up that does the importing for me (but I have to click a button everyday to run it). I discovered Pipedream a few months ago and have used that to set up an email system that queries the Airtable database and returns relevant records. A sales rep enters an opportunity and gets an email with a list of leads tailored to that particular opportunity. This incentivizes the reps to add their data to the system. My next project is to set up emails to notify our new freight coordinator when a load needs to ship, that will query multiple related records and give her all the info she needs in one email, plus cc'ing the sales rep on the deal so they can coordinate. Our CRM almost does all of these things but there's always some limitation that holds us back, if we're just trying to use the out-of-the box tools. As someone who aspires to be a developer but is not there yet skill-wise, I really appreciate the low-code tools that let me stitch together horrible Frankenstein monsters of Javascript to let me automate some of the monkey work that I would otherwise be doing by hand. This then frees up my time to expand my skill-set and learn better ways of doing things. (Such as node.js on a Heroku server so I can put my javascript all in one place instead of scattered throughout all the little places you can put code in Postman.)